projects.java

适应各种系统的项目管理功能

package com.statistics.utilhansong;
import com.statistics.util.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class Projects {
   private int pid;
   private String pname;
   private int pcost;
   private String pdesc;
   private boolean pfinish;
   private String pfault;
   private Date pstart;
   private Date pend;
public int getPcost() {
	return pcost;
}
public void setPcost(int pcost) {
	this.pcost = pcost;
}
public String getPdesc() {
	return pdesc;
}
public void setPdesc(String pdesc) {
	this.pdesc = pdesc;
}
public Date getPend() {
	return pend;
}
public void setPend(Date pend) {
	this.pend = pend;
}
public String getPfault() {
	return pfault;
}
public void setPfault(String pfault) {
	this.pfault = pfault;
}
public boolean isPfinish() {
	return pfinish;
}
public void setPfinish(boolean pfinish) {
	this.pfinish = pfinish;
}
public int getPid() {
	return pid;
}
public void setPid(int pid) {
	this.pid = pid;
}
public String getPname() {
	return pname;
}
public void setPname(String pname) {
	this.pname = pname;
}
public Date getPstart() {
	return pstart;
}
public void setPstart(Date pstart) {
	this.pstart = pstart;
}
public static List<Projects> getProjects(){
	List<Projects> list=new ArrayList<Projects>();
	Connection conn=DB.getConn();
	String sql="select * from project;";
	Statement stmt=DB.getStmt(conn);
	ResultSet rs=DB.getRs(stmt, sql);
	try {
		while(rs.next()){
		  Projects p=new Projects();
		  p.setPid(rs.getInt("pid"));
		  p.setPname(rs.getString("pname"));
		  p.setPcost(rs.getInt("pcost"));
		  p.setPdesc(rs.getString("pdesc"));
		  p.setPfinish(rs.getBoolean("pfinish"));
		  p.setPfault(rs.getString("pfault"));
		  p.setPstart(rs.getTimestamp("pstart"));
		  p.setPend(rs.getTimestamp("pend"));
		  list.add(p);
		}
	} catch (SQLException e) {
		e.printStackTrace();
	} finally{
		DB.close(rs);
		DB.close(stmt);
		DB.close(conn);
	}
	return list;
}
}