statisticianlist.java

学生成绩管理系统,可以修改

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class StatisticianList extends JFrame
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	Container c;
	JTable table=null;
	DefaultTableModel defaultModel=null;
public StatisticianList()
	{
		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(550,180));
		JScrollPane s=new JScrollPane(table);
		c.add(s);
		try
		{
		String strSql="select UserName,Power from Statistician"; //查询语句连接数据库
		rs=db.getResult(strSql); 
		while(rs.next())
		{
			Vector insertRow=new Vector();  //循环读取数据到数组
			insertRow.addElement(rs.getString(1));
			insertRow.addElement(rs.getString(2));
			defaultModel.addRow(insertRow);
		}
		table.revalidate();
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
	catch(Exception ex)
		 {
			System.out.println(ex.toString());
		}
}
}