movesearchjdbc.java

用jsp,servlet实现人力资源管理系统

 package com.servlet;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class MoveSearchJDBC {
	Statement stmt = null;
	Connection conn = null;
	String sql=null;
	ResultSet set=null;
		public List getInfo(String changeType,String empName,String changeFstate,String changeBstate){
			List list = new ArrayList();
		try {
			//注册
			
			 Class.forName("oracle.jdbc.driver.OracleDriver");
			//取得连接
			 conn = DriverManager.getConnection("jdbc:oracle:thin:@10.0.5.25:1521:KUANGTU","triones","tiger");
			//创建Statement
			 stmt = conn.createStatement();
			 System.out.println("OK");
			if(changeType==""&&empName==""&&changeFstate==""&&changeBstate==""){
				 sql="SELECT * from EMP_CHANGE";
			 }else{
			 sql="SELECT * from EMP_CHANGE where ";
			 if(changeType!=""){
				 sql = sql+"CHANGE_TYPE = '" + changeType +"'";
			 }
			 
			 if(changeType==""&&empName!=""){
				 sql = sql+"EMP_NAME = '"+empName + "'";
			 }else if(!(changeType=="")&&empName!=""){
				 sql = sql + "and EMP_NAME = '"+empName + "'";
			 }
			 
			 if(changeType==""&&empName==""&&changeFstate!=""){
				 sql = sql +"CHANGE_FSTATE >= '" + changeFstate +"'";
			 }else if(!(changeType==""&&empName=="")&&changeFstate!=""){
				 sql = sql + "and CHANGE_FSTATE = '"+changeFstate + "'";
			 }
			 
			 if(changeType==""&&empName==""&&changeFstate==""&&changeBstate!=""){
				 sql = sql +"CHANGE_BSTATE = '" + changeBstate +"'";
			 }else if(!(changeType==""&&empName==""&&changeFstate=="")&&changeBstate!=""){
				 sql = sql +"and CHANGE_BSTATE = '" + changeBstate +"'";
			 }
			 }
			 System.out.println(sql);
			 set=stmt.executeQuery(sql);
			 
			 //System.out.println(set.getString("CHANGE_TYPE"));

			 
			 MovesearchInfo user = null;
			 while(set.next()){
				//
				 user = new MovesearchInfo();
				 user.setChangeType(set.getString("Change_type"));
				 user.setEmpName(set.getString("Emp_name"));
				 user.setChangeFstate(set.getString("change_fstate"));
				 user.setChangeBstate(set.getString("change_bstate"));
				 user.setChangTime(set.getString("change_time"));
				 
				 
				//System.out.println(rs.getString("username"));
				list.add(user);
				
			}
			 
			} catch (SQLException e) {
				e.printStackTrace();
			}catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			return list;
		}
		public void connClose(){

			try {
				set.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}

		
	}