workjiludao.java

oa rar it is the jsp

package com.accp.oa.dao.imple;

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

public class WorkJiLuDao implements BaseDAO{

	WorkJiLuBean jiluBean;
	PublicClass pubcla = new PublicClass();//获得连接的公共类
	Connection conn;
	PreparedStatement pstmt;
	ResultSet rs;

	//添加工作记录
	public boolean add(Object obj) {
		jiluBean = (WorkJiLuBean)obj;
		boolean isSuccess = false;
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(Constants.ADDWORKJILUTABLE);
			pstmt.setString(1, jiluBean.getEname());
			pstmt.setString(2, jiluBean.getBname());
			pstmt.setString(3, jiluBean.getDateTimes());
			pstmt.setString(4, jiluBean.getBackPath());
			pstmt.setString(5, jiluBean.getPalnTitle());
			pstmt.setString(6, jiluBean.getPalnContent());
			pstmt.setString(7, jiluBean.getPalnThing());
			pstmt.setInt(8, jiluBean.getNumday());
			pstmt.setString(9, jiluBean.getPalnType());
			int num = pstmt.executeUpdate();
			if(num > 0)
			{
				isSuccess = true;
			}
			else
			{
				isSuccess = false;
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return isSuccess;
	}

	//查询特定的工作记录
	public Object search(Object obj) {
		jiluBean = (WorkJiLuBean)obj;
		ArrayList list = new ArrayList();
		String sql = "select * from WorkJiLuTable where 1 = 1";
		if(!jiluBean.getBname().equals(""))
		{
			sql += " and Bname = '" + jiluBean.getBname() + "'";
		}
		if(!jiluBean.getEname().equals(""))
		{
			sql += " and Ename = '" + jiluBean.getEname() + "'";
		}
		if(!jiluBean.getPalnType().equals(""))
		{
			sql += " and PalnType = '" + jiluBean.getPalnType() + "'";
		}
		if(!(jiluBean.getDateTimes()).toString().equals(""))
		{
			sql += " and DateTimes like '%" + jiluBean.getDateTimes() + "%'";
		}
		if(!jiluBean.getPalnThing().equals(""))
		{
			sql += " and PalnThing = '" + jiluBean.getPalnThing() + "'";
		}
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(sql);
			System.out.println(sql);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				WorkJiLuBean jiluBean2 = new WorkJiLuBean();
				jiluBean2.setId(rs.getInt(1));
				jiluBean2.setEname(rs.getString(2));
				jiluBean2.setBname(rs.getString(3));
				jiluBean2.setDateTimes(rs.getDate(4).toString());
				jiluBean2.setBackPath(rs.getString(5));
				jiluBean2.setPalnTitle(rs.getString(6));
				jiluBean2.setPalnContent(rs.getString(7));
				jiluBean2.setPalnThing(rs.getString(8));
				jiluBean2.setNumday(rs.getInt(9));
				jiluBean2.setPalnType(rs.getString(10));
				list.add(jiluBean2);
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return list;
	}

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

	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;
	}

}