src/com/bar/db/User.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.bar.db;

import java.io.PrintStream;
import java.sql.ResultSet;

public class User extends ExecuteDB
{
  private long userid;
  private String uname;
  private String name;
  private String pwd;
  private String spwd;
  private String sex;
  private String email;
  private String address;
  private String tel;
  private String birth;
  private String post;
  private String safequestion;
  private String safeanswer;
  private String role;
  private float money;
  private String strSql;

  public User()
  {
    this.userid = 0L;
    this.uname = "";
    this.name = "";
    this.pwd = "";
    this.spwd = "";
    this.sex = "";
    this.email = "";
    this.address = "";
    this.tel = "";
    this.birth = "";
    this.post = "";
    this.safequestion = "";
    this.safeanswer = "";
    this.role = "1";
    this.money = 0.0F;
    this.strSql = "";
  }

  public boolean add()
  {
    this.strSql = "insert into users ";
    this.strSql += "(uname,name,pwd,spwd,sex,email,address,tel,birth,post,safequestion,safeanswer,role,money) ";
    this.strSql = (this.strSql + "values('" + this.uname + "','" + this.name + "','" + this.pwd + "','" + this.spwd + "','" + this.sex + "','" + this.email + "','" + this.address + "','" + this.tel + "','" + this.birth + "','" + this.post + "','" + this.safequestion + "','" + this.safeanswer + "','" + this.role + "','" + this.money + "')");
    boolean isAdd = super.exeSql(this.strSql);
    return isAdd;
  }

  public boolean delete(String sUserID)
  {
    this.strSql = "delete from users where userid in (";
    this.strSql = (this.strSql + sUserID + ")");

    boolean isDelete = super.exeSql(this.strSql);
    return isDelete;