package bar;import java.awt.*;import javax.swing.*;import java.sql.*;import java.util.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class outMoney extends JPanel {  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JLabel jLabel4 = new JLabel();  JLabel jLabel5 = new JLabel();  JLabel jLabel6 = new JLabel();  JLabel jLabel7 = new JLabel();  JLabel jLabel8 = new JLabel();  public outMoney(int CID) {    try {      ComputerID = CID;      jbInit();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    this.setLayout(null);    jLabel1.setFont(new java.awt.Font("Serif", 0, 15));    jLabel1.setForeground(Color.black);    jLabel1.setText("機(jī)  器  號(hào)：");    jLabel1.setBounds(new Rectangle(120, 30, 80, 25));    jLabel2.setText(Integer.toString(ComputerID));    jLabel2.setBounds(new Rectangle(200, 30, 100, 25));    jLabel3.setFont(new java.awt.Font("Serif", 0, 15));    jLabel3.setText("卡       號(hào)：");    jLabel3.setBounds(new Rectangle(120, 80, 80, 25));    jLabel4.setText("");    jLabel4.setBounds(new Rectangle(200, 80, 100, 25));    jLabel5.setFont(new java.awt.Font("Serif", 0, 15));    jLabel5.setText("使用時(shí)間：");    jLabel5.setBounds(new Rectangle(120, 130, 80, 25));    jLabel6.setText("");    jLabel6.setBounds(new Rectangle(200, 130, 100, 25));    jLabel7.setFont(new java.awt.Font("Serif", 0, 15));    jLabel7.setText("此卡余額：");    jLabel7.setBounds(new Rectangle(120, 180, 80, 25));    jLabel8.setText("");    jLabel8.setBounds(new Rectangle(200, 180, 100, 25));    this.add(jLabel2, null);    this.add(jLabel1, null);    this.add(jLabel4, null);    this.add(jLabel3, null);    this.add(jLabel6, null);    this.add(jLabel5, null);    this.add(jLabel8, null);    this.add(jLabel7, null);    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");    String url = "jdbc:microsoft:sqlserver://keweixing:1433;DatabaseName=dbbar";    String username = "sa";    String password = "";    con = DriverManager.getConnection(url, username, password);    Statement stmt = con.createStatement();    ResultSet viewRs = stmt.executeQuery("select * from TimeMoneyView where ComputerID = "+ComputerID+" order by EventID desc");    viewRs.next();    eachMoney = Integer.parseInt(viewRs.getString("EachMoney"));    cardID = Integer.parseInt(viewRs.getString("CardID"));    jLabel4.setText(Integer.toString(cardID));    timeString = viewRs.getString("AllTime");    StringTokenizer st1 = new StringTokenizer(timeString," ");    st1.nextToken();    jLabel6.setText(st1.nextToken().toString());    viewRs.close();    cost = 0;    StringTokenizer st = new StringTokenizer(timeString," ");    st.nextToken();    StringTokenizer stt = new StringTokenizer(st.nextToken(),":");    cost += Integer.parseInt(stt.nextToken().toString()) *1.0*eachMoney;    cost += Integer.parseInt(stt.nextToken().toString()) *0.0166*eachMoney;    Statement insertstmt = con.createStatement();    int rs1 = insertstmt.executeUpdate("update Card set LeaveMoney = LeaveMoney-"+cost+" where CardId ="+cardID);    cost = 0;    if(rs1 != 0 ){      Statement leavestmt = con.createStatement();      ResultSet leaveMoney = leavestmt.executeQuery("Select LeaveMoney from Card where CardId ="+cardID);      leaveMoney.next();      jLabel8.setText(leaveMoney.getString("LeaveMoney"));    }    /*System.out.print(cost);    jLabel8.setText();    System.out.println(st.nextToken());    System.out.println(st.nextToken());    System.out.println(st.nextToken());    while (st.hasMoreTokens()) {         System.out.println(st.nextToken());     }*/  }  private float cost;  private int eachMoney;  private int cardID;  private String timeString;  private Connection con;  private int ComputerID;}