projectmanager.java

jsp制作的一个信息管理系统源码,完整实用版

package project;

import java.sql.*;
import java.util.Date;
import java.util.HashMap;
import common.DBManager;


/**
 * Title:ProjectManager
 * Description:项目管理
 * Copyright: Copyright (c) 2002
 * Company:
 * @author ConanVV
 * @version 1.0
 */

public class ProjectManager 
{

	public ProjectManager() 
	{
	
		// to do ...
	}
	

////////////////////////////得到所有项目的列表/////////////////////////////////
	public ResultSet getAll() 
	{	
		DBManager myDBManager = new DBManager();
		ResultSet rs = myDBManager.execQuery("select * FROM ProjectInfo ORDER BY Pid");		
		return rs;
	}
////////////////////////////得到一个项目的所有人员////////////////////////////////

	public ResultSet getProjectPerson(int pid) 
	{	
		DBManager myDBManager = new DBManager();
		ResultSet rs = myDBManager.execQuery("select * FROM TeacherProject where Pid="+pid+" ORDER BY Location");		
		return rs;
	}

///////////////////////////得到一个人员的所有项目//////////////////////////////

	public ResultSet getProject(int tid) 
	{	
		DBManager myDBManager = new DBManager();
		ResultSet rs = myDBManager.execQuery("select * FROM TeacherProject where Tid="+tid);		
		return rs;
	}


////////////////////////////得到所有为审计项目成员的列表/////////////////////////////
	public ResultSet getAllUnflag() 
	{	
		DBManager myDBManager = new DBManager();
		ResultSet rs = myDBManager.execQuery("select * FROM TeacherProject where Flag=0 ORDER BY Pid");		
		return rs;
	}
///////////////////////////////////////////////////////////////////////////////


////////////////////////////得到最大的项目号///////////////////////////////////
	public int maxPID()
	{
		DBManager myDBManager = new DBManager();
		int max=-1;
		ResultSet rs = myDBManager.execQuery("select max(Pid) FROM ProjectInfo ");		
		try {
			if(rs != null && rs.next())
			{	max=rs.getInt(1);
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.maxPID()" + ex.getMessage());
		}
		return max;
	}
//////////////////////////////////////////////////////////////////////////////

////////////////////////////加入一个项目///////////////////////////////////////
	public boolean newProject(String name,String info,String begintime,String endtime,int finance,String projectlevel,String source)
	{
		DBManager myDBManager = new DBManager();
		int pid=maxPID()+1;
		String myQueryString = "insert into ProjectInfo values("+pid+",'"+name+"','"+info+"','"+begintime+"','"+endtime+"',"+finance+",'"+projectlevel+"','"+source+"')";
		return myDBManager.execUpdate(myQueryString);
			
	}
//////////////////////////////////////////////////////////////////////////////
	

////////////////////////////删除一个项目///////////////////////////////////////
	public boolean deleteProject(int pid)
	{
			(new DBManager()).execDelete("delete from ProjectInfo where Pid="+pid);
			(new DBManager()).execDelete("delete from TeacherProject where Pid="+pid);
		return true;
	}
//////////////////////////////////////////////////////////////////////////////


//////////////////////////// 根据pid得到项目名字////////////////////////////////	
	public String getPName(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select Name FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String name=new String();
		name=null;
		try {
			if(rs!=null && rs.next())
			{	name= rs.getString(1);
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("NewsManager.getDeptName(int pid):" + ex.getMessage());
		}
		return name;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	
	
//////////////////////////// 根据项目名字得到pid/////////////////////////////	
	public int getPID(String name) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM ProjectInfo where Name='"+name+"'";
		ResultSet rs = myDBManager.execQuery(myQueryString);
		int pid=-1;
		try {
			if(rs != null && rs.next())
			{	pid= rs.getInt("Pid");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("NewsManager.getDeptName(int did):" + ex.getMessage());
		}
		return pid;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	
//////////////////////////// 根据pid得到项目来源/////////////////////////	
	public String getPSource(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String source= new String();
		source=null;
		try {
			if(rs != null && rs.next())
			{	source= rs.getString("Source");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPSource(int pid):" + ex.getMessage());
		}
		return source;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 根据pid得到项目开始时间/////////////////////////	
	public String getPBeginTime(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp= new String();
		temp=null;
		try {
			if(rs != null && rs.next())
			{	temp= rs.getString("BeginTime");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPBeginTime(int pid):" + ex.getMessage());
		}
		return temp;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 根据pid得到项目结束时间/////////////////////////	
	public String getPEndTime(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp= new String();
		temp=null;
		try {
			if(rs != null && rs.next())
			{	temp= rs.getString("EndTime");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPEndTime(int pid):" + ex.getMessage());
		}
		return temp;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////

//////////////////////////// 根据pid得到项目资金/////////////////////////	
	public int getPFinance(int pid) 
	{		   
		DBManager myDBManager = new DBManager();
		String myQueryString = "select Finance FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		int finance=-1;
		try {
			if(rs != null && rs.next())
			{	finance= rs.getInt("Finance");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPLevel(int pid):" + ex.getMessage());
		}
		return finance;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////


	
//////////////////////////// 根据pid得到项目级别/////////////////////////	
	public String getPLevel(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select ProjectLevel FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String lvl=new String();
		lvl=null;
		try {
			if(rs != null && rs.next())
			{	lvl= rs.getString("ProjectLevel");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPLevel(int pid):" + ex.getMessage());
		}
		return lvl;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 根据pid得到项目信息/////////////////////////	
	public String getPInfo(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select Info FROM ProjectInfo where Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String info= new String();
		info=null;
		try {
			if(rs != null && rs.next())
			{	info= rs.getString("Info");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getPInfo(int pid):" + ex.getMessage());
		}
		return info;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////

//////////////////////////// 查询项目信息///////////////////////////////////////	
	public ResultSet searchProject(int pid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * from ProjectInfo  where Pid="+pid;		
		return myDBManager.execQuery(myQueryString);																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 修改项目信息///////////////////////////////////////	
	public boolean updatePInfo(int pid,String name,String info,String btime,String etime,int finance,String lvl,String source) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "update ProjectInfo Set Info='"+info+"' , Name='"+name+"' , BeginTime='"+btime+"' , EndTime='"+etime+"' , Finance="+finance+" , ProjectLevel='"+lvl+"' , Source='"+source+"' where Pid="+pid;		System.out.print(myQueryString);
		return myDBManager.execUpdate(myQueryString);																			
	}
////////////////////////////////////////////////////////////////////////////////

//////////////////////////// 根据tid得到教师名字////////////////////////////////	
	public String getTName(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select Name FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String name=new String();
		name=null;
		try {
			if(rs != null && rs.next())
			{	name= rs.getString("Name");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getTName(int tid):" + ex.getMessage());
		}
		return name;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	
//////////////////////////// 根据tid得到教师职位///////////////////////////////	
	public String getTLocation(int pid,int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherProject where Tid="+tid+" and Pid="+pid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		try {
			if(rs != null && rs.next())
			{	temp= rs.getString("Location");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("ProjectManager.getTLocation(int tid):" + ex.getMessage());
		}
		return temp;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
		
	
	
//////////////////////////// 根据教师名字得到tid/////////////////////////////	
	public int getTID(String name) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Name='"+name+"'";
		ResultSet rs = myDBManager.execQuery(myQueryString);
		int tid=-1;
		try {
			if(rs != null && rs.next())
			{	tid= rs.getInt("Tid");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("NewsManager.getTID(String name):" + ex.getMessage());
		}
		return tid;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	


/////////////////////////////增加人员///////////////////////////////////////////
	public boolean addPerson(int tid,int pid,String location,int flag) 
	{
		return (new DBManager()).execInsert("insert into TeacherProject values("+tid+","+pid+",'"+location+"',"+flag+")");
	
	}


////////////////////////////////////////////////////////////////////////////////


/////////////////////////////删除人员///////////////////////////////////////////
	public boolean deletePerson(int pid,int tid) 
	{
		(new DBManager()).execDelete("delete from TeacherProject where Tid="+tid+" and Pid="+pid);
		return true;
	}
///////////////////////////////////////////////////////////////////////////////	
	
	
/////////////////////////////得到审核标志//////////////////////////////////////
	public int getFlag(int tid, int pid)
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherProject where Pid="+pid+"and Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		int flag=-1;
		try {
			if(rs != null && rs.next())
			{	flag= rs.getInt("Flag");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("NewsManager.getDeptName(int did):" + ex.getMessage());
		}
		return flag;
		
	}
//////////////////////////////////////////////////////////////////////////////	

/////////////////////////////设置审核标志//////////////////////////////////////
	public boolean setFlag(int tid, int pid)
	{
		int flag = getFlag(tid,pid);
		DBManager myDBManager = new DBManager();
		flag=1-flag;
		String myQueryString = "update TeacherProject set Flag="+flag+"where Pid="+pid+" and Tid="+tid;
		return myDBManager.execUpdate(myQueryString);
		
		
	}
//////////////////////////////////////////////////////////////////////////////	
	
	public static void main(String args[])
	{
		ProjectManager m = new ProjectManager();
		//System.out.println(m.newProject("古汉语","nothing","1999-1-1","2000-12-31",300,"Province","china"));
		//System.out.println(m.newProject("哈哈汉语","nothing","1999-1-1","2000-12-31",300,"Province","china"));
		//System.out.println(m.getTID("方一新"));
		//System.out.println(m.getTID("方新"));
		//System.out.println(m.getTName(1));
		//System.out.println(m.getTName(100));
		//System.out.println(m.addPerson(2,"方一新","1/1",1));
		//System.out.println(m.addPerson(1,"方新","1/1",1));
		//System.out.println(m.getPID("古汉语"));	
		//System.out.println(m.getPInfo(1));
		//System.out.println(m.getPName(1));
		//System.out.println(m.maxPID());
		
		//System.out.println(m.getAll());
		//System.out.println(m.getAllPerson(1));
		//System.out.println(m.getFlag(8,1));	
		//System.out.println(m.setFlag(8,1));		
		//System.out.println(m.getFlag(8,1));	
		//System.out.println(m.deletePerson(2,8));
		//System.out.println(m.deleteProject(1));
		//System.out.println(m.getPID("1"));
		//System.out.println(m.getTID("方一新"));
		//System.out.println(m.addPerson(8,1,"1",0));
		//System.out.println(m.searchProject(4));
		//System.out.println(m.getPFinance(1));
		//System.out.println(m.getPSource(1));
		//System.out.println(m.getPLevel(1));
		//System.out.println(m.getProjectPerson(5));
		//System.out.println(m.getPBeginTime(5));
		//System.out.println(m.getPEndTime(5));
		System.out.println(m.getProject(8));
		
	}
///////////////////////////////////////////////////////////////////////////////

}