auditingbean.java

职员问答管理系统(java).rar

package mypackage;

import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;

public class AuditingBean extends InfoBean
{
	
	private String Reply="";
	private String QuestionType="";
	private String QuestionID="";
	private String Question="";
	private String Auditing="";
	private String PurviewID="";

	
		
	//**************设置属性的get/set方法**************//
	//人员信息的属性从InfoBean继承
	
	public String getUserID()
	{
		return UserID;
	}
	public void setUserID(String newUser)
	{
		UserID=toChinese(newUser);
	}
	
	
	public String getPassword()
	{
		return Password;
	}
	public void setPassword(String newPassword)
	{
		Password=newPassword;
	}
	
	
	public String getUsername()
	{
		return Username;
	}
	public void setUsername(String newName)
	{
		Username=newName;
	}
	
	
	public String getCompany()
	{
		return Company;
	}
	public void setCompany(String newCompany)
	{
		Company=newCompany;
	}
	
	
	public String getAddress()
	{
		return Address;
	}
	public void setAddress(String newAddress)
	{
		Address=newAddress;
	}
	
	
	public String getTel()
	{
		return Tel;
	}
	public void setTel(String newTel)
	{
		Tel=newTel;
	}
	
	
		public String getReply()
	{
		return Reply;
	}
	public void setReply(String newReply)
	{
		Reply=newReply;
	}
	
	
	public String getQuestionID()
	{
		return QuestionID;
	}
	public void setQuestionID(String newQuestionID)
	{
		QuestionID=newQuestionID;
	}
	
	
	public String getQuestionType()
	{
		return QuestionType;
	}
	public void setQuestionType(String newQuestionType)
	{
		QuestionType=newQuestionType;
	}
	
	public String getQuestion()
	{
		return Question;
	}
	public void setQuestion(String newQuestion)
	{
		Question=newQuestion;
	}
	
	
	public String getAuditing()
	{
		return Auditing;
	}
	public void setAuditing(String newAuditing)
	{
		Auditing=newAuditing;
	}
	
	public String getPurviewID()
	{
		return PurviewID;
	}
	public void setPurviewID(String newPurviewID)
	{
		PurviewID=newPurviewID;
	}


	//在解答问题表单显示相关信息
	public void getUserInfo()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.*,QuestionInfo.*,QuestionTypeInfo.* from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and UserInfo.UserID='"+UserID+"' and QuestionInfo.QuestionID='"+QuestionID+"'";
			rs=executeQuery(sql);
			if(rs.next())
			{
				Username=rs.getString("Username");
				Company=rs.getString("Company");
				Address=rs.getString("Address");
				Tel=rs.getString("Tel");
				Question=rs.getString("QuestionDescribe");
				Reply=rs.getString("Reply");
				Auditing=rs.getString("Auditing");
				QuestionType=rs.getString("QuestionType");
			}
			rs.close();
			
		}
		catch(Exception e)
		{
			System.err.println("getUserInfo:"+e.getMessage());
		}
		
	}
	
	
	//浏览所有记录
	public ResultSet QueryAll()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryAll:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
	//根据用户姓名查询
	public ResultSet QueryByName()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and UserInfo.Username='"+Username+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByName:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
	//根据所属单位进行查询
	public ResultSet QueryByCompany()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and UserInfo.Company='"+Company+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryCompany:"+e.getMessage());
		}
		finally
		{
			return rs;
		
		}
	}
	
	
	
	//根据提问时间查询
	public ResultSet QueryByTime(java.sql.Date time)
	{
		
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and  datediff(day,'" + time + "', QuestionInfo.QuizTime)=0";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByTime:"+e.getMessage());
		}
		finally
		{
			return rs;
		
		}
	}
	
	
	
	//根据是否解答进行查询
	public ResultSet QueryByReply(boolean reply)
	{
		ResultSet rs=null;
		String sql="";
		if(reply==false)
		{
			sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and (QuestionInfo.Reply is null or QuestionInfo.Reply=' ')";

		}
		else
		{
			sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and (QuestionInfo.Reply is not null and QuestionInfo.Reply!=' ')";
		}
		
		try
		{
			
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByAuditing:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
		
	//根据是否通过审核进行查询
	public ResultSet QueryByAuditing(boolean auditing)
	{
		int bln=0;
		if(auditing==true)
		{
			bln=1;
		}
		else
		{
			bln=0;
		}
		
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.UserID,UserInfo.Username,UserInfo.Company,QuestionInfo.QuestionID,QuestionTypeInfo.QuestionType,QuestionInfo.QuizTime,QuestionInfo.QuestionDescribe,QuestionInfo.Reply,QuestionInfo.Auditing from UserInfo,QuestionInfo,QuestionTypeInfo where UserInfo.UserID=QuestionInfo.UserID and QuestionInfo.QuestionTypeID=QuestionTypeInfo.QuestionTypeID and  QuestionInfo.Auditing="+bln+"";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByAuditing:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
	//将审核结果写入数据库
	public boolean Auditing()
	{
		boolean bln=false;
		try
		{
			String sql="update QuestionInfo set Auditing='"+Auditing+"' where QuestionID='"+QuestionID+"'";
			bln=executeUpdate(sql);
		}
		catch(Exception e)
		{
			System.err.println("Reply:"+e.getMessage());
		}
		finally
		{
			return bln;
		}
	}
	
	
	//**********分配用户权限*******************
	
	
	//浏览所有用户记录
	public ResultSet QueryAllUser()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.*,PurviewInfo.* from UserInfo,PurviewInfo where UserInfo.PurviewID=PurviewInfo.PurviewID";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryAllUser:"+e.getMessage());
		}
		finally
		{
			return rs;
		
		}
	}
	
	
	//根据用户姓名查询
	public ResultSet QueryByUsername()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.*,PurviewInfo.* from UserInfo,PurviewInfo where UserInfo.PurviewID=PurviewInfo.PurviewID and UserInfo.Username='"+Username+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByUsername:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
	//根据所属单位进行查询
	public ResultSet QueryByUsercompany()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.*,PurviewInfo.* from UserInfo,PurviewInfo where UserInfo.PurviewID=PurviewInfo.PurviewID and UserInfo.Company='"+Company+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByUsercompany:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}


	public ResultSet QueryByUsertel()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.*,PurviewInfo.* from UserInfo,PurviewInfo where UserInfo.PurviewID=PurviewInfo.PurviewID and UserInfo.Tel='"+Tel+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByUsertel:"+e.getMessage());
		}
		finally
		{
			return rs;
			
		}
	}
	
	
	//为用户分配权限
	public boolean Distribute()
	{
		boolean bln=false;
		try
		{
			String sql="update UserInfo set PurviewID='"+PurviewID+"' where UserID='"+UserID+"'";
			bln=executeUpdate(sql);
		}
		catch(Exception e)
		{
			System.err.println("Distribute:"+e.getMessage());
		}
		finally
		{
			return bln;
		}
	}
		
	public void release()
	{
		closeConnection();
	}

}