?? customer_frame.java
字號:
package app;import java.awt.*;import java.awt.event.*;import javax.swing.*;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import com.borland.jbcl.layout.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author unascribed * @version 1.0 */public class Customer_Frame extends JFrame { private JPanel contentPane; private Database DB_Customer = new Database(); private JButton jButton1 = new JButton(); private QueryDataSet queryDataSet_Customer = new QueryDataSet(); private TableScrollPane tableScrollPane1 = new TableScrollPane(); private JdbTable jdbTable1 = new JdbTable(); private JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar(); private JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel(); private JLabel jLabel1 = new JLabel(); private JdbNavField jdbNavField1 = new JdbNavField(); private JLabel jLabel2 = new JLabel(); private JdbTextField jdbTextField1 = new JdbTextField(); private JLabel jLabel3 = new JLabel(); private JdbTextField jdbTextField2 = new JdbTextField(); private JLabel jLabel4 = new JLabel(); private JdbTextField jdbTextField3 = new JdbTextField(); private JLabel jLabel5 = new JLabel(); private JdbTextField jdbTextField4 = new JdbTextField(); private JLabel jLabel6 = new JLabel(); private JdbTextField jdbTextField5 = new JdbTextField(); private JLabel jLabel7 = new JLabel(); private JdbTextField jdbTextField6 = new JdbTextField(); private JLabel jLabel8 = new JLabel(); private JdbTextField jdbTextField7 = new JdbTextField(); private JLabel jLabel9 = new JLabel(); private JdbTextField jdbTextField8 = new JdbTextField(); private JLabel jLabel10 = new JLabel(); private JLabel jLabel11 = new JLabel(); private JLabel jLabel12 = new JLabel(); private JLabel jLabel13 = new JLabel(); private JLabel jLabel14 = new JLabel(); private JdbTextField jdbTextField9 = new JdbTextField(); private JdbTextField jdbTextField10 = new JdbTextField(); private JdbTextField jdbTextField11 = new JdbTextField(); private JdbTextField jdbTextField12 = new JdbTextField(); private JdbTextField jdbTextField13 = new JdbTextField(); private JButton jButton2 = new JButton(); private JLabel jLabel15 = new JLabel(); private JdbTextField jdbTextField14 = new JdbTextField(); //Construct the frame public Customer_Frame() { enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } //Component initialization private void jbInit() throws Exception { //setIconImage(Toolkit.getDefaultToolkit().createImage(Customer_Frame.class.getResource("[Your Icon]"))); contentPane = (JPanel) this.getContentPane(); DB_Customer.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:grrc", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver")); contentPane.setLayout(null); this.setSize(new Dimension(1022, 725)); this.setTitle("Frame Title"); jButton1.setBounds(new Rectangle(901, 374, 100, 29)); jButton1.setText("保 存 更 改"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { jButton1_actionPerformed(e); } }); queryDataSet_Customer.setTableName(""); queryDataSet_Customer.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(DB_Customer, "SELECT * FROM customer", null, true, Load.ALL)); tableScrollPane1.setBounds(new Rectangle(7, 51, 1005, 225)); jdbTable1.setDataSet(queryDataSet_Customer); jdbNavToolBar1.setDataSet(queryDataSet_Customer); jdbNavToolBar1.setBounds(new Rectangle(11, 6, 1001, 41)); jdbStatusLabel1.setDataSet(queryDataSet_Customer); jdbStatusLabel1.setBounds(new Rectangle(2, 698, 320, 20)); jLabel1.setText("查詢姓名："); jLabel1.setBounds(new Rectangle(12, 295, 60, 25)); jdbNavField1.setText("jdbNavField1"); jdbNavField1.setColumnName("C_NAME"); jdbNavField1.setDataSet(queryDataSet_Customer); jdbNavField1.setBounds(new Rectangle(93, 293, 113, 29)); jLabel2.setBounds(new Rectangle(14, 340, 68, 25)); jLabel2.setAlignmentY((float) 10.0); jLabel2.setText("類別："); jdbTextField1.setColumnName("C_LB"); jdbTextField1.setDataSet(queryDataSet_Customer); jdbTextField1.setBounds(new Rectangle(95, 337, 111, 31)); jLabel3.setAlignmentY((float) 10.0); jLabel3.setText("生 日："); jLabel3.setBounds(new Rectangle(11, 388, 66, 25)); jdbTextField2.setBounds(new Rectangle(95, 385, 110, 31)); jdbTextField2.setDataSet(queryDataSet_Customer); jdbTextField2.setColumnName("C_BIRTHDAY"); jLabel4.setBounds(new Rectangle(14, 431, 54, 25)); jLabel4.setAlignmentY((float) 10.0); jLabel4.setText("Email ："); jdbTextField3.setColumnName("C_EMAIL"); jdbTextField3.setDataSet(queryDataSet_Customer); jdbTextField3.setBounds(new Rectangle(93, 427, 112, 31)); jLabel5.setAlignmentY((float) 10.0); jLabel5.setText("家庭地址 ："); jLabel5.setBounds(new Rectangle(13, 478, 65, 25)); jdbTextField4.setBounds(new Rectangle(92, 477, 113, 31)); jdbTextField4.setDataSet(queryDataSet_Customer); jdbTextField4.setColumnName("C_HOME"); jLabel6.setBounds(new Rectangle(14, 526, 49, 25)); jLabel6.setAlignmentY((float) 10.0); jLabel6.setText(" 城市："); jdbTextField5.setColumnName("C_CITY"); jdbTextField5.setDataSet(queryDataSet_Customer); jdbTextField5.setBounds(new Rectangle(92, 523, 113, 31)); jLabel7.setAlignmentY((float) 10.0); jLabel7.setText("省份 ："); jLabel7.setBounds(new Rectangle(19, 578, 49, 25)); jdbTextField6.setBounds(new Rectangle(92, 575, 173, 31)); jdbTextField6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { // jdbTextField6_actionPerformed(e); } }); jdbTextField6.setDataSet(queryDataSet_Customer); jdbTextField6.setColumnName("C_PROVIENCE"); jLabel8.setBounds(new Rectangle(15, 630, 65, 25)); jLabel8.setAlignmentY((float) 10.0); jLabel8.setText("郵政編碼："); jdbTextField7.setColumnName("C_ZIP"); jdbTextField7.setDataSet(queryDataSet_Customer); jdbTextField7.setBounds(new Rectangle(92, 623, 120, 31)); jLabel9.setText("國 家："); jLabel9.setBounds(new Rectangle(244, 291, 87, 25)); jdbTextField8.setBounds(new Rectangle(310, 289, 95, 31)); jdbTextField8.setDataSet(queryDataSet_Customer); jdbTextField8.setColumnName("C_NATION"); jLabel10.setToolTipText(""); jLabel10.setText("家庭電話："); jLabel10.setBounds(new Rectangle(232, 339, 87, 25)); jLabel11.setBounds(new Rectangle(235, 389, 87, 25)); jLabel11.setText("公司電話："); jLabel12.setBounds(new Rectangle(233, 432, 87, 25)); jLabel12.setText("呼機號碼："); jLabel13.setBounds(new Rectangle(234, 481, 80, 25)); jLabel13.setText("手機號碼："); jLabel14.setBounds(new Rectangle(466, 288, 87, 25)); jLabel14.setText("個人詳細資料："); jdbTextField9.setColumnName("C_HTEL"); jdbTextField9.setDataSet(queryDataSet_Customer); jdbTextField9.setBounds(new Rectangle(311, 339, 95, 31)); jdbTextField10.setColumnName("C_CTEL"); jdbTextField10.setDataSet(queryDataSet_Customer); jdbTextField10.setBounds(new Rectangle(310, 384, 95, 31)); jdbTextField11.setColumnName("C_CALL"); jdbTextField11.setDataSet(queryDataSet_Customer); jdbTextField11.setBounds(new Rectangle(310, 428, 95, 31)); jdbTextField12.setColumnName("C_MOBILE"); jdbTextField12.setDataSet(queryDataSet_Customer); jdbTextField12.setBounds(new Rectangle(310, 477, 95, 31)); jdbTextField13.setColumnName("C_NATION"); jdbTextField13.setDataSet(queryDataSet_Customer); jdbTextField13.setBounds(new Rectangle(461, 319, 384, 366)); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { jButton2_actionPerformed(e); } }); jButton2.setText("退 出"); jButton2.setBounds(new Rectangle(901, 432, 100, 29)); jLabel15.setText("備 注："); jLabel15.setBounds(new Rectangle(235, 525, 80, 25)); jdbTextField14.setBounds(new Rectangle(310, 520, 95, 31)); jdbTextField14.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(ActionEvent e) { // jdbTextField14_actionPerformed(e); } }); jdbTextField14.setDataSet(queryDataSet_Customer); jdbTextField14.setColumnName("C_BZ"); contentPane.add(jButton1, null); contentPane.add(jdbNavToolBar1, null); contentPane.add(tableScrollPane1, null); contentPane.add(jdbStatusLabel1, null); contentPane.add(jLabel1, null); contentPane.add(jLabel2, null); contentPane.add(jLabel9, null); contentPane.add(jLabel14, null); contentPane.add(jdbTextField13, null); contentPane.add(jdbTextField4, null); contentPane.add(jdbTextField1, null); contentPane.add(jdbTextField2, null); contentPane.add(jdbTextField3, null); contentPane.add(jdbTextField5, null); contentPane.add(jdbTextField6, null); contentPane.add(jdbTextField7, null); contentPane.add(jLabel3, null); contentPane.add(jLabel4, null); contentPane.add(jLabel5, null); contentPane.add(jLabel6, null); contentPane.add(jLabel7, null); contentPane.add(jLabel8, null); contentPane.add(jLabel13, null); contentPane.add(jLabel12, null); contentPane.add(jLabel11, null); contentPane.add(jLabel10, null); contentPane.add(jdbTextField9, null); contentPane.add(jdbTextField10, null); contentPane.add(jdbTextField12, null); contentPane.add(jdbTextField11, null); contentPane.add(jdbTextField8, null); contentPane.add(jdbNavField1, null); contentPane.add(jButton2, null); contentPane.add(jdbTextField14, null); contentPane.add(jLabel15, null); tableScrollPane1.getViewport().add(jdbTable1, null); } //Overridden so we can exit when window is closed protected void processWindowEvent(WindowEvent e) { super.processWindowEvent(e); if (e.getID() == WindowEvent.WINDOW_CLOSING) { System.exit(0); } } void jButton1_actionPerformed(ActionEvent e) {DB_Customer.saveChanges(queryDataSet_Customer); } void jButton2_actionPerformed(ActionEvent e) { System.exit(0); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -