/* * To change this template, choose Tools | Templates * and open the template in the editor. */package book_booking;import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.event.*;import java.util.*;import java.sql.*;/** * * @author Administrator */public class BookingListQuery extends JPanel implements ActionListener{   Object a[][];   Object name[]={"書籍號(hào)","書名","作者","價(jià)格","出版社","庫存量"};   JTable table;   JButton search,insert;   String bookid,bookname,bookauthor,bookpress;   int bookprice,booknum;   private int i=0;     // SqlBean sqlBean=new SqlBean();   public BookingListQuery()   {       a=new Object[50][6];       table=new JTable(a,name);       search=new JButton("查詢庫存少于20的圖書信息",new ImageIcon("D:/book_booking/image/74.jpg"));       insert=new JButton("添加進(jìn)采購單",new ImageIcon("D:/book_booking/image/52.jpg"));       search.addActionListener(this);       insert.addActionListener(this);              JPanel pCenter=new JPanel();       pCenter.add(new JScrollPane(table));       add(pCenter,BorderLayout.CENTER);              JPanel pSouth=new JPanel();       pSouth.add(search);pSouth.add(insert);       add(pSouth,BorderLayout.SOUTH);       validate();   }   public void actionPerformed(ActionEvent e)   {//       int i=0;       if(e.getSource()==search)       {           try             {               SqlBean sqlBean1=new SqlBean();               String sqlStr="select * from books where bookCount<20";               ResultSet result=sqlBean1.executeQuery(sqlStr);               while(result.next())                   {                      bookid=result.getString("bookID");                       bookname=result.getString("bookName");                      bookauthor=result.getString("author");                      bookprice=result.getInt("price");                      bookpress=result.getString("press");                      booknum=result.getInt("bookCount");                      a[i][0]=bookid;a[i][1]=bookname;a[i][2]=bookauthor;                      a[i][3]=String.valueOf(bookprice);a[i][4]=bookpress;a[i][5]=String.valueOf(booknum);                      i++;                      table.repaint();                   }               sqlBean1.CloseDataBase();             }           catch(SQLException ee)           {               System.err.println(ee);           }       }              if(e.getSource()==insert)       {           String m="確定要添加進(jìn)購物單嗎？";           int ok=JOptionPane.showConfirmDialog(this,m,"確認(rèn)",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);           if(ok==JOptionPane.YES_OPTION)           {               try                  {                      String sqlStr=new String();                      int result;                      SqlBean sqlBean2=new SqlBean();                      for(int j=0;j<i;j++)                      {                         sqlStr="insert into bookingList values"+"("+"'"+a[j][0]+"','"+a[j][1]+"','"+a[j][2]+"',"+a[j][3]+",'"+a[j][4]+"',"+a[j][5]+")";                          result=sqlBean2.executeInsert(sqlStr);//                          table.clearSelection();                      }                      sqlBean2.CloseDataBase();                  }               catch(Exception ee)               {                    System.err.println(ee);               }           }       }   }       }