user.java

挺好的东东

 	  } 	 	  
 
 	  
 //积分变动	  
   public Boolean UpMark(String userid,int award) throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="update ts_users set mark=mark+? where userid=?";
 	      boolean result=false;
 	      
 	      try{
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,award);  
 	    	 stmt.setString(2, userid);
 	    	 stmt.executeUpdate();    	 
 	    	
 	    	 //查询现有积分
 	    	sql ="select * from ts_users where userid=?";
 	    	stmt= conn.prepareStatement(sql); 
 	    	stmt.setString(1, userid);
 	    	 rs=stmt.executeQuery();
 	    	 if (rs.next()){
 	    	   mark=rs.getInt("mark");
 	    	 }
 	    	 
 	    	 //查询积分等级表，进行比较
 	    	 sql="select * from know_step";
 	    	stmt= conn.prepareStatement(sql); 
 	    	 rs=stmt.executeQuery();
 	    	 
 	    	 int i=0;
 	    	 while(rs.next() && i==0){
 	    		 if (mark<=rs.getInt("range")){
 	    			 status=rs.getInt("step");
 	    			 i++;
 	    			 
 	    		 } 	    		 
 	    	 }
 	    	 
 	    	 //更新用户等级
  	    	sql ="update ts_users set status=? where userid=?";
  	    	stmt= conn.prepareStatement(sql);  
  	    	stmt.setInt(1, status);
	    	 stmt.setString(2, 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 isUserNicknameExist() throws Exception{
		  Connection conn=null;
		  PreparedStatement stmt =null;
		  ResultSet rs =null;
		  String sql ="select * from ts_users where nickname=?";
	      boolean result=false;
	      
	      try{
			   
	    	 conn=DBConn.getConn();
	    	 stmt= conn.prepareStatement(sql); 
	    	 stmt.setString(1,this.nickname);
	    	 
	    	 rs=stmt.executeQuery(); 
	    	 
	    	 if(rs.next()){

	    		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 updateUser() throws Exception{
		  Connection conn=null;
		  PreparedStatement stmt =null;
		  ResultSet rs =null;
		  String sql ="update ts_users set username=?,nickname=? where userid=?";
	      boolean result=false;
	      
	      try{
			   
	    	 conn=DBConn.getConn();
	    	 stmt= conn.prepareStatement(sql); 
	    	 stmt.setString(1,username);
	    	 stmt.setString(2, nickname);
	    	 stmt.setString(3,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 changePwd() throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="update ts_users set userpwd=? where userid=?";
 	      boolean result=false;
 	      
 	      try{
 			   
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setString(1,userpwd);
 	    	 stmt.setString(2,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 isUserExist() 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()){

	    		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 ArrayList getStudents(int course_id) throws Exception{
		  	  Connection conn=null;
		  	  PreparedStatement stmt =null;
		  	  ResultSet rs =null;
		  	  String sql ="select * from t_subject where id=?";
		        ArrayList<User> result=new ArrayList<User>();
		        
		        try{
		      	 conn=DBConn.getConn();
		      	 stmt= conn.prepareStatement(sql); 
		      	 stmt.setInt(1,course_id);     	
		      	 rs = stmt.executeQuery();    	 
		      	     	  
		      	  if (rs.next() && rs.getString("student")!=null){
		      		 
		      		  String student=rs.getString("student").trim();
		      		  
		      		 String[] st=new String[200];

		      		 st=student.split("#");
		      		 
		     		 //按学号排序
		      		 String flag="";
		      		 for(int ii=1;ii<st.length;ii++){
		      			 for(int j=ii;j<st.length-1;j++){
		      				 if (Integer.parseInt(st[ii])>Integer.parseInt(st[j+1])){
		      					 flag=st[ii];
		      					 st[ii]=st[j+1];
		      					 st[j+1]=flag;
		      				 }
		      			 }
		      		 }
		      		 
		      		for(int i=0;i<st.length;i++){
		      			
		      			sql ="select * from ts_users where userid=?";
		      			
				      	 stmt= conn.prepareStatement(sql); 
				      	 stmt.setString(1,st[i]);     	
				      	 rs = stmt.executeQuery(); 
				      	 
				      	 if(rs.next()){
				      		 
				      		User aa=new User(); 
				      		aa.userid=rs.getString("userid");
				      		aa.username=rs.getString("username");
				      		result.add(aa);
				      		 
				      	 }
	      		  
		      		 }
		      		  
		      	  }
		      	
		      	}
		        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;    	 
	   }
}