unitdao.java

oa rar it is the jsp

package com.accp.oa.dao.imple;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.accp.oa.bean.*;
import com.accp.oa.common.*;
import com.accp.oa.dao.inface.*;

/*
 * 此DAO是对物资
 * 单位表进行的有关操作
 */
public class UnitDAO implements BaseDAO {

	/*
	 * 在此方法中
	 * 进行物资单位的
	 * 添加
	 * @see com.accp.oa.dao.inface.BaseDAO#add(java.lang.Object)
	 */
	public boolean add(Object unit) {
		boolean success = false;
		Unit objunit = (Unit)unit;
		Connection con = null;
		PreparedStatement stmt = null;
		try{
			con = DbUtil.connectToDB();
			stmt = con.prepareStatement(Constants.ADD_UNIT);
			stmt.setString(1, objunit.getUnitName());
			if(stmt.executeUpdate() > 0){
				success = true;
			}
		}catch(Exception ex){
			return false;
		}finally{
			try{
				stmt.close();
				con.close();
			}catch(Exception ex){
				
			}
		}
		return success;
	}

	public boolean delete(Object obj) {
		return false;
	}

	/*
	 * 此方法用于删除
	 * 物资单位
	 * @see com.accp.oa.dao.inface.BaseDAO#delete(int)
	 */
	public boolean delete(int unitId) {

		boolean success = false;
		Connection con = null;
		PreparedStatement stmt = null;
		try{
			con = DbUtil.connectToDB();
			stmt = con.prepareStatement(Constants.DELETE_UNIT);
			stmt.setInt(1, unitId);
			if(stmt.executeUpdate() > 0){
				success = true;
			}
		}catch(Exception ex){
			return false;
		}finally{
			try{
				stmt.close();
				con.close();
			}catch(Exception ex){
				
			}
		}
		return success;
	}

	public boolean delete(String ag0) {

		return false;
	}

	public Object search(Object obj) {

		return null;
	}

	public int search(String ag0, String ag1) {
		return 0;
	}

	public Object search(int id) {
		return null;
	}

	public ArrayList search(String age0) {
		return null;
	}

	public ArrayList search(int ag0, int age1) {

		return null;
	}

	/*
	 * 在此方法中
	 * 查询出所有的物资
	 * 单位
	 * @see com.accp.oa.dao.inface.BaseDAO#search()
	 */
	public ArrayList search() {
		ArrayList units = new ArrayList();
		Connection con = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try{
			con = DbUtil.connectToDB();
			stmt = con.prepareStatement(Constants.SEARCH_ALL_UNIT);
			rs = stmt.executeQuery();
			while(rs.next()){
				Unit unit = new Unit();
				unit.setId(rs.getInt("Id"));
				unit.setUnitName(rs.getString("Unit"));
				units.add(unit);
			}
		}catch(Exception ex){
			return null;
		}finally{
			try{
				rs.close();
				stmt.close();
				con.close();
			}catch(Exception ex){
				
			}
		}
		return units;
	}

	public boolean update(Object obj) {
		return false;
	}

}