workjindudao.java

oa rar it is the jsp

package com.accp.oa.dao.imple;

import com.accp.oa.bean.WorkJinDuBean;
import com.accp.oa.dao.inface.BaseDAO;
import com.accp.oa.common.DbUtil;
import com.accp.oa.common.PublicClass;
import com.accp.oa.common.Constants;
import java.sql.*;
import java.util.*;

public class WorkJinDuDao implements BaseDAO {

	WorkJinDuBean jinduBean;

	PublicClass pubcla = new PublicClass();//获得连接的公共类

	Connection conn;

	PreparedStatement pstmt;

	ResultSet rs;

	
	//添加工组进度
	public boolean add(Object obj) {
		jinduBean = (WorkJinDuBean) obj;
		boolean isSuccess = false;
		try {
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(Constants.ADDJINDUTABLE);
			pstmt.setString(1, jinduBean.getEname());
			pstmt.setString(2, jinduBean.getBname());
			pstmt.setString(3, jinduBean.getWorkTitle());
			pstmt.setString(4, jinduBean.getBeginTime());
			pstmt.setString(5, jinduBean.getEndTime());
			pstmt.setString(6, jinduBean.getNote());
			int num = pstmt.executeUpdate();
			if (num > 0) {
				isSuccess = true;
			} else {
				isSuccess = false;
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return isSuccess;
	}

	//查询工作进度
	public Object search(Object obj) {
		jinduBean = (WorkJinDuBean) obj;
		ArrayList list = new ArrayList();
		String sql = "select * from WorkJinDuTable where 1 = 1";

		if (!jinduBean.getBname().equals("")) {
			sql += " and Bname = '" + jinduBean.getBname() + "'";
		}
		if (!jinduBean.getEname().equals("")) {
			sql += " and Ename = '" + jinduBean.getEname() + "'";
		}
		if (!jinduBean.getWorkTitle().equals("")) {
			sql += " and WorkTitle like '%" + jinduBean.getWorkTitle() + "%'";
		}
		try {
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				WorkJinDuBean jinduBean2 = new WorkJinDuBean();
				jinduBean2.setId(rs.getInt(1));
				jinduBean2.setEname(rs.getString(2));
				jinduBean2.setBname(rs.getString(3));
				jinduBean2.setWorkTitle(rs.getString(4));
				jinduBean2.setBeginTime(rs.getDate(5).toString());
				jinduBean2.setEndTime(rs.getDate(6).toString());
				jinduBean2.setNote(rs.getString(7));
				list.add(jinduBean2);
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return list;
	}

	public boolean update(Object obj) {
		// TODO 自动生成方法存根
		return true;
	}

	public boolean delete(Object obj) {
		// TODO 自动生成方法存根
		return true;
	}

	public boolean delete(int id) {
		// TODO 自动生成方法存根
		return false;
	}

	public boolean delete(String ag0) {
		// TODO 自动生成方法存根
		return false;
	}

	public int search(String ag0, String ag1) {
		// TODO 自动生成方法存根
		return 0;
	}

	public Object search(int id) {
		// TODO 自动生成方法存根
		return null;
	}

	public ArrayList search(String age0) {
		// TODO 自动生成方法存根
		return null;
	}

	public ArrayList search(int ag0, int age1) {
		// TODO 自动生成方法存根
		return null;
	}

	public ArrayList search() {
		// TODO 自动生成方法存根
		return null;
	}

}