bean.java

来自「基于j2ee中structs写软件」· Java 代码 · 共 37 行

package com.DAO;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.util.DB;

public class Bean {
	ArrayList<JobDAO> arraylist=new ArrayList<JobDAO>();
	public   ArrayList<JobDAO> getAllJobs(String condition){
		try{
		    DB db=new DB();
		    Connection conn=db.getConnection();
		    Statement sm=conn.createStatement();
		    ResultSet rs=sm.executeQuery(condition);
		    while(rs.next()){
		    	String id=String.valueOf(rs.getInt("jobId"));
		    	String type=rs.getString("jobType");
		    	String name=rs.getString("jobName");
		    	String num=String.valueOf(rs.getInt("staffNum"));
		    	String require=rs.getString("staffRequire");
		    	String start=rs.getDate("startDate").toString();
		    	String end=rs.getDate("endDate").toString();
		    	String info=rs.getString("relationInfo");
		    	JobDAO dao=new JobDAO(id,type,name,num,require,start,end,info);
		    	arraylist.add(dao);
		    }
		    conn.close();
		}catch(Exception e){}
		return arraylist;
		
	}

}