honormanager.java

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

	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM HonorInfo where Hid="+hid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String media= new String();
		media=null;
		try {
			if(rs != null && rs.next())
			{	media= rs.getString("Info");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("HonorManager.getHMedia(int hid):" + ex.getMessage());
		}
		return media;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////

//////////////////////////// 根据pid得到URL信息/////////////////////////	
	public String getHUrl(int hid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM HonorInfo where Hid="+hid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String url= new String();
		url=null;
		try {
			if(rs != null && rs.next())
			{	url= rs.getString("Url");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("HonorManager.getHUrl(int hid):" + ex.getMessage());
		}
		return url;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////

//////////////////////////// 查询项目信息///////////////////////////////////////	
	public ResultSet searchHonor(int hid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * from HonorInfo  where Hid="+hid;		
		return myDBManager.execQuery(myQueryString);																			
	}
////////////////////////////////////////////////////////////////////////////////


//////////////////////////// 修改项目信息///////////////////////////////////////	
	public boolean updateHInfo(int hid,String name,String info,String gtime,String lvl,String type,String media,String url) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "update HonorInfo Set Name='"+name+"' , Info='"+info+"' , GetTime='"+gtime+"' , HonorLevel='"+lvl+"' , Type='"+type+"' , Media='"+media+"' , Url='"+url+"' where Hid="+hid;		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("HonorManager.getTName(int tid):" + ex.getMessage());
		}
		return name;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	
	
//////////////////////////// 根据教师名字得到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;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
	
/////////////////////////// 根据tid得到教师职位///////////////////////////////	
	public String getTLocation(int hid,int tid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherHonor where Tid="+tid+" and Hid="+hid;
		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("honorManager.getTLocation(int tid):" + ex.getMessage());
		}
		return temp;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////
		
	

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


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


/////////////////////////////删除人员///////////////////////////////////////////
	public boolean deletePerson(int tid,int hid) 
	{
		return (new DBManager()).execDelete("delete from TeacherHonor where Tid="+tid+" and Hid="+hid);
	
	}
///////////////////////////////////////////////////////////////////////////////	
	
	
/////////////////////////////得到审核标志//////////////////////////////////////
	public int getFlag(int tid, int hid)
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM TeacherHonor where Hid="+hid+"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("HonorManager.getflag(int tid, int hid):" + ex.getMessage());
		}
		return flag;
		
	}
//////////////////////////////////////////////////////////////////////////////	

/////////////////////////////设置审核标志//////////////////////////////////////
	public boolean setFlag(int tid, int hid)
	{
		int flag = getFlag(tid,hid);
		DBManager myDBManager = new DBManager();
		flag=1-flag;
		String myQueryString = "update TeacherHonor set Flag="+flag+"where Hid="+hid+" and Tid="+tid;
		if(myDBManager.execUpdate(myQueryString))
			return true;
		else
			return false;

		
	}
//////////////////////////////////////////////////////////////////////////////	

//////////////////////////// 根据pid得到项目时间/////////////////////////	
	public String getHGetTime(int hid) 
	{
		DBManager myDBManager = new DBManager();
		String myQueryString = "select * FROM HonorInfo where Hid="+hid;
		ResultSet rs = myDBManager.execQuery(myQueryString);
		String temp= new String();
		temp=null;
		try {
			if(rs != null && rs.next())
			{	temp= rs.getString("GetTime");
				rs.close();}
		} catch(SQLException ex) {
			System.err.println("honorManager.getHGetTime(int hid):" + ex.getMessage());
		}
		return temp;
		
																			
	}
////////////////////////////////////////////////////////////////////////////////

	
	public static void main(String args[])
	{
		HonorManager m = new HonorManager();
		//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.getTID("方新"));
		//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.getHonor(8));
		System.out.println(m.getTLocation(2,8));
	}
///////////////////////////////////////////////////////////////////////////////

}