quizbean.java

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

package mypackage;

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

public class QuizBean extends InfoBean
{
	private String QuestionTypeID="";
	private String Question="";
	
	
	//**************设置属性的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 getQuestionTypeID()
	{
		return QuestionTypeID;
	}
	public void setQuestionTypeID(String newType)
	{
		QuestionTypeID=newType;
	}
	
	public String getQuestion()
	{
		return Question;
	}
	public void setQuestion(String newQuestion)
	{
		Question=newQuestion;
	}
	
	//*************************************************
	
	
	//记录签到时间
	public boolean SignIn()
	{
		boolean bSign=false;
		try
		{
			String sql="insert into SigninTime(UserID,SigninTime) values('"+UserID+"',getDate())";
			if(executeUpdate(sql))
			{
				bSign=true;
			}
		}
		catch(Exception e)
		{
			System.err.println("SignIn:"+e.getMessage());
		}
		finally
		{
			return bSign;
		}
	}
	
	
	
	//获取用户相关信息，显示在发布问题的表单上
	public void getUserInfo()
	{
		ResultSet rs=null;
		try
		{
			String sql="select * from UserInfo where UserID='"+UserID+"'";
			rs=executeQuery(sql);
			if(rs.next())
			{
				Username=rs.getString("Username");
				Company=rs.getString("Company");
				Address=rs.getString("Address");
				Tel=rs.getString("Tel");
			}
			rs.close();
		}
		catch(Exception e)
		{
			System.err.println("getUserInfo:"+e.getMessage());
		}
	}
			
			
	
	
	
	//发布问题
	public boolean Quiz()
	{
		boolean bQuiz=false;
		try
		{
			String sql="insert into QuestionInfo(UserID,QuestionTypeID,QuestionDescribe,QuizTime) values('"+UserID+"','"+QuestionTypeID+"','"+Question+"',getDate())";
			if(executeUpdate(sql))
			{
				bQuiz=true;
			}
		}
		catch(Exception e)
		{
			System.err.println("Quiz:"+e.getMessage());
		}
		finally
		{
			return bQuiz;
		}
	}
	
	
	//从问题类型信息表中取出所有问题类型
	public ResultSet addTypeID()
	{
		ResultSet rs=null;
		try
		{
			String sql="select * from QuestionTypeInfo";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("addTypeID:"+e.getMessage());
		}
		finally
		{
			return rs;
		}
	}
	
	
	//浏览所有记录
	public ResultSet QueryAll()
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.Username,UserInfo.Company,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 QueryByType(String QuestionType)
	{
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.Username,UserInfo.Company,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 QuestionTypeInfo.QuestionType='"+QuestionType+"'";
			rs=executeQuery(sql);
		}
		catch(Exception e)
		{
			System.err.println("QueryByType:"+e.getMessage());
		}
		finally
		{
			return rs;
		}
	}
	
	
	//根据提问时间查询
	public ResultSet QueryByTime(String time)
	{
		ResultSet rs=null;
		try
		{
			System.out.println("time:"+time);
			String sql="select UserInfo.Username,UserInfo.Company,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 QueryByAuditing(boolean auditing)
	{
		int bln=0;
		if(auditing==true)
		{
			bln=1;
		}
		else
		{
			bln=0;
		}
		System.out.println(bln);
		ResultSet rs=null;
		try
		{
			String sql="select UserInfo.Username,UserInfo.Company,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 void release()
	{
		closeConnection();
	}
	
}