loginitem.java

jsp实现的购物车功能

package jspcart.login;

import jspcart.conn.*;
import java.sql.*;

public class loginItem {
  private String usename;
  private String pwd;
  private String ID;
  public loginItem() {
  }
  public loginItem(String name,String pwd){
    this.setUsename(name);
    this.setPwd(pwd);
  }
  public String getUsename() {
    return usename;
  }
  public void setUsename(String usename) {
    this.usename = usename;
  }
  public String getPwd() {
    return pwd;
  }
  public void setPwd(String pwd) {
    this.pwd = pwd;
  }
  public String getID() {
    return ID;
  }
//检验用户身份
  public boolean checkLogin(DBConnection db,loginItem login){
    boolean flag=false;
    ResultSet rst=null;
    String sql="select * from login";
    rst=db.Execsql(sql);
    try {
      while (rst.next()) {
        String name=rst.getString(2);
        String pwd=rst.getString(3);
        if (name.trim().equals(login.getUsename().trim()) && pwd.trim().equals(login.getPwd().trim())) {
          flag=true;
          break;
        }
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
    if(flag==true){
      return true;
    }
    else
      return false;
  }

  //添加用户
  public boolean addLogin(DBConnection db, loginItem login) {
    String sname=login.getUsename();
    String pwd=login.getPwd();
    String sql="insert into login values ('";
    sql += sname + "','" + pwd + "')";
    if(db.openSql(sql)==1){
      return true;
    }
    else
      return false;
  }
  //修改用户
  public boolean updateLogin(DBConnection db, loginItem login) {
    String sname = login.getUsename();
    String pwd = login.getPwd();
    String sql = "update login set usename='";
    sql += sname + "',pwd='" + pwd + "')";
    if (db.openSql(sql) == 1) {
      return true;
    }
    else
      return false;
  }
  //删除用户
  public boolean deleteLogin(DBConnection db,int id) {
    String sql = "delete login where ID=" + id;
    if (db.openSql(sql) == 1) {
      return true;
    }
    else
      return false;
  }
}