borrowinfolist.java~16~

Java信息系统设计与开发实例（第二版）随书源代码.

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);
  }
  Vector tempvector =new Vector(1,1);
  void jButtonSearch_mouseClicked(MouseEvent e) {
 tempvector.clear();
          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);
  }
}