person.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 Person {
  private int person_id;
  private int pid;
  private int mid;
  private String person_name;
  private Date person_start;
  private Date person_end;
  private boolean person_finish;
  private String person_fault;
public int getMid() {
	return mid;
}
public void setMid(int mid) {
	this.mid = mid;
}
public Date getPerson_end() {
	return person_end;
}
public void setPerson_end(Date person_end) {
	this.person_end = person_end;
}
public String getPerson_fault() {
	return person_fault;
}
public void setPerson_fault(String person_fault) {
	this.person_fault = person_fault;
}
public boolean isPerson_finish() {
	return person_finish;
}
public void setPerson_finish(boolean person_finish) {
	this.person_finish = person_finish;
}
public int getPerson_id() {
	return person_id;
}
public void setPerson_id(int person_id) {
	this.person_id = person_id;
}
public String getPerson_name() {
	return person_name;
}
public void setPerson_name(String person_name) {
	this.person_name = person_name;
}
public Date getPerson_start() {
	return person_start;
}
public void setPerson_start(Date person_start) {
	this.person_start = person_start;
}
public int getPid() {
	return pid;
}
public void setPid(int pid) {
	this.pid = pid;
}
public List<Person> getProjectPerson(int pid){
	List<Person> list=new ArrayList<Person>();
	Connection conn=DB.getConn();
	String sql="select *" +
			"from per_pro_mod,person " +
			"where person.person_id=per_pro_mod.person_id and per_pro_mod.pid="+pid;
	Statement stmt=DB.getStmt(conn);
	ResultSet rs=DB.getRs(stmt, sql);
	try {
		while(rs.next()){
		  Person p=new Person();
		  p.setPerson_id(rs.getInt("person_id"));
		  p.setPid(rs.getInt("pid"));
		  p.setMid(rs.getInt("mid"));
		  p.setPerson_name(rs.getString("person_name"));
		  p.setPerson_start(rs.getTimestamp("person_start"));
		  p.setPerson_end(rs.getTimestamp("person_end"));
		  p.setPerson_finish(rs.getBoolean("person_finish"));
		  p.setPerson_fault(rs.getString("person_fault"));
		  list.add(p);
		}
	} catch (SQLException e) {
		e.printStackTrace();
	} finally{
		DB.close(rs);
		DB.close(stmt);
		DB.close(conn);
	}
	return list;
}
public List<Person> getModulePerson(int mid){
	List<Person> list=new ArrayList<Person>();
	Connection conn=DB.getConn();
	String sql="select *" +
			"from per_pro_mod,person " +
			"where person.person_id=per_pro_mod.person_id and per_pro_mod.mid="+mid ;
	Statement stmt=DB.getStmt(conn);
	ResultSet rs=DB.getRs(stmt, sql);
	try {
		while(rs.next()){
		  Person p=new Person();
		  p.setPerson_id(rs.getInt("person_id"));
		  p.setPid(rs.getInt("pid"));
		  p.setMid(rs.getInt("mid"));
		  p.setPerson_name(rs.getString("person_name"));
		  p.setPerson_start(rs.getTimestamp("person_start"));
		  p.setPerson_end(rs.getTimestamp("person_end"));
		  p.setPerson_finish(rs.getBoolean("person_finish"));
		  p.setPerson_fault(rs.getString("person_fault"));
		  list.add(p);
		}
	} catch (SQLException e) {
		e.printStackTrace();
	} finally{
		DB.close(rs);
		DB.close(stmt);
		DB.close(conn);
	}
	return list;
}
}