?? querypanel.java
字號:
package card;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 queryPanel 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(); public queryPanel(String Name,String ID){ try { UserName = Name; CardID = ID; con = cardConnect.getconn(); jbInit(); } catch(Exception ex) { ex.printStackTrace(); } } void jbInit() throws Exception { this.setPreferredSize(new Dimension(300, 300)); this.setLayout(null); query = con.createStatement(); ResultSet rs =query.executeQuery("Select LeaveMoney from queryview where CardID = "+CardID); rs.next(); jLabel1.setFont(new java.awt.Font("Serif", 1, 18)); jLabel1.setForeground(Color.blue); jLabel1.setText("用 戶 名："); jLabel1.setBounds(new Rectangle(65, 40, 100, 30)); jLabel2.setFont(new java.awt.Font("Serif", 1, 18)); jLabel2.setText(UserName); jLabel2.setBounds(new Rectangle(165, 40, 100, 30)); jLabel3.setFont(new java.awt.Font("Serif", 1, 18)); jLabel3.setForeground(Color.blue); jLabel3.setText("卡 號："); jLabel3.setBounds(new Rectangle(65, 110, 100, 30)); jLabel4.setText(CardID); jLabel4.setBounds(new Rectangle(165, 110, 100, 30)); jLabel5.setFont(new java.awt.Font("Serif", 1, 18)); jLabel5.setForeground(Color.blue); jLabel5.setText("余 額："); jLabel5.setBounds(new Rectangle(65, 180, 100, 30)); jLabel6.setText(rs.getString("LeaveMoney")); jLabel6.setBounds(new Rectangle(165, 180, 100, 30)); this.add(jLabel1, null); this.add(jLabel2, null); this.add(jLabel3, null); this.add(jLabel4, null); this.add(jLabel5, null); this.add(jLabel6, null); } private String CardID; private Connection con; private String UserName; private Statement query;}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -