query_alltushu.java

图书管理系统

import java.awt.BorderLayout;
import javax.swing.*;
import java.sql.*;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
import java.util.ArrayList;

/**
 *
 * @author Administrator
 */
public class Query_AllTushu extends JDialog {
    public Query_AllTushu(JFrame owner) {
        super(owner,"显示所有图书信息",true);
        this.Update_Con();
        this.setResizable(false);
        this.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
        this.setTitle("显示所有图书信息");
    }
    private void Update_Con()
    {
        flag=0;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbc.Driver");
        } catch (ClassNotFoundException ex) {}
        try{
            String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=sources\\data.mdb;pwd=shujuyuan";
            Connection con=DriverManager.getConnection(url);
            Statement st=con.createStatement();
            ResultSet rs=st.executeQuery("select * from book");
            ArrayList<String> isbn=new ArrayList<String>();
            ArrayList<String> name=new ArrayList<String>();
            ArrayList<String> author=new ArrayList<String>();
            ArrayList<String> publish=new ArrayList<String>();
            ArrayList<String> fuben=new ArrayList<String>();
            ArrayList<String> kucun=new ArrayList<String>();
            while(rs.next()){
                String is=new String(rs.getString("ISBN"));
                String na=new String(rs.getString("name"));
                String au=new String(rs.getString("author"));
                String pub=new String(rs.getString("publish"));
                String fu=new String(rs.getString("fubenNum"));
                String ku=new String(rs.getString("kucunNum"));
                isbn.add(is);
                name.add(na);
                author.add(au);
                publish.add(pub);
                fuben.add(fu);
                kucun.add(ku);
            }
            int n=isbn.size();
            String tsData[][]=new String[n][6];
            for(int i=0;i<n;i++)
            {
                tsData[i][0]=new String(isbn.get(i));
                tsData[i][1]=new String(name.get(i));
                tsData[i][2]=new String(author.get(i));
                tsData[i][3]=new String(publish.get(i));
                tsData[i][4]=new String(fuben.get(i));
                tsData[i][5]=new String(kucun.get(i));
            }
            String[] title={"ISBN","书名","作者","出版社","副本量","库存量"};
            JTable tsInfo=new JTable(tsData,title);
            JScrollPane jsp=new JScrollPane(tsInfo);
            this.add(jsp,BorderLayout.CENTER);
        } catch(Exception ex){
            
        }
    }
    public int getFlag()
    {
        return flag;
    }
    private int flag;
}