showbook.java

用java实现图书资料管理系统 操作系统：Windows 数据库：Windows Access 数据库 开发平台：NetBeans 开发语言：Java 语言

/*
 * showbook.java
 *
 * Created on 2007年12月20日, 上午3:30
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.ButtonGroup;
import java.sql.*;
import java.util.*;
import java.util.Date;
/**
 *
 * @author Owner
 */
public class showbook extends JPanel implements ActionListener
{
    editbook editbook;
    Container container;
    Connection con;
    Statement sql;
    ResultSet rs;
    String s;
    Panel pcenter;
    CardLayout card;
    JButton button[],delbutton[];
    Box basebox,box[];
    String barcodein[];
    int number;
    String name[]={"图书标识","图书ISBN","图书名称","出版商","图书类型","作者","价格","内容简介","库存","修改图书","删除图书"};
    /** Creates a new instance of showbook */
    public showbook(Panel pcenter,CardLayout card,String s) {
        this.s=s;
        this.card=card;
        this.pcenter=pcenter;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(ClassNotFoundException e2){}
        try{
            con=DriverManager.getConnection("jdbc:odbc:sample","std","123");
            sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=sql.executeQuery(s);
            rs.last();
            number=rs.getRow();
            System.out.println(number);
            button=new JButton[number];
            delbutton=new JButton[number];
            box=new Box[number+1];
            barcodein=new String[number];
            for(int k=0;k<number;k++){
                button[k]=new JButton("修改");
                button[k].addActionListener(this);
                delbutton[k]=new JButton("删除");
                delbutton[k].addActionListener(this);
            }
            
            basebox=Box.createVerticalBox();
            for(int k=0;k<number+1;k++)
                box[k]=Box.createHorizontalBox();
            
            for(int k=0;k<11;k++)
            {
                box[0].add(new Label(name[k]));
                if(k!=9)
                    box[0].add(Box.createHorizontalStrut(8));
            }
            basebox.add(box[0]);
            basebox.add(Box.createVerticalStrut(10));
            
            int i=1;
            rs.beforeFirst();
            System.out.println(i);
            while(rs.next())
            {
                barcodein[i-1]=rs.getString("barcode"); 
                String isbn=null;
                for(int k=2;k<=9;k++){
                    if(k!=3)
                        box[i].add(new Label(rs.getString(k)));
                    if(k==3)
                    {
                        isbn=rs.getString(k);
                        box[i].add(new Label(isbn));
                    }
                    if(k!=9)
                        box[i].add(Box.createHorizontalStrut(8));                        
                }
                Statement stmt=con.createStatement();
                String str="select * from storage where isbn='"+isbn+"'";
                System.out.println(str);
                ResultSet tt=stmt.executeQuery(str);
                tt.next();
                String number=tt.getString("number");
                box[i].add(new Label(number));
                box[i].add(Box.createHorizontalStrut(8));
                box[i].add(button[i-1]);                  
                box[i].add(Box.createHorizontalStrut(8));
                box[i].add(delbutton[i-1]);
                basebox.add(box[i]);
                basebox.add(Box.createVerticalStrut(10));
                i=i+1;
                System.out.println(i);
            }
            add(basebox);
        }
        catch(SQLException e)
        {
            System.out.println("jffie"+e);
        }
    }
    
    public void actionPerformed(ActionEvent e)
    {
        for(int k=0;k<number;k++)
        {
            if(e.getSource()==button[k])
            {
                editbook=new editbook(barcodein[k]);
                pcenter.add("editbook",editbook);
                card.show(pcenter,"editbook");
            }
            else if(e.getSource()==delbutton[k])
            {                
                try
                {
                    String ss="select * from bookinfo where barcode='"+barcodein[k]+"'";
                    rs=sql.executeQuery(ss);
                    rs.next();
                    ss="update storage set [number]=[number]-1 where [isbn]='"+rs.getString("isbn")+"'";
                    sql.executeUpdate(ss);
                    
                    ss="delete from bookinfo where barcode='"+barcodein[k]+"'";
                    sql.executeUpdate(ss);
                    JOptionPane.showMessageDialog(this,"图书已删除");
                    showbook shownew=new showbook(pcenter,card,s);
                    pcenter.add("shownew",shownew);
                    card.show(pcenter,"shownew");
                }
                catch(SQLException ee)
                {
                    System.out.println(ee);
                }
            }
        }
    }
    
}