user.java

挺好的东东

/***********************************************
 /*
 /*用户操作
 /*
 /******************************************* */
package com.index;

import java.sql.*;
import java.util.ArrayList;

import com.util.*;

public class User {
	
	  public String userid = "";
	  
	  public String userpwd="";
	  
	  public String username="";
	  
	  public int status=1;
	  
	  public String nickname="";
	  
	  public int mark;
	  
	  public String stepname="";
	  
	  public int qx;//身份标识(1教师 2学生)

	  
     public User() {
            	 
	 }
  
  //用户登陆
 	public int login() throws Exception{
	    Connection conn=null;
	    PreparedStatement stmt =null;
	    ResultSet rs =null;
	    int flag=0;
	      String sql = "select * from ts_users where userid=?";
	    try{
	      conn =DBConn.getConn();
	      stmt =conn.prepareStatement(sql); 
	      stmt.setString(1, userid);
	      rs = stmt.executeQuery();
	      if(rs.next()){
	    	  sql="select * from ts_users where userid=? and userpwd=?";
	    	  stmt =conn.prepareStatement(sql);
		      stmt.setString(1, userid);
		      stmt.setString(2, userpwd);
		      rs = stmt.executeQuery();
		       if(rs.next()){
		    	   qx=rs.getInt("qx");
		    	   nickname=rs.getString("nickname");
		    	   flag=3;//登陆成功
		       }
		       else{
		    	   flag=2;//密码错误
		       }
	      }else{
	        flag=1;//不存在此用户
	      }
	    }catch(Exception e){
	    	e.printStackTrace();   
	    }finally{
	      try{
	        if(rs!=null)
	          rs.close();
	        if(stmt!=null)
	          stmt.close();
	        if(conn!=null)
	          conn.close();
	      }catch(Exception ee){
	    	  ee.printStackTrace();   
	      }
	    }
	   return flag;
	  }

 	
 	  public Boolean UserInfo(String user_id) throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="select A.userid,A.nickname,A.mark,B.stepname,A.status,A.userpwd," +
 		  		      "A.qx,A.username " +
 		  	          "from ts_users A join know_step B on  A.status=B.step where userid=?";
 	      boolean result=false;
 	      
 	      try{
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setString(1,user_id);     	
 	    	 rs = stmt.executeQuery();    	 
 	    	     	  
 	    	  if (rs.next()){
 				  userid=rs.getString(1);
 	    		  nickname=rs.getString(2);
 	    		  mark=rs.getInt(3);
 	    		  stepname=rs.getString(4);
 	    		  status=rs.getInt(5);
 	    		  userpwd=rs.getString(6);
 	    		  qx=rs.getInt(7);
 	    		  username=rs.getString(8);
 	    		  if(username==null){
 	    			  username="<font color=red>未填写</font>";
 	    		  }
 	    		 if(nickname==null){
	    			  nickname="<font color=red>未填写</font>";
	    		  }

 	    		 result=true; 
 	    	  }
 	    	
 	    	}
 	      catch(Exception e){
 	    		e.printStackTrace(); 
 	    	}
 	    	finally{
 	    	      try{
 	    	        if(rs!=null)
 	    	          rs.close();
 	    	        if(stmt!=null)
 	    	          stmt.close();
 	    	        if(conn!=null)
 	    	          conn.close();
 	    	      }catch(Exception e){
 	    	    	  e.printStackTrace(); 
 	    	      }
 	    	    }
 	       return result;    	 
 	  } 	

 	  
// 	 	添加用户	
 	 public Boolean add() throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="select * from ts_users where userid=?";
 	      boolean result=false;
 	      
 	      try{
 			   
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setString(1,this.userid);
 	    	 
 	    	 rs=stmt.executeQuery(); 
 	    	 
 	    	 if(!rs.next()){
 	    		sql ="insert into ts_users (userid,qx) values (?,?)";
 	    		 stmt= conn.prepareStatement(sql); 
 	 	    	 stmt.setString(1,this.userid);
 	 	    	 stmt.setInt(2,this.qx);
 	 	    	 stmt.executeUpdate();
 	    		result=true; 
 	    	 }
 	    		 
 	    	
 	    	}
 	      catch(Exception e){
 	    		e.printStackTrace(); 
 	    	}
 	    	finally{
 	    	      try{
 	    	        if(rs!=null)
 	    	          rs.close();
 	    	        if(stmt!=null)
 	    	          stmt.close();
 	    	        if(conn!=null)
 	    	          conn.close();
 	    	      }catch(Exception e){
 	    	    	  e.printStackTrace(); 
 	    	      }
 	    	    }
 	       return result;    	 
 	  } 
 	  
//	 	删除用户	
 	 public Boolean del() throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="delete  from ts_users where userid=?";
 	      boolean result=false;
 	      
 	      try{
 			   
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setString(1,this.userid);
 	    	 
 	    	 stmt.executeUpdate();
 	    	 
 	    		result=true; 
     	
 	    	}
 	      catch(Exception e){
 	    		e.printStackTrace(); 
 	    	}
 	    	finally{
 	    	      try{
 	    	        if(rs!=null)
 	    	          rs.close();
 	    	        if(stmt!=null)
 	    	          stmt.close();
 	    	        if(conn!=null)
 	    	          conn.close();
 	    	      }catch(Exception e){
 	    	    	  e.printStackTrace(); 
 	    	      }
 	    	    }
 	       return result;    	 
 	  } 	  
 	  
//获取提问者信息
 	  public Boolean getAskerInfo(int id) throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="select A.nickname,A.mark,B.stepname,A.status,A.userid " +
 		  	          "from ts_users A join know_step B on  A.status=B.step join " +
 		  	          "know_article C on C.asker=A.nickname where C.id=?";
 	      boolean result=false;
 	      
 	      try{
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,id);     	
 	    	 rs = stmt.executeQuery();    	 
 	    	     	  
 	    	  if (rs.next()){
 				 
 	    		  nickname=rs.getString(1);
 	    		  mark=rs.getInt(2);
 	    		  stepname=rs.getString(3);
 	    		  status=rs.getInt(4);
 	    		  userid=rs.getString(5).trim();
 
 	    		 result=true; 
 	    	  }
 	    	
 	    	}
 	      catch(Exception e){
 	    		e.printStackTrace(); 
 	    	}
 	    	finally{
 	    	      try{
 	    	        if(rs!=null)
 	    	          rs.close();
 	    	        if(stmt!=null)
 	    	          stmt.close();
 	    	        if(conn!=null)
 	    	          conn.close();
 	    	      }catch(Exception e){
 	    	    	  e.printStackTrace(); 
 	    	      }
 	    	    }
 	       return result;    	 
 	  } 
 	  
 	  
// 	获取回答者信息
 	  public Boolean getAnswerInfo(int id) throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="select C.replier,A.mark,B.stepname,A.status,A.userid " +
 		  	          "from ts_users A join know_step B on  A.status=B.step join " +
 		  	          "know_answer C on C.replier=A.nickname where C.id=?";
 	      boolean result=false;
 	      
 	      try{
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,id);     	
 	    	 rs = stmt.executeQuery();    	 
 	    	     	  
 	    	  if (rs.next()){
 				 
 	    		  nickname=rs.getString(1);
 	    		  mark=rs.getInt(2);
 	    		  stepname=rs.getString(3);
 	    		  status=rs.getInt(4);
 	    		  userid=rs.getString(5).trim();
 
 	    		 result=true; 
 	    	  }
 	    	
 	    	}
 	      catch(Exception e){
 	    		e.printStackTrace(); 
 	    	}
 	    	finally{
 	    	      try{
 	    	        if(rs!=null)
 	    	          rs.close();
 	    	        if(stmt!=null)
 	    	          stmt.close();
 	    	        if(conn!=null)
 	    	          conn.close();
 	    	      }catch(Exception e){
 	    	    	  e.printStackTrace(); 
 	    	      }
 	    	    }
 	       return result;