admincardrule.java

一个简单的机房管理系统 可以简单的实现查询,计费 上下机,充值等功能

package src.Rule;

import src.Bean.UpComputerCardBean;
import src.Conn.DateBiase;
import java.sql.SQLException;
import java.sql.ResultSet;

/**
 * 用户卡管理后台.
 */

public class adminCardRule {
  DateBiase objDB;
  public adminCardRule() throws Exception {
    objDB = new DateBiase();
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  //查找用户名是否存在.
  public boolean chickUserName(UpComputerCardBean cardBean) throws SQLException {
    String chickUserNamSQL = " select username from card where username = '" +
        cardBean.getUserName() + "'  ";
    ResultSet chickRs = objDB.objStatement.executeQuery(chickUserNamSQL);
    if (chickRs.next()) {
      return true;
    }
    else {
      return false;
    }
  }

  //将用户资料写入数据库
  public void intoCard(UpComputerCardBean CardBean) throws SQLException {
    //insert into card values('111',10 , '111' , 0)  --添加帐号
    String IntoCardSQL = " insert into card values('" + CardBean.getPassword() +
        "','" + CardBean.getBalace() + "','" + CardBean.getUserName() +
        "', 0 ) ";

    objDB.objStatement.executeUpdate(IntoCardSQL);
  }

  //给用户帐户充值
  public void insertBalance(UpComputerCardBean CardBean) throws SQLException {
    String inserSQL = " update card set balance = balance + '" +
        CardBean.getBalace() + "' where username = '" + CardBean.getUserName() +
        "' ";
    objDB.objStatement.executeUpdate(inserSQL);
  }

  //将新密码写入数据库
  public void setNewPass(UpComputerCardBean CardBean) throws SQLException {
    String setNewPassSQL = " update card set password = '"+CardBean.getPassword()+"' where username = '"+CardBean.getUserName()+"' ";
    objDB.objStatement.executeUpdate(setNewPassSQL);
  }

  //用户是否欠费!
  public boolean NotenoughtMoney(UpComputerCardBean CardBean) throws SQLException {
    String NotSQL = " select balance from card where balance <0 and username = '"+CardBean.getUserName()+"' ";
    ResultSet sumRs = objDB.objStatement.executeQuery(NotSQL);
    if (sumRs.next()){
      return true;
    }else{
      return false;
    }
  }

  //将用户从数据库中删除(真删除!该操作不可逆转!!请小心使用本方法)
  public void delUseName(UpComputerCardBean CardBean) throws SQLException {
    String delUserSQL = "delete from card where username = '"+CardBean.getUserName()+"' ";
    objDB.objStatement.executeUpdate(delUserSQL);
  }


  private void jbInit() throws Exception {
  }

}