bookinglistquery.java

基于UML的书店采购管理系统设计主要是供书店管理员使用。系统提供了管理员登陆

/*
 * 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[]={"书籍号","书名","作者","价格","出版社","库存量"};
   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("添加进采购单",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="确定要添加进购物单吗？";
           int ok=JOptionPane.showConfirmDialog(this,m,"确认",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);
               }
           }
       }
   }       
}