package com.hacker.web.dao;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.hacker.common.BaseDB;
import com.hacker.struts.form.LogonForm;

public class UserinfoDao {
	private BaseDB db = new BaseDB();
	private PreparedStatement pstmt = null;
	private String sql = "select * from userinfo";
	public Object islogon(LogonForm logonForm){
		String sqlStr = sql+" where userName = '"+logonForm.getUserName()+"' and passWord = '"+logonForm.getPassWord()+"'";
		//System.out.println(sqlstr);
		Object o = db.executeSingleQuery(sqlStr, LogonForm.class);
		return o;	
	}
	public List getAll() throws SQLException{
		List<LogonForm> list = new ArrayList();
		list = db.executeQuery(sql);
		return list; 
	}
	public void save(LogonForm logonForm) throws SQLException{
		String sql = "insert into userinfo(userName,passWord) values('"+logonForm.getUserName()+"','"+logonForm.getPassWord()+"')";
		db.executeUpdate(sql);
	}
	public Object findByKey(LogonForm logonForm){
		String sqlStr = sql+" where id = "+logonForm.getId()+"";
		System.out.println(sql);
		Object o = db.executeSingleQuery(sqlStr, LogonForm.class);
		return o;
	}
	public void update(LogonForm logonForm) throws SQLException{
		String sql = "update userinfo set userName = '"+logonForm.getUserName()+"',passWord = '"+logonForm.getPassWord()+"' where id = "+logonForm.getId()+"";
		db.executeUpdate(sql);
	}
	public void delete(String id) throws SQLException{
		String sql = "delete from userinfo where id = "+id+"";
		db.executeUpdate(sql);
	}
	public void deleteSelect(String[] ids) throws SQLException{
		for (int i = 0; i < ids.length; i++) {
			String sql = "delete from userinfo where id = "+ids[i]+"";
			db.executeUpdate(sql);
		}	
	}
}