userinfo.java

网上商城

package store;
import java.sql.*;
public class UserInfo {
  private int userid;
  private String username;
  private String password;
  private String name;
  private String address;
  private String email;
  private String tel;
  public UserInfo(){}
  public void setUserid(int id){
    this.userid =id;
  }
 public int getUserid() {
 return userid;
 }
 public String getUsername() {
  return username;
  }
  public void setUsername(String name) {
    username = name;
  }
  public void setPassword(String psw) {
    password = psw;
  }
  public String getPassword() {
  return password;
  }
  public void setName(String name) {
   this.name = name;
  }
 public String getName() {
   return name;
  }
  public void setTel(String tel) {
  this.tel = tel;
  }
  public String getTel() {
   return tel;
  }
  public void setAddress(String addr){
   this.address = addr;
  }
  public String getAddress() {
  return address;
  }
  public void setEmail(String email) {
   this.email = email;
  }
  public String getEmail() {
   return email;
  }
  /*在确认客户信息时，
   *用userid为参数获取相关信息
   */
  public UserInfo getUserInfo(int userid)throws Exception{
    DBConn conn =new DBConn();    //连接数据库
    UserInfo UI=new UserInfo();
    String sql="SELECT * FROM customer WHERE id="+userid;
    ResultSet rs=conn.query(sql);
    if(rs.next()){
      UI.setEmail(rs.getString("email"));
      UI.setTel(rs.getString("tel"));
      UI.setName(rs.getString("name"));
      UI.setAddress(rs.getString("address"));
    }
    else{
      UI=null;
     }
    rs.close();
    conn.DBclose();
    return UI;
  }
  public String getPassword(int userid,DBConn conn) throws Exception {
    String pass;
    String sql2="SELECT password FROM customer WHERE id="+userid;
    ResultSet rs1=conn.query(sql2);
    if(rs1.next()){
      pass=rs1.getString("password");
    }
    else{
      pass="";
    }
    rs1.close();
    return pass;
  }

}