userloginbean.java

网上购物系统

package Model_UserLogin;
import DataBase.ConDataBase;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Types;

public class UserLoginBean 
{
  public UserLoginBean()
  {
  }

  public String InsertUserLogin(UserLogin ul)
  {
    Connection con=ConDataBase.getConnection();
    
    try{
    CallableStatement csmt=con.prepareCall("{call INSERTUSERLOGIN(?,?,?)}");
    
    csmt.setString(1,ul.getLoginID());
    csmt.setString(2,ul.getPwd());
    csmt.registerOutParameter(3,Types.VARCHAR);
    
    csmt.execute();
    String re=csmt.getString(3);
    return re;
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return e.getMessage();
    } 
  }

  public String UpdateUserLogin(UserLogin ul)
  {
    Connection con=ConDataBase.getConnection();
    
    try{
    CallableStatement csmt=con.prepareCall("{call UPDATEUSERLOGIN(?,?,?)}");
    
    csmt.setString(1,ul.getLoginID());
    csmt.setString(2,ul.getPwd());
    csmt.registerOutParameter(3,Types.VARCHAR);
    
    csmt.execute();
    String re=csmt.getString(3);
    return re;
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return e.getMessage();
    } 
  }

  public String DeleteUserLogin(String loginid)
  {
    Connection con=ConDataBase.getConnection();
    
    try{
    CallableStatement csmt=con.prepareCall("{call DELETEUSERLOGIN(?,?)}");
    
    csmt.setString(1,loginid);
    csmt.registerOutParameter(2,Types.VARCHAR);
    
    csmt.execute();
    String re=csmt.getString(2);
    return re;
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return e.getMessage();
    } 
  }

  public String FinduserLogin(UserLogin ul)
  {
    Connection con=ConDataBase.getConnection();
    String Loginid=ul.getLoginID();
    try{
    PreparedStatement st=con.prepareStatement("select * from UserLogin where CustomerID=? and Pwd=?");
    st.setString(1,ul.getLoginID());
    st.setString(2,ul.getPwd());
    ResultSet rs=st.executeQuery();
    if (rs.next())
    {
      return Loginid;
    }
    else
    {
      return "用户不存在";
    }
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return e.getMessage();
    }
  }
  
}