query_historyjieyue.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_HistoryJieyue extends JDialog {
    public Query_HistoryJieyue(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 jyls");
            ArrayList<String> libCard=new ArrayList<String>();
            ArrayList<String> ISBN=new ArrayList<String>();
            ArrayList<String> index=new ArrayList<String>();
            ArrayList<String> borrowTime=new ArrayList<String>();
            ArrayList<String> returnTime=new ArrayList<String>();
            while(rs.next()){
                String lc=new String(rs.getString("libCard"));
                String is=new String(rs.getString("ISBN"));
                String ss=new String(rs.getString("suoshuNo"));
                String bt=new String(rs.getString("borrowTime"));
                String rt=new String(rs.getString("returnTime"));
                libCard.add(lc);
                ISBN.add(is);
                index.add(ss);
                borrowTime.add(bt);
                returnTime.add(rt);
            }
            int n=libCard.size();
            String jylsData[][]=new String[n][5];
            for(int i=0;i<n;i++){
                jylsData[i][0]=new String(libCard.get(i));
                jylsData[i][1]=new String(ISBN.get(i));
                jylsData[i][2]=new String(index.get(i));
                jylsData[i][3]=new String(borrowTime.get(i).substring(0,10));
                jylsData[i][4]=new String(returnTime.get(i).substring(0,10));
            }
            String title[]={"借书证号","ISBN","索书号","借书时间","还书时间"};
            JTable xsInfo=new JTable(jylsData,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;
}