package psa;import java.awt.*;import javax.swing.*;import com.borland.jbcl.layout.*;import com.borland.dbswing.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class NotePad_Dialog extends JDialog {  JPanel panel1 = new JPanel();  JPanel jPanel1 = new JPanel();  JLabel jLabel1 = new JLabel();  XYLayout xYLayout2 = new XYLayout();  JComboBox jComboBox1 = new JComboBox();  JLabel jLabel2 = new JLabel();  JTextField jTextField1 = new JTextField();  JButton jButton1 = new JButton();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JPanel jPanel2 = new JPanel();  JLabel jLabel3 = new JLabel();  XYLayout xYLayout3 = new XYLayout();  JdbTextField jdbTextField1 = new JdbTextField();  JdbTextField jdbTextField2 = new JdbTextField();  JLabel jLabel4 = new JLabel();  JdbTextField jdbTextField3 = new JdbTextField();  JLabel jLabel5 = new JLabel();  JLabel jLabel6 = new JLabel();  JScrollPane jScrollPane1 = new JScrollPane();  JdbTextArea jdbTextArea1 = new JdbTextArea();  JButton jButton2 = new JButton();  JButton jButton3 = new JButton();  JButton jButton4 = new JButton();  JButton jButton5 = new JButton();  Database database1 = new Database();  QueryDataSet queryDataSet1 = new QueryDataSet();  Column column1 = new Column();  Column column2 = new Column();  Column column3 = new Column();  Column column4 = new Column();  Column column5 = new Column();  GridBagLayout gridBagLayout1 = new GridBagLayout();  public NotePad_Dialog(Frame frame, String title, boolean modal) {    super(frame, title, modal);    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  public NotePad_Dialog() {    this(null, "", false);  }  private void jbInit() throws Exception {    panel1.setLayout(gridBagLayout1);    jPanel1.setBorder(BorderFactory.createEtchedBorder());    jPanel1.setLayout(xYLayout2);    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel1.setText("查詢條件：");    jLabel2.setText("查詢內容：");    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));    jTextField1.setText("");    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton1.setText("查詢");    jButton1.addActionListener(new NotePad_Dialog_jButton1_actionAdapter(this));    jPanel2.setBorder(BorderFactory.createEtchedBorder());    jPanel2.setLayout(xYLayout3);    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel3.setText("日期：");    jLabel4.setText("類別：");    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField1.setText("");    jdbTextField1.setColumnName("date");    jdbTextField1.setDataSet(queryDataSet1);    jdbTextField2.setText("");    jdbTextField2.setColumnName("sort");    jdbTextField2.setDataSet(queryDataSet1);    jLabel5.setText("標題：");    jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField3.setText("");    jdbTextField3.setColumnName("caption");    jdbTextField3.setDataSet(queryDataSet1);    jLabel6.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel6.setText("內容：");    jButton2.setText("新增");    jButton2.addActionListener(new NotePad_Dialog_jButton2_actionAdapter(this));    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton3.setText("保存");    jButton3.addActionListener(new NotePad_Dialog_jButton3_actionAdapter(this));    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton4.setText("刪除");    jButton4.addActionListener(new NotePad_Dialog_jButton4_actionAdapter(this));    jButton4.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton5.setText("退出");    jButton5.addActionListener(new NotePad_Dialog_jButton5_actionAdapter(this));    jButton5.setFont(new java.awt.Font("DialogInput", 0, 12));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:psa", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from notepad;", null, true, Load.ALL));    column1.setCaption("編號");    column1.setColumnName("ID");    column1.setDataType(com.borland.dx.dataset.Variant.INT);    column1.setRowId(true);    column1.setTableName("notepad");    column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column1.setServerColumnName("ID");    column1.setSqlType(4);    column2.setCaption("日期");    column2.setColumnName("date");    column2.setDataType(com.borland.dx.dataset.Variant.STRING);    column2.setPrecision(20);    column2.setTableName("notepad");    column2.setServerColumnName("date");    column2.setSqlType(12);    column3.setCaption("類型");    column3.setColumnName("sort");    column3.setDataType(com.borland.dx.dataset.Variant.STRING);    column3.setPrecision(20);    column3.setTableName("notepad");    column3.setServerColumnName("sort");    column3.setSqlType(12);    column4.setCaption("標題");    column4.setColumnName("caption");    column4.setDataType(com.borland.dx.dataset.Variant.STRING);    column4.setPrecision(30);    column4.setTableName("notepad");    column4.setServerColumnName("caption");    column4.setSqlType(12);    column5.setCaption("內容");    column5.setColumnName("comments");    column5.setDataType(com.borland.dx.dataset.Variant.STRING);    column5.setSearchable(false);    column5.setTableName("notepad");    column5.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column5.setServerColumnName("comments");    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5});    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);    jdbTable1.setDataSet(queryDataSet1);    jdbTable1.setEditable(false);    jdbTextArea1.setColumnName("comments");    jdbTextArea1.setDataSet(queryDataSet1);    this.setResizable(false);    this.setTitle("日常記事");    getContentPane().add(panel1);    panel1.add(jPanel1,  new GridBagConstraints(0, 0, 5, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(10, 9, 0, 14), 19, 21));    jPanel1.add(jLabel1,   new XYConstraints(13, 26, -1, -1));    jPanel1.add(jComboBox1,      new XYConstraints(81, 24, 129, -1));    jPanel1.add(jButton1,       new XYConstraints(489, 19, 84, -1));    jPanel1.add(jTextField1,   new XYConstraints(302, 24, 162, -1));    jPanel1.add(jLabel2, new XYConstraints(229, 27, -1, -1));    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 1, 2, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(13, 9, 0, 0), -234, -118));    panel1.add(jPanel2,  new GridBagConstraints(2, 1, 3, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(12, 8, 0, 14), 9, 9));    jPanel2.add(jLabel3, new XYConstraints(14, 18, -1, -1));    jPanel2.add(jdbTextField1, new XYConstraints(58, 15, 93, -1));    jPanel2.add(jLabel4,  new XYConstraints(168, 17, -1, -1));    jPanel2.add(jdbTextField2,  new XYConstraints(212, 14, 123, -1));    jPanel2.add(jLabel5,  new XYConstraints(14, 53, -1, -1));    jPanel2.add(jdbTextField3,  new XYConstraints(58, 50, 278, -1));    jPanel2.add(jLabel6,   new XYConstraints(15, 90, -1, -1));    jPanel2.add(jScrollPane1,    new XYConstraints(15, 113, 326, 178));    panel1.add(jButton2,  new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(24, 72, 21, 0), 26, 0));    panel1.add(jButton5,  new GridBagConstraints(4, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(26, 49, 21, 69), 26, 0));    panel1.add(jButton4,  new GridBagConstraints(3, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(26, 44, 21, 0), 26, 0));    panel1.add(jButton3,  new GridBagConstraints(1, 2, 2, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(25, 49, 21, 0), 26, 0));    jScrollPane1.getViewport().add(jdbTextArea1, null);    tableScrollPane1.getViewport().add(jdbTable1, null);    jComboBox1.addItem("按類別查詢");    jComboBox1.addItem("按標題查詢");    jComboBox1.setSelectedIndex(-1);  }  void jButton1_actionPerformed(ActionEvent e) {    if(jComboBox1.getSelectedIndex()<0){      JOptionPane.showMessageDialog(this,"請選擇查詢條件");      return;    }    if(jTextField1.getText().length()==0){      JOptionPane.showMessageDialog(this,"請輸入查詢內容");      return;    }    String condition = "caption";    if(jComboBox1.getSelectedIndex()==0)      condition="sort";    if(queryDataSet1.isOpen()) queryDataSet1.close();    String sql = "select * from notepad where "+condition+" = \'"        + jTextField1.getText() + "\'";    try{      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(         database1,sql, null, true,Load.ALL));      queryDataSet1.open();    }catch(Exception ex){      JOptionPane.showMessageDialog(this,ex.toString());    }  }  void jButton2_actionPerformed(ActionEvent e) {    queryDataSet1.insertRow(false);  }  void jButton3_actionPerformed(ActionEvent e) {    try{       queryDataSet1.post();       queryDataSet1.saveChanges();       queryDataSet1.refresh();     }catch(Exception ex){       queryDataSet1.refresh();       JOptionPane.showMessageDialog(this,"注冊失敗！","提示",JOptionPane.ERROR_MESSAGE);     }  }  void jButton4_actionPerformed(ActionEvent e) {    try{      queryDataSet1.deleteRow();      queryDataSet1.post();      queryDataSet1.saveChanges();      queryDataSet1.refresh();    }catch(Exception ex){      queryDataSet1.refresh();      JOptionPane.showMessageDialog(this,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);    }  }  void jButton5_actionPerformed(ActionEvent e) {    this.dispose();  }}class NotePad_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {  NotePad_Dialog adaptee;  NotePad_Dialog_jButton1_actionAdapter(NotePad_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class NotePad_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {  NotePad_Dialog adaptee;  NotePad_Dialog_jButton2_actionAdapter(NotePad_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class NotePad_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {  NotePad_Dialog adaptee;  NotePad_Dialog_jButton3_actionAdapter(NotePad_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}class NotePad_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {  NotePad_Dialog adaptee;  NotePad_Dialog_jButton4_actionAdapter(NotePad_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton4_actionPerformed(e);  }}class NotePad_Dialog_jButton5_actionAdapter implements java.awt.event.ActionListener {  NotePad_Dialog adaptee;  NotePad_Dialog_jButton5_actionAdapter(NotePad_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton5_actionPerformed(e);  }}