JavaWeb用户登录

package com.scme.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.scme.entity.UserInfo;

public class UserInfoDao {
 private Connection con;
 private PreparedStatement pst;
 private ResultSet rst;
 //执行用户注册信息
 public boolean AddUser(UserInfo user){
  con=DBManager.getCon();
  //生成添加用户信息的sql语句
  String sql="insert into register values(?,?,?)";
  try {
   //从user 对象中取出值
   pst=con.prepareStatement(sql);
   pst.setString(1, user.getUserName());
   pst.setString(2, user.getUserPwd());
   pst.setString(3, user.getSex());
   //添加成功则判断信息
   int rows=pst.executeUpdate();
   if(rows>0){
    return true;
   }
   else{
    return false;
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   return false;
  }
  finally{
   DBManager.close(con, pst, rst);
  }
 }
 
 //根据用户的用户名和密码来查询信息
 public boolean Search(String userName,String userPwd){
  con=DBManager.getCon();
  //UserInfo user=new UserInfo();
  String sql="select * from register where username=? and userpwd=?";
  try {
   //执行sql语句
   pst=con.prepareStatement(sql);
   //获取用户的信息
   pst.setString(1,userName);
   pst.setString(2,userPwd);
   rst=pst.executeQuery();
   if(rst.next()){
    return true;
   }
   else{
    return false;
   }
  } catch (Exception e) {
   // TODO: handle exception
   return false;
  }
  finally{
   DBManager.close(con,pst,rst);
  }
 }
 
 //根据用户密码来删除用户的信息
 public boolean Delete(String userPwd){
  con=DBManager.getCon();
  String sql=" delete from register where userpwd=?";
  try {
   pst=con.prepareStatement(sql);
   pst.setString(1, userPwd);
   int rows=pst.executeUpdate();
   if(rows>0){
    return true;
   }
   else{
    return false;
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   return false;
  }
  finally{
   DBManager.close(con, pst, rst);
  }
  
 }
}