userlist.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class UserList extends JFrame
{
	Container c;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	Connection con;
    Statement sql;
    ResultSet rs;
	public UserList()
	{
		super("用户列表一览！");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		String[] name={"编号","姓名","类型","可借数量","已借数量"};
		String[][] data=new String[0][0];
		defaultModel=new DefaultTableModel(data,name);
		table=new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(400,80));
		JScrollPane s=new JScrollPane(table);
		c.add(s);
		setBounds(300,300,500,300);
		Dimension FrameSize=this.getPreferredSize();
		setVisible(true);
		try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
      catch(ClassNotFoundException f){}
		try
		{
			String strSql="select * from reader";
			con=DriverManager.getConnection("jdbc:odbc:tushuguan");
	        sql=con.createStatement();
	        rs=sql.executeQuery(strSql);
		while(rs.next())
		{
			Vector insertRow=new Vector();
			insertRow.addElement(rs.getString(1));
			insertRow.addElement(rs.getString(2));
			insertRow.addElement(rs.getString(3));
			insertRow.addElement(rs.getInt(4));
			insertRow.addElement(rs.getInt(5));
			defaultModel.addRow(insertRow);
		}
		table.revalidate();
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
}
public static void main(String args[]){
	new UserList();
}
}