stulist.java

来自「学生成绩管理系统,可以修改」· Java 代码 · 共 64 行

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class StuList extends JFrame
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	Container c;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	public StuList()
	{
		super("学生列表信息");
		c=getContentPane();
	    this.setBounds(431, 223, 303, 349);
		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(800,380));
		JScrollPane s=new JScrollPane(table);
		c.add(s);
		try
		{
		String strSql="select 学号,身份证号码,姓名,性别,所在院系,所在专业,年级,班级,族别,政治面貌,出生日期," +
				"家庭住址,联系电话,备注 from xs";
		rs=db.getResult(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.getString(4));
			insertRow.addElement(rs.getString(5));
			insertRow.addElement(rs.getString(6));
			insertRow.addElement(rs.getString(7));
			insertRow.addElement(rs.getString(8));
			insertRow.addElement(rs.getString(9));
			insertRow.addElement(rs.getString(10));
			insertRow.addElement(rs.getString(11));
			insertRow.addElement(rs.getString(12));
			insertRow.addElement(rs.getString(13));
			insertRow.addElement(rs.getString(14));
			defaultModel.addRow(insertRow);
		}
		table.revalidate();
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
	catch(Exception ex)
		 {
			System.out.println(ex.toString());
		}
}
}