personmanager.java

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

		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 int maxTID()
	{
		DBManager myDBManager = new DBManager();
		int max=-1;
		ResultSet rs = myDBManager.execQuery("select max(Tid) FROM TeacherInfo");		
		try {
			if(rs != null && rs.next())
			{	max=rs.getInt(1);
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("PersonManager.maxTID()" + ex.getMessage());
		}
		return max;
	}
//////////////////////////////////////////////////////////////////////////////

////////////////////////////得到所有教师的列表/////////////////////////////////
	public ResultSet getAllTeacher() 
	{	
		DBManager myDBManager = new DBManager();
		ResultSet rs = myDBManager.execQuery("select * FROM TeacherInfo ORDER BY Name,TeacherLevel");		
		return rs;
	}
///////////////////////////////////////////////////////////////////////////////


////////////////////////////加入一个教员///////////////////////////////////////
	public boolean addTeacher(String name,String sex,String edulvl,String teacherlvl,String info,String email,String tel,String fields, String photo)
	{
		DBManager myDBManager = new DBManager();
		int tid=maxTID()+1;
		String myQueryString = "insert into TeacherInfo values("+tid+",'"+name+"','"+sex+"','"+edulvl+"','"+teacherlvl+"','"+info+"','"+email+"','"+tel+"','"+fields+"','"+photo+"')";
		System.out.println(myQueryString);
		return myDBManager.execInsert(myQueryString);
			
	}
//////////////////////////////////////////////////////////////////////////////
	

////////////////////////////删除一个教师///////////////////////////////////////
	public boolean deleteTeacher(int tid)
	{
		return	(new DBManager()).execDelete("delete from TeacherInfo where Tid="+tid);
	}
//////////////////////////////////////////////////////////////////////////////


	
//////////////////////////// 根据tid得到教师性别////////////////////////////////	
	public String getTSex(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("Sex");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTSex(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	

	
//////////////////////////// 根据sid得到学历/////////////////////////////////////	
	public String getTEduLevel(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("EduLevel");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTEduLevel(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	
	
//////////////////////////// 根据tid得到职称/////////////////////////////////////	
	public String getTTeacherLevel(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("TeacherLevel");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTTeacherLevel(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	

/////////////////////////// 根据tid得到info/////////////////////////////////////	
	public String getTInfo(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("Info");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTInfo(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	

//////////////////////////// 根据tid得到email/////////////////////////////////////	
	public String getTEmail(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("Email");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTEmail(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	
	
//////////////////////////// 根据tid得到tel/////////////////////////////////////	
	public String getTTel(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("Tel");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTTell(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	
//////////////////////////// 根据tid得到fields/////////////////////////////////////	
	public String getTFields(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("Fields");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTFields(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	
//////////////////////////// 根据tid得到PhotoName/////////////////////////////////////	
	public String getTPhotoName(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherInfo where Tid="+tid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp=new String();
		temp=null;
		
		try {
			if(rs!=null && rs.next())
			{	temp= rs.getString("PhotoName");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("StudentManager.getTPhotoName(int tid):" + ex.getMessage());
		}
		return temp;																	
	}
////////////////////////////////////////////////////////////////////////////////
	


//////////////////////////// 查询教师信息///////////////////////////////////////	
	public ResultSet searchTeacher(int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * from TeacherInfo  where Tid="+tid;		
		return myDBManager.execQuery(myQueryString);																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 修改教师信息///////////////////////////////////////	
	public boolean updateTInfo(int tid,String name,String sex,String edulvl,String teacherlvl,String info,String email,String tel,String fields, String photo)	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "update TeacherInfo Set Name='"+name+"' , Sex='"+sex+"' , EduLevel='"+edulvl+"' , TeacherLevel='"+teacherlvl+"' , Info='"+info+"' , Email='"+email+"' , Tel='"+tel+"', Fields='"+fields+"', PhotoName='"+photo+"' where Tid="+tid;	
		//System.out.print(myQueryString);
		return myDBManager.execUpdate(myQueryString);																			
	}
////////////////////////////////////////////////////////////////////////////////





//////////////////////////////////////////////////////////////////////////////	
	
	public static void main(String args[])
	{
		PersonManager m = new PersonManager();
		//System.out.println(m.newHonor("a",null,"????-??-??",null,null,null,null));
		//System.out.println(m.newHonor("name","info","gettime","level","type","media","url"));
		//System.out.println(m.newProject("哈哈汉语","nothing","1999-1-1","2000-12-31",300,"Province","china"));
		//System.out.println(m.getTID("方一新"));
		//System.out.println(m.getSID("2"));
		//System.out.println(m.getTName(1));
		//System.out.println(m.getTName(100));
		//System.out.println(m.addPerson(8,4,"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.setFlag(8,1));	
		//System.out.println(m.deletePerson(2,8));
		//System.out.println(m.deleteProject(1));
		//System.out.println(m.getHType(3));
		//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.updatePInfo(4,"6","","","",1000,"",""));
		
		//System.out.println(m.getAllTeacher());
		//System.out.println(m.getTTeacherLevel(1));
		System.out.println(m.addTeacher("hoho",null,"","","","","","",""));
	}
///////////////////////////////////////////////////////////////////////////////

}