worktongjidao.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.bean.WorkJinDuBean;
import com.accp.oa.dao.inface.BaseDAO;
import com.accp.oa.common.DbUtil;
import com.accp.oa.common.PublicClass;
import java.sql.*;

public class WorkTongJiDao implements BaseDAO{
	
	PublicClass pubcla = new PublicClass();//获得连接的公共类
	Connection conn;
	PreparedStatement pstmt;
	ResultSet rs;
	
	public ArrayList SelectJiLu(String Bname,String Ename,String BeginTime,String EndTime)
	{
		ArrayList list = new ArrayList();
		String sql = "select * from WorkJiLuTable where 1 = 1";
		if(!Bname.equals(""))
		{
			sql += " and Bname = '" + Bname + "'";
		}
		if(!Ename.equals(""))
		{
			sql += " and Ename = '" + Ename + "'";
		}
		if(!BeginTime.equals(""))
		{
			sql += " and DateTimes >= '" + BeginTime + "'";
		}
		if(!EndTime.equals(""))
		{
			sql += " and DateTimes <= '" + EndTime + "'";
		}
		System.out.println(sql);
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				WorkJiLuBean jiluBean = new WorkJiLuBean();
				jiluBean.setId(rs.getInt("id"));
				jiluBean.setEname(rs.getString("Ename"));
				jiluBean.setPalnTitle(rs.getString("PalnTitle"));
				jiluBean.setPalnContent(rs.getString("PalnContent"));
				jiluBean.setPalnType(rs.getString("PalnType"));
				list.add(jiluBean);
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return list;
	}
	
	public ArrayList SelectJinDu(String Bname,String Ename,String BeginTime,String EndTime)
	{
		ArrayList list = new ArrayList();
		String sql = "select * from WorkJinDuTable where 1 = 1";
		if(!Bname.equals(""))
		{
			sql += " and Bname = '" + Bname + "'";
		}
		if(!Ename.equals(""))
		{
			sql += " and Ename = '" + Ename + "'";
		}
		if(!BeginTime.equals(""))
		{
			sql += " and DateTimes >= '" + BeginTime + "'";
		}
		if(!EndTime.equals(""))
		{
			sql += " and DateTimes <= '" + EndTime + "'";
		}
		System.out.println(sql);
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				WorkJinDuBean jinduBean = new WorkJinDuBean();
				jinduBean.setId(rs.getInt("id"));
				jinduBean.setEname(rs.getString("Ename"));
				jinduBean.setWorkTitle(rs.getString("WorkTitle"));
				jinduBean.setBeginTime(rs.getDate("BeginTime").toString());
				jinduBean.setEndTime(rs.getDate("EndTime").toString());
				jinduBean.setNote(rs.getString("Note"));
				list.add(jinduBean);
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return list;
	}

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

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

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

	public boolean update(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;
	}

}