modules.java

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

package com.statistics.utilhansong;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.statistics.util.*;
public class Modules {
  private int mid;
  private int pid;
  private String mname;
  private boolean mfinish;
  private String mdescr;
  private String mfault;
public String getMdescr() {
	return mdescr;
}
public void setMdescr(String mdescr) {
	this.mdescr = mdescr;
}
public String getMfault() {
	return mfault;
}
public void setMfault(String mfault) {
	this.mfault = mfault;
}
public boolean isMfinish() {
	return mfinish;
}
public void setMfinish(boolean mfinish) {
	this.mfinish = mfinish;
}
public int getMid() {
	return mid;
}
public void setMid(int mid) {
	this.mid = mid;
}
public String getMname() {
	return mname;
}
public void setMname(String mname) {
	this.mname = mname;
}
public int getPid() {
	return pid;
}
public void setPid(int pid) {
	this.pid = pid;
}
public List<Modules> getModules(int pid){
	List<Modules> list=new ArrayList<Modules>();
	Connection conn=DB.getConn();
	String sql="select * from module where pid="+pid;
	Statement stmt=DB.getStmt(conn);
	ResultSet rs=DB.getRs(stmt, sql);
	try {
		while(rs.next()){
		  Modules m=new Modules();
		  m.setPid(rs.getInt("pid"));
		  m.setMid(rs.getInt("mid"));
		  m.setMname(rs.getString("mname"));
		  m.setMfinish(rs.getBoolean("mfinish"));
		  m.setMdescr(rs.getString("mdescr"));
		  m.setMfault(rs.getString("mfault"));
		  list.add(m);
		}
	} catch (SQLException e) {
		e.printStackTrace();
	} finally{
		DB.close(rs);
		DB.close(stmt);
		DB.close(conn);
	}
	return list;
}
}