printbooking.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 PrintBooking extends JPanel implements ActionListener
{
       Object a[][];
       Object name[]={"书籍号","书名","作者","价格","出版社","库存量"};
       JTable table;
       JButton print;
       String bookid,bookname,bookauthor,bookpress;
       int bookprice,booknum;
       private int i=0;
       public PrintBooking()
       {
           a=new Object[50][6];
           table=new JTable(a,name);
           print=new JButton("打印采购单",new ImageIcon("D:/book_booking/image/2.jpg"));
           print.addActionListener(this);
           
           JPanel pCenter=new JPanel();
           pCenter.add(new JScrollPane(table));
           add(pCenter,BorderLayout.CENTER);

           JPanel pSouth=new JPanel();
           pSouth.add(print);
           add(pSouth,BorderLayout.SOUTH);
           validate();
       }
       public void actionPerformed(ActionEvent e)
      {
           
           if(e.getSource()==print)
           {
//               table.clearSelection();
               try
               {
                   SqlBean sqlBean1=new SqlBean();
                   String sqlStr="select * from bookingList";
                   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("needCount");
                          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);
              }
         }
      }
}