userinfo.java

jsp+javabean的一个在线考试系统的设计（包含教学文档）

package tom;

import java.sql.*;
import java.io.*;
public class UserInfo{
	private String username;
	private String password;
	private String email;
	private String age;
	private String sex;
    private String qq;
	private String type="0";
	
	public UserInfo(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		
	}
	
	public String getType(){return this.type;}	
	public void setQq(String qq){this.qq=qq;}
    public String getQq(){return this.qq;}	
	public void setUsername(String username){this.username=username;}
	public String getUsername(){return this.username;}
	public void setPassword(String pw){password=pw;	}
	public String getPassword(){return this.password;}
	public void setEmail(String email){this.email=email;}
	public String getEmail(){return this.email;}
	public void setAge(String age){this.age=age;}
	public String getAge(){return this.age;}
	public void setSex(String sex){this.sex=sex;}
	public String getSex(){return this.sex;}
	public boolean checkUser(){
		try{
			Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="SELECT username FROM userinfo WHERE username='"+this.username+"'";
			ResultSet rs=st.executeQuery(sql);
			
			if(rs.next()){
				return false;
				}
			else
			    return true;
		
		}
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;}
	}
	public boolean updateUser(){
		try{
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="INSERT INTO userinfo VALUES"+"('"+this.username+"','"+password+"','"+this.sex+"','"+this.age+"','"+this.qq+"','"+this.email+"','"+this.type+"')";
		    st.executeUpdate(sql);
		    return true;
		   
		    }
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;
			
		}
		
	}
	public boolean delUser(String name){
			try{
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="DELETE FROM userinfo WHERE username='"+name+"'";
		    st.executeUpdate(sql);
		    return true;
		    
		    }
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;
			
		}
	}
/*	public boolean delScore(String username,String time){
			try{
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql1="SELECT * FROM score WHERE username='"+username+"'";
			String sql2="DELETE FROM score WHERE time='"+time+",";
			st.addBatch(sql1);
			st.addBatch(sql2);
			st.executeBatch();
		    return true;
		    
		    }
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;
			
		}
	}*/
	
	public boolean delScore2(int id){
		try{
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="DELETE FROM score WHERE id='"+id+"'";
			st.executeUpdate(sql);
		    return true;
		    
		    }
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;
			
		}
	}
	
/*	public void scoreQuery(String username,javax.servlet.jsp.JspWriter out){
		try{
			Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="SELECT * FROM score WHERE username='"+username+"'";
			ResultSet rs=st.executeQuery(sql);
			try{
				out.print("<table width=749 border=1 cellpadding=0 cellspacing=0>");
		        out.print("<tr>");
		        out.print("<th width=78><font color=#0000FF>用户名</font></th>");
	            out.print("<th width=79><font color=#0000FF>单选题得分</font></th>");
                out.print("<th width=79><font color=#0000FF>判断题得分</font></th>");
                out.print("<th width=78><font color=#0000FF>总分</font></th>");
                out.print("<th width=337><font color=#0000FF>考试时间</font></th>");
                out.print("<th width=98><font color=#0000FF>操作</font></th>");
			
			    while(rs.next()){
			    	out.print("<tr>");
			    	out.print("<td>"+rs.getString("username")+"</td>");
					out.print("<td>"+rs.getInt("score1")+"</td>");
				    out.print("<td>"+rs.getInt("score2")+"</td>");
					out.print("<td>"+rs.getInt("score")+"</td>");
					out.print("<td>"+rs.getString("time")+"</td>");
					String s1="<form action=scoredel.jsp method=post>";
				    String s2="<input type=hidden name=time1 value="+rs.getString("time")+" >";
			        String s3="<input type=submit value=删除该信息></form>";
				    String s=s1+s2+s3;
				    out.print("<td>"+s+"</td>");
					out.print("</tr>");
				
			    }
			    out.print("</table>");
			}
			catch(IOException e){
			}
		}
		catch(SQLException e){
		}
	}*/
	}