query_allduzhe.java

图书管理系统

/*
 * Query_AllDuzhe.java
 *
 * Created on 2008年1月2日, 下午8:11
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import java.awt.BorderLayout;
import java.io.IOException;
import javax.swing.*;
import java.sql.*;
import java.util.*;

/**
 *
 * @author Wangyiming
 */
public class Query_AllDuzhe extends JDialog{
    
    /** Creates a new instance of Query_AllDuzhe */
    public Query_AllDuzhe(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 {
//            Connection con=DriverManager.getConnection("jdbc:odbc:XSBOOK");
            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 XS");
            ArrayList<String> libCard=new ArrayList<String>();
            ArrayList<String> name=new ArrayList<String>();
            ArrayList<String> major=new ArrayList<String>();
            ArrayList<String> gender=new ArrayList<String>();
            ArrayList<String> birth=new ArrayList<String>();
            ArrayList<String> borrowNum=new ArrayList<String>();
            while(rs.next())
            {
                String lc=new String(rs.getString("libCard"));
                String na=new String(rs.getString("name"));
                String ma=new String(rs.getString("major"));
                String sex=new String(rs.getString("gender"));
                String bi=new String(rs.getString("birth"));
                String bn=new String(String.format("%d",rs.getInt("borrowNum")));
                libCard.add(lc);
                name.add(na);
                major.add(ma);
                gender.add(sex);
                birth.add(bi);
                borrowNum.add(bn);
            }
            int n=name.size();
            String[][] xsData=new String[n][6];
            for(int i=0;i<n;i++)
            {
                xsData[i][0]=new String(libCard.get(i));
                xsData[i][1]=new String(name.get(i));
                xsData[i][2]=new String(major.get(i));
                xsData[i][3]=new String(gender.get(i));
                xsData[i][4]=new String(birth.get(i).substring(0,10));
                xsData[i][5]=new String(borrowNum.get(i));
            }
            String[] title={"借书证号","姓名","专业","性别","出生日期","借书数"};
            JTable xsInfo=new JTable(xsData,title);
            JScrollPane jsp=new JScrollPane(xsInfo);
            this.add(jsp,BorderLayout.CENTER);
        }catch (Exception ex) {
            JOptionPane.showConfirmDialog(null,"找不到数据库驱动程序！","Warning",JOptionPane.CLOSED_OPTION,JOptionPane.WARNING_MESSAGE);
            flag=-1;
        }
    }
    public int getFlag()
    {
        return flag;
    }
    private int flag;
}