package untitled2;import javax.swing.*;import java.awt.*;import java.awt.event.*;import com.borland.jbcl.layout.*;import java.awt.event.*;import com.borland.jbcl.layout.*;import java.sql.*;import java.sql.Statement;import java.sql.SQLException;import java.sql.Statement;import java.sql.Connection;import java.sql.ResultSet;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import javax.swing.border.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2006</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class buMenChaKan extends JFrame {  XYLayout xYLayout1 = new XYLayout();  JTextField jTextField1 = new JTextField();  JLabel jLabel1 = new JLabel();  JButton jButton1 = new JButton();  JButton jButton3 = new JButton();  Statement stmt=null;  Connection con=null;  JTextField jTextField3 = new JTextField();  JTextField jTextField4 = new JTextField();  JTextField jTextField5 = new JTextField();  JTextField jTextField6 = new JTextField();  JTextField jTextField7 = new JTextField();  JLabel jLabel3 = new JLabel();  JLabel jLabel4 = new JLabel();  JLabel jLabel5 = new JLabel();  JLabel jLabel6 = new JLabel();  JLabel jLabel7 = new JLabel();  Database database1 = new Database();  QueryDataSet queryDataSet1 = new QueryDataSet();  JButton jButton2 = new JButton();  JComboBox jComboBox1 = new JComboBox();  JPanel jPanel1 = new JPanel();  Border border1;  TitledBorder titledBorder1;  JLabel jLabel2 = new JLabel();  public buMenChaKan() {    try {      jbInit();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    border1 = BorderFactory.createBevelBorder(BevelBorder.RAISED,Color.white,Color.white,new Color(103, 101, 98),new Color(148, 145, 140));    titledBorder1 = new TitledBorder(new EtchedBorder(EtchedBorder.RAISED,Color.white,SystemColor.desktop),"查詢條件");    this.getContentPane().setBackground(SystemColor.text);    this.setDefaultCloseOperation(HIDE_ON_CLOSE);     this.setSize(new Dimension(800, 580));                  this.setEnabled(true);    this.setFont(new java.awt.Font("楷體_GB2312", 0, 12));    this.setLocale(java.util.Locale.getDefault());    this.setTitle("歡迎您進入部門查看界面");    this.getContentPane().setLayout(xYLayout1);    jLabel1.setFont(new java.awt.Font("幼圓", 0, 13));    jLabel1.setText("查詢條件");    jLabel1.setBounds(new Rectangle(65, 59, 75, 19));    jTextField1.setText("");    jTextField1.setBounds(new Rectangle(382, 57, 153, 22));    jTextField1.addActionListener(new buMenChaKan_jTextField1_actionAdapter(this));    jButton1.setBounds(new Rectangle(608, 56, 61, 29));    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));    jButton1.setSize(new Dimension(73, 25));    jButton1.setText("查詢");    jButton1.addActionListener(new buMenChaKan_jButton1_actionAdapter(this));    jButton3.setEnabled(true);    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));    jButton3.setText("退出 ");    jButton3.addActionListener(newbuMenChaKan_jButton3_actionAdapter(this));    jTextField6.setText("");    jTextField4.setText("");    jTextField7.setText("");    jTextField5.setText("");    jTextField3.setText("");    jTextField3.addActionListener(new buMenChaKan_jTextField3_actionAdapter(this));    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));    jLabel3.setHorizontalAlignment(SwingConstants.CENTER);    jLabel3.setText("部門編號");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));    jLabel4.setHorizontalAlignment(SwingConstants.CENTER);    jLabel4.setText("部門名稱");    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));    jLabel5.setHorizontalAlignment(SwingConstants.CENTER);    jLabel5.setText("部門組長");    jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));    jLabel6.setText("部門電話");    jLabel7.setFont(new java.awt.Font("Dialog", 0, 13));    jLabel7.setText("部門辦公室");    xYLayout1.setWidth(800);    xYLayout1.setHeight(580);    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:Digital_campus", "dbw", "123456", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    database1.setDatabaseName("");    queryDataSet1.setTableName("department");    queryDataSet1.setStoreName("");    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT  * FROM department ", null, true, Load.ALL));    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));    jButton2.setText("清空");    jButton2.addActionListener(new buMenChaKan_jButton2_actionAdapter(this));    jComboBox1.addActionListener(new buMenChaKan_jComboBox1_actionAdapter(this));    jPanel1.setBackground(SystemColor.text);    jPanel1.setName("");    jPanel1.setBorder(titledBorder1);    jPanel1.setLayout(null);    jComboBox1.setBounds(new Rectangle(194, 59, 123, 22));    jLabel2.setIcon(new ImageIcon(new java.net.URL("file:///D:/UI6.0/untitled2/pictrue/1234.jpg")));    jLabel2.setText("jLabel2");    jPanel1.add(jComboBox1, null);    jPanel1.add(jLabel1, null);    jPanel1.add(jTextField1, null);    jPanel1.add(jButton1, null);    this.getContentPane().add(jLabel2,         new XYConstraints(418, 313, 378, 241));    this.getContentPane().add(jLabel3, new XYConstraints(89, 197, 71, 23));    this.getContentPane().add(jTextField3, new XYConstraints(218, 199, 115, -1));    this.getContentPane().add(jLabel6, new XYConstraints(403, 200, 67, 23));    this.getContentPane().add(jTextField6,  new XYConstraints(504, 198, 115, -1));    this.getContentPane().add(jButton2, new XYConstraints(684, 193, 65, 28));    this.getContentPane().add(jTextField7,  new XYConstraints(509, 274, 115, -1));    this.getContentPane().add(jButton3, new XYConstraints(684, 269, -1, -1));    this.getContentPane().add(jTextField5,  new XYConstraints(221, 362, 115, -1));    this.getContentPane().add(jTextField4,  new XYConstraints(217, 280, 115, -1));    this.getContentPane().add(jLabel7, new XYConstraints(399, 274, 100, 23));    this.getContentPane().add(jLabel4, new XYConstraints(94, 280, 64, 23));    this.getContentPane().add(jLabel5, new XYConstraints(97, 358, 60, 23));    this.getContentPane().add(jPanel1,        new XYConstraints(28, 24, 752, 130));jComboBox1.addItem("部門編號");jComboBox1.addItem("部門名稱");  }  void jButton3_actionPerformed(ActionEvent e) {this.dispose();  }  void jButton1_actionPerformed(ActionEvent e) throws SQLException {     String sql1=new String();String sql2=new String();    sql1= "select * from department where department_id=? "; sql2= "select * from department where department_name=?";    Connection con = null;   try{     con =DBConnection.getConnection();     PreparedStatement ps;     String str=jComboBox1.getSelectedItem().toString();     if(str=="部門編號")    ps = con.prepareStatement(sql1);     else       ps = con.prepareStatement(sql2);      int n=Integer.parseInt(jTextField1.getText());     ps.setString(1, jTextField1.getText());     ResultSet rs = ps.executeQuery();     boolean more= rs.next();    if(!more)       JOptionPane.showMessageDialog(null, "該部門不存在！");else     while(more)       {         jTextField3.setText(String.valueOf(rs.getInt(1)));    jTextField4.setText(rs.getString(2).trim());      jTextField5.setText(rs.getString(3).trim());   jTextField6.setText(rs.getString(4).trim());     jTextField7.setText(rs.getString(5).trim());      JOptionPane.showMessageDialog(null, "查詢成功！");     more=rs.next();     jTextField3.setEditable(false);     jTextField3.setEditable(false);     jTextField4.setEditable(false);     jTextField5.setEditable(false);     jTextField6.setEditable(false);     jTextField7.setEditable(false);       }     DbUtil.close(rs);     DbUtil.close(ps);   }   catch(NumberFormatException ex)   {     JOptionPane.showMessageDialog(null, "輸入錯誤，請重新輸入！");   }   catch(Exception ex){     ex.printStackTrace();   }finally{     DbUtil.close(con);   }  }  void jTextField1_actionPerformed(ActionEvent e) {  }  void jTextField3_actionPerformed(ActionEvent e) {  }  void jButton2_actionPerformed(ActionEvent e) {    jTextField1.setEditable(true);    jTextField3.setEditable(true);     jTextField4.setEditable(true);     jTextField5.setEditable(true);     jTextField6.setEditable(true);     jTextField7.setEditable(true);    jTextField1.setText("");        jTextField3.setText("");       jTextField4.setText("");        jTextField5.setText("");        jTextField6.setText("");        jTextField7.setText("");  }  void jComboBox1_actionPerformed(ActionEvent e) {  }}class buMenChaKan_jButton3_actionAdapter implementsjava.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jButton3_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}class buMenChaKan_jButton1_actionAdapter implementsjava.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jButton1_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    try {      adaptee.jButton1_actionPerformed(e);    }    catch (SQLException ex) {    }  }}class buMenChaKan_jTextField1_actionAdapter implements java.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jTextField1_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jTextField1_actionPerformed(e);  }}class buMenChaKan_jTextField3_actionAdapter implements java.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jTextField3_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jTextField3_actionPerformed(e);  }}class buMenChaKan_jButton2_actionAdapter implements java.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jButton2_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class buMenChaKan_jComboBox1_actionAdapter implements java.awt.event.ActionListener {  buMenChaKan adaptee;  buMenChaKan_jComboBox1_actionAdapter(buMenChaKan adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jComboBox1_actionPerformed(e);  }}