📄 wangbasystemmanage.txt
字号:
try {
jbInit();
} catch (Exception ex) {
ex.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setLayout(null);
String jph=(String)list.get(1);
String card = (String) list.get(0);
String bet = (String) list.get(2);
String endt = (String) list.get(3);
Integer fp = (Integer) list.get(4);
int ft=fp.intValue();
String fe=String.valueOf(ft);
System.out.println(fe);
Integer ba = (Integer) list.get(5);
int bc=ba.intValue();
String bal=String.valueOf(bc);
laljph.setText("机 器 号:");
laljph.setBounds(new Rectangle(88, 20, 78, 34));
laljphData.setText(jph);
laljphData.setBounds(new Rectangle(177, 21, 96, 29));
lalCard.setText("卡 号:");
lalCard.setBounds(new Rectangle(88, 63, 61, 29));
lalCardID.setText(card);
lalCardID.setBounds(new Rectangle(177, 58, 111, 30));
lalupTime.setText("上机时间:");
lalupTime.setBounds(new Rectangle(88, 99, 64, 28));
lalupData.setText(bet);
lalupData.setBounds(new Rectangle(177, 94, 150, 29));
laldownTime.setText("结束时间:");
laldownTime.setBounds(new Rectangle(88, 137, 68, 29));
laldownData.setText(endt);
laldownData.setBounds(new Rectangle(179, 136, 150, 28));
lalfee.setText("本次消费:");
lalfee.setBounds(new Rectangle(88, 177, 59, 25));
lalFeeData.setText(fe);
lalFeeData.setBounds(new Rectangle(177, 174, 74, 26));
lalBalance.setText("此卡余额:");
lalBalance.setBounds(new Rectangle(88, 215, 78, 29));
lalBalanceData.setText(bal);
lalBalanceData.setBounds(new Rectangle(173, 212, 80, 31));
this.add(lalCard);
this.add(lalupData);
this.add(laljphData);
this.add(lalCardID);
this.add(laldownData);
this.add(lalFeeData);
this.add(lalBalanceData);
this.add(lalupTime);
this.add(laljph);
this.add(laldownTime);
this.add(lalfee);
this.add(lalBalance);
}
}
-----------------------------------------------------------------文件分界线---------------------------------------------------------------------------------
package com.database;
/**
* <p>Title:对后台数据库的操作 </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: ACCP</p>
*
* @author xplu20000
* @version 1.0
*/
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import com.intermedium.*;
public class DbControl {
/**
* 功能:取出未使用的机器号;
* @return ArrayList 返回取出的机器号集合;
*/
public static ArrayList selectDown() {
ArrayList lise = new ArrayList();
Connection con = null;
PreparedStatement s = null;
ResultSet rs = null;
con = DbCon.connect();
try {
String sql = "select ID from Computer where OnUse=0";
s = con.prepareStatement(sql);
rs = s.executeQuery();
while (rs.next()) {
String nouse = rs.getString("ID");
lise.add(nouse);
}
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
DbCon.close(rs, s, con);
}
return lise;
}
/**
* 功能:验证卡号和密码;
* @param ca Card 接收卡号
* @return boolean 返回真或假
*/
public static boolean validate(Card ca) {
Connection con = null;
PreparedStatement s = null;
ResultSet rs = null;
boolean flag = false;
con = DbCon.connect();
try {
String sql = "select ID,Password from Card";
s = con.prepareStatement(sql);
rs = s.executeQuery();
while (rs.next()) {
String CardID = rs.getString("ID");
String pass = rs.getString("Password");
if (ca.getID().equals(CardID) && ca.getPassword().equals(pass)) {
flag = true;
break;
}
}
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
DbCon.close(rs, s, con);
}
return flag;
}
/**
* 功能:插入上机记录并改变机器的使用状态;
* @param co Computer 机器类(实体类)
* @param re Record 上机记录类(实体类)
*/
public static void insertBe(Computer co, Record re) {
Connection con = null;
PreparedStatement s = null;
PreparedStatement s2 = null;
con = DbCon.connect();
try {
String sq2 = "update computer set OnUse=1 where ID=?";
String sql =
"insert into Record (CardID,ComputerID,BeginTime) values (?,?,?)";
s = con.prepareStatement(sql);
s.setString(1, re.getCardID());
s.setString(2, re.getComputerID());
s.setString(3, re.getBeginTime());
s.executeUpdate();
s2 = con.prepareStatement(sq2);
s2.setString(1, co.getID());
s2.executeUpdate();
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
try {
s2.close();
DbCon.close(s, con);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
/**
* 功能:取出正在使用的机器号;
* @return ArrayList 返回取出的机器号数组;
*/
public static ArrayList selectON() {
ArrayList onus = new ArrayList();
Connection con = null;
PreparedStatement s = null;
ResultSet rs = null;
con = DbCon.connect();
try {
String sql = "select ID from Computer where OnUse=1";
s = con.prepareStatement(sql);
rs = s.executeQuery();
while (rs.next()) {
String onse = rs.getString("ID");
onus.add(onse);
}
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
DbCon.close(rs, s, con);
}
return onus;
}
/**
* 功能:修改下机时间，并改变此时间机器的使作状态;
* @param co Computer 机器类(实体类)
* @param re Record 上机记录类(实体类)
*/
public static void updataEd(Computer co, Record re) {
Connection con = null;
PreparedStatement s = null;
PreparedStatement s2 = null;
con = DbCon.connect();
try {
String sq2 = "update computer set OnUse=0 where ID=?";
String sql = "update Record set EndTime=? where ComputerID=?";
s = con.prepareStatement(sql);
s.setString(1, re.getEndTime());
s.setString(2, re.getComputerID());
s.executeUpdate();
s2 = con.prepareStatement(sq2);
s2.setString(1, co.getID());
s2.executeUpdate();
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
try {
s2.close();
DbCon.close(s, con);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
/**
* 功能:取出开始时间和结束时间;
* @param re Record 上机记录类(实体类)
* @return ArrayList 返回包含时间的数组;
*/
public static ArrayList timeContrast(Record re) {
ArrayList time = new ArrayList();
Connection con = null;
PreparedStatement s = null;
ResultSet rs = null;
con = DbCon.connect();
try {
String sql =
"select CardID,BeginTime,EndTime from Record where ComputerID=?";
s = con.prepareStatement(sql);
s.setString(1, re.getComputerID());
rs = s.executeQuery();
while (rs.next()) {
String card = rs.getString("CardID");
String be = rs.getString("BeginTime");
String ed = rs.getString("EndTime");
time.add(0, card);
time.add(1, be);
time.add(2, ed);
}
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
DbCon.close(rs, s, con);
}
return time;
}
/**
* 功能：修改本次上机费用，并更新卡余额;
* @param ca Card 卡类(实体类)
* @param re Record 上机记录类(实体类)
*/
public static void updataFee(Card ca, Record re) {
Connection con = null;
PreparedStatement s = null;
PreparedStatement s2 = null;
PreparedStatement s3 = null;
ResultSet rs = null;
int bal = 0;
con = DbCon.connect();
try {
String sq1 = "select Balance from Card where ID=?";
String sq2 = "update Record set Fee=? where ComputerID=?";
String sq3 = "update Card set Balance=? where ID=?";
s = con.prepareStatement(sq1);
s.setString(1, ca.getID());
rs = s.executeQuery();
while (rs.next()) {
bal = rs.getInt("Balance");
}
s2 = con.prepareStatement(sq2);
s2.setInt(1, re.getFee());
s2.setString(2, re.getComputerID());
s2.executeUpdate();
s3 = con.prepareStatement(sq3);
int balance = bal - re.getFee();
s3.setInt(1, balance);
s3.setString(2, ca.getID());
s3.executeUpdate();
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
try {
s2.close();
s3.close();
DbCon.close(rs, s, con);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
/**
* 功能:取出一条上机记录
* @param ca Card 卡类(实体类)
* @param re Record 上机记录类(实体类)
* @return ArrayList 返回一条上机记录
*/
public static ArrayList selectNote(Card ca, Record re) {
Connection con = null;
PreparedStatement s = null;
PreparedStatement s2 = null;
ArrayList li = new ArrayList();
ResultSet rs = null;
ResultSet rs2 = null;
con = DbCon.connect();
try {
String sq2 = "select Balance from Card where ID = ?";
String sql =
"select CardID,ComputerID,BeginTime,EndTime,Fee from Record where ComputerID=?";
s = con.prepareStatement(sql);
s.setString(1, re.getComputerID());
rs = s.executeQuery();
while (rs.next()) {
li.add(0, rs.getString("CardID"));
li.add(1, rs.getString("ComputerID"));
li.add(2, rs.getString("BeginTime"));
li.add(3, rs.getString("EndTime"));
li.add(4, rs.getInt("Fee"));
}
s2 = con.prepareStatement(sq2);
s2.setString(1, ca.getID());
rs2 = s2.executeQuery();
while (rs2.next()) {
li.add(5, rs2.getInt("Balance"));
}
} catch (SQLException ex1) {
ex1.printStackTrace();
} finally {
try {
rs2.close();
s2.close();
DbCon.close(rs, s, con);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
return li;
}
}
-----------------------------------------------------------------文件分界线---------------------------------------------------------------------------------
package com.database;
/**
* <p>Title:数据库连接 </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: ACCP</p>
*
* @author xplu20000
* @version 1.0
*/
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class DbCon {
/**
* 功能:获取连接;
* @return Connection 返回连接
*/
public static Connection connect() {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
try {
con = DriverManager.getConnection("jdbc:odbc:netbar");
} catch (SQLException ex1) {
ex1.printStackTrace();
}
return con;
}
/**
* 功能:关闭连接(有结果集);
* @param rs ResultSet 结果集
* @param s PreparedStatement 预编译
* @param con Connection 连接
*/
public static void close(ResultSet rs, PreparedStatement s, Connection con) {
try {
rs.close();
s.close();
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
/**
* 功能:关闭连接;
* @param s PreparedStatement 预编译
* @param con Connection 连接
*/
public static void close(PreparedStatement s, Connection con) {
try {
s.close();
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
-------------------------------------------------------
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -