package bookmanager;import javax.swing.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.sql.*;   //引入包java.sql.*;import javax.swing.table.*;//引入包sqljavax.swing.table.*;import java.util.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class borrowInfoList extends JFrame {  ResultSet rs;    //定義結果集  private DBManager db =new DBManager();//定義數據庫操作對象  XYLayout xYLayout1 = new XYLayout();  DefaultTableModel model =new DefaultTableModel();//定義DefaultTableModel模型  JTable jTableResult = new JTable(model);   //定義model型JTable  JLabel jLabel1 = new JLabel();  JTextField jTextFieldReader = new JTextField();  JLabel jLabel2 = new JLabel();  JButton jButtonSearch = new JButton();  JTextField jTextFieldBookName = new JTextField();  JScrollPane jScrollPane1 = new JScrollPane();  public borrowInfoList() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    borrowInfoList borrowInfoList = new borrowInfoList();  }  private void jbInit() throws Exception {    jTextFieldBookName.setText("");    jTextFieldBookName.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonSearch.setText("查詢");    jButtonSearch.addMouseListener(new borrowInfoList_jButtonSearch_mouseAdapter(this));    jButtonSearch.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("書名：");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jTextFieldReader.setText("");    jTextFieldReader.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("借閱者：");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(532);    xYLayout1.setHeight(461);    this.setSize(500,400);   // model中加入列名       model.addColumn("借閱者") ;       model.addColumn("書名") ;       model.addColumn("借閱日期") ;       model.addColumn("備注") ;    this.getContentPane().add(jTextFieldReader, new XYConstraints(121, 41, 100, -1));    this.getContentPane().add(jLabel1, new XYConstraints(40, 41, 78, 29));    this.getContentPane().add(jLabel2, new XYConstraints(225, 39, 51, 29));    this.getContentPane().add(jButtonSearch, new XYConstraints(425, 38, 87, -1));    this.getContentPane().add(jTextFieldBookName, new XYConstraints(277, 39, 122, 31));    this.getContentPane().add(jScrollPane1,     new XYConstraints(39, 114, 456, 238));    jScrollPane1.getViewport().add(jTableResult, null);  }  void jButtonSearch_mouseClicked(MouseEvent e) {   Vector tempvector =new Vector(1,1);   for (int n=model.getRowCount() -1; n>=0;n++)   {       model.removeRow(n);             }       tempvector.add("eewfe") ;       tempvector.add("ghgh") ;        tempvector.add("hgh") ;        tempvector.add("hgh") ;    for (int i =1;i<=6;i++)   {      model.addRow(tempvector);   }   //test    String sql; //定義變量，用來判斷是否是第一個查詢條件 boolean  isfirst =true; sql="select * from BookBorrow ";   //如果款型的查詢條件不為空 if (jTextFieldReader.getText().trim().length() ==0)    {}    else    {       sql=sql+"  where  studentname='"+jTextFieldReader.getText().trim()+"'";       isfirst=false;    }         //如果顏色的查詢條件不為空   if (jTextFieldBookName.getText().trim().length()==0)   {}   else   {    //如果是第一個查詢條件     if (isfirst)     sql=sql+" where bookname='"+jTextFieldBookName.getText().trim() +"'";       //如果是第二個查詢條件     else      sql=sql+" and bookname='"+jTextFieldBookName.getText().trim() +"'";   } //執行數據庫的查詢操作 rs =db.getResult(sql);  try {         //判斷返回的結果集是否為空，若不為空顯示每條記錄    if(! rs.equals(null) )    {  while(rs.next() )      {      }    // jTextstudentname.setText(rs.getString("studentname"));    // jTextbookname.setText(rs.getString("bookname"));    // jTextborrowdate.setText(rs.getString("borrowdate"));    // jTextcomment.setText(rs.getString("comment"));    }    else    {   JOptionPane.showMessageDialog(null,"無紀錄!");              }  }//若出現異常，彈出警告對話框  catch (SQLException ex) { JOptionPane.showMessageDialog(null,"發生錯誤!");  }  }}class borrowInfoList_jButtonSearch_mouseAdapter extends java.awt.event.MouseAdapter {  borrowInfoList adaptee;  borrowInfoList_jButtonSearch_mouseAdapter(borrowInfoList adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonSearch_mouseClicked(e);  }}