query_alljieyue.java

图书管理系统

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

/**
 *
 * @author Administrator
 */
public class Query_AllJieyue extends JDialog{
    public Query_AllJieyue(JFrame owner){
        super(owner,"显示图书被借信息",true);
        this.Update_Con();
        this.setResizable(false);
        this.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
        this.setTitle("显示图书被借信息");
    }
    public 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 jy");
            ArrayList<String> libCard=new ArrayList<String>();
            ArrayList<String> ISBN=new ArrayList<String>();
            ArrayList<String> index=new ArrayList<String>();
            ArrayList<String> borrowTime=new ArrayList<String>();
            while(rs.next()){
                String ss=new String(rs.getString("suoshuNo"));
                String lc=new String(rs.getString("libCard"));
                String is=new String(rs.getString("ISBN"));
                String bt=new String(rs.getString("borrowTime"));
                libCard.add(lc);
                ISBN.add(is);
                index.add(ss);
                borrowTime.add(bt);
            }
            int n=libCard.size();
            String jyData[][]=new String[n][4];
            for(int i=0;i<n;i++){
                jyData[i][0]=new String(index.get(i));
                jyData[i][1]=new String(libCard.get(i));
                jyData[i][2]=new String(ISBN.get(i));
                jyData[i][3]=new String(borrowTime.get(i).substring(0,10));
            }
            String title[]={"索书号","借书证号","ISBN","借书时间"};
            JTable xsInfo=new JTable(jyData,title);
            JScrollPane jsp=new JScrollPane(xsInfo);
            this.add(jsp,BorderLayout.CENTER);
            
        }catch(Exception e){
            JOptionPane.showConfirmDialog(null,"找不到数据库驱动程序！","Warning",JOptionPane.CLOSED_OPTION,JOptionPane.WARNING_MESSAGE);
            flag=-1;
        }
    }
    public int getFlag()
    {
        return flag;
    }
    private int flag;
}