publicclass.java

oa rar it is the jsp

package com.accp.oa.common;

import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import com.accp.oa.bean.BranchBean;
import com.accp.oa.bean.EmpBean;

public class PublicClass {

	Connection conn = null;

	PreparedStatement pstmt;

	ResultSet rs;
	
	Constants constants = new Constants();


//	查询部门名称
	public ArrayList SelectBranchName()
	{
		ArrayList list = new ArrayList();
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(Constants.SQLBRANCHTABLE);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				BranchBean bBean = new BranchBean();
				bBean.setBid(rs.getInt(1));
				bBean.setBname(rs.getString(2));
				list.add(bBean);
			}
			rs.close();
			pstmt.close();
			conn.close();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return list;
	}

	//查询对应部门的员工名称
	public ArrayList SelectEmpName(String Bname) {
		ArrayList list = new ArrayList();
		try
		{
			conn = DbUtil.connectToDB();
			pstmt = conn.prepareStatement(Constants.SQLEMPTABLE);
			pstmt.setString(1, Bname);
			rs = pstmt.executeQuery();
			while(rs.next())
			{
				EmpBean eBean = new EmpBean();
				eBean.setId(rs.getInt("Id"));
				eBean.setEname(rs.getString("Name"));
				eBean.setBname(rs.getString("Branch"));
				list.add(eBean);
			}
			rs.close();
			pstmt.close();
			conn.close();
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return list;
	}
	
	//将字符串对象转换为日期对象
	public Date formatStringToDate(String date)
	{
		SimpleDateFormat format = new SimpleDateFormat(Constants.FORMATDATE1);
		Date de = null;
		try {
			de = format.parse(date);
		} catch (ParseException e) {
			e.printStackTrace();
		}
		return de;
	}
	
	//获得当前时间
	public String formatCurrDateToString()
	{
		Date date = new Date();
		SimpleDateFormat format = new SimpleDateFormat(Constants.FORMATDATE2);
		String strDatetime = format.format(date);
		return strDatetime;
	}
}