?? cardmoneypanel.java~3~
字號:
package bar;import java.awt.*;import javax.swing.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class cardMoneyPanel extends JPanel { JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); public cardMoneyPanel(mainFrame mFrame1,int ID) { try { Frame1 = mFrame1; CardID = ID; jbInit(); } catch(Exception ex) { ex.printStackTrace(); } } void jbInit() throws Exception { this.setLayout(null); jLabel1.setFont(new java.awt.Font("Serif", 0, 16)); jLabel1.setText("卡號："); jLabel1.setBounds(new Rectangle(100, 75, 60, 30)); jLabel2.setText(Integer.toString(CardID)); jLabel2.setBounds(new Rectangle(180, 75, 90, 30)); jLabel3.setFont(new java.awt.Font("Serif", 0, 16)); jLabel3.setText("余額："); jLabel3.setBounds(new Rectangle(100, 135, 60, 30)); jLabel4.setBounds(new Rectangle(180, 135, 90, 30)); this.add(jLabel1, null); this.add(jLabel2, null); this.add(jLabel3, null); this.add(jLabel4, 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 rs = stmt.executeQuery("select LeaveMoney from Card where CardID ="+CardID); rs.next(); jLabel4.setText(rs.getString("LeaveMoney")); con.close(); } private mainFrame Frame1; private Connection con; private int CardID;}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -