companydaoimpl.java

oa办公系统

package cn.jx.ecjtu.oa.ps.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.wanczy.dbutil.IResultSetHandler;
import cn.jx.ecjtu.oa.ps.dao.BaseDao;
import cn.jx.ecjtu.oa.ps.dao.CompanyDao;
import cn.jx.ecjtu.oa.ps.pojo.Company;
/**
 * 
 * CompanyDao的实现类
 * @author qiao
 * @version $Revision: 1.9 $
 * @since 1.0
 */
public class CompanyDaoImpl extends BaseDao implements CompanyDao {
	class ResultSet2Company implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new Company(rs.getInt("com_id"),
					           rs.getString("name"),
					           rs.getString("email"),
			                   rs.getString("address"),
			                   rs.getString("phone"),
			                   rs.getString("fax"),
			                   rs.getString("post"),
			                   rs.getString("web"),
			                   rs.getString("info"),
                               rs.getString("bank"));
		}
	}
	private ResultSet2Company resultSet2Company=new ResultSet2Company();
	/**
	 * 根据公司ID查询公司信息
	 */
	public Company findCompanyInfoByID(int com_id) {
		List list=dbAccess.executeQuery("select * from oa_Company where com_id=?",
				new Object[]{new Integer(com_id)},
				resultSet2Company);
		if(list.size()>0) return (Company)list.get(0);
		else return null;
	}
	/**
	 * 修改公司信息
	 */
	public int updateCompanyInfo(Company com) {
		return dbAccess.executeUpdate(
				"update oa_Company set name=?,email=?,address=?,phone=?,fax=?,post=?,web=?,info=?,bank=? where com_id=?",
				new Object[]{com.getName(),
						     com.getEmail(),
						     com.getAddress(),
						     com.getPhone(),
						     com.getFax(),
						     com.getPost(),
						     com.getWeb(),
						     com.getInfo(),
						     com.getBank(),
						     com.getCom_id()});
	}
	public int saveCompanyInfo(Company com) {
		return dbAccess.executeUpdate(
				"insert into oa_Company (com_id,name,email,address,phone,fax,post,web,info,bank) values (?,?,?,?,?,?,?,?,?,?)",
				new Object[]{com.getCom_id(),
						     com.getName(),
						     com.getEmail(),
						     com.getAddress(),
						     com.getPhone(),
						     com.getFax(),
						     com.getPost(),
						     com.getWeb(),
						     com.getInfo(),
						     com.getBank()});
	}
}