loginbean.java

网上购物系统

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

public class LoginBean 
{
  public LoginBean()
  {
  }

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

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

  public String DeleteLogin(String loginid)
  {
    Connection con=ConDataBase.getConnection();
    
    try{
    CallableStatement csmt=con.prepareCall("{call DELETELOGIN(?,?)}");
    
    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 FindLogin(Login lg)
  {
    Connection con=ConDataBase.getConnection();
    String Loginid=lg.getLoginID();
    String Pwd=lg.getPwd();
    String Purview=lg.getLoginPurview();
    try{
    PreparedStatement st=con.prepareStatement("select * from Login where CustomerID=? and Pwd=? and Purview=?");
    st.setString(1,lg.getLoginID());
    st.setString(2,lg.getPwd());
    st.setString(3,lg.getLoginPurview());
    ResultSet rs=st.executeQuery();
    if (rs.next())
    {
      return Loginid;
    }
    else
    {
      return "用户不存在";
    }
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return e.getMessage();
    }
  }
}