anewcourselist.java

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class AnewCourseList extends JFrame
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	Container c;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	public AnewCourseList()
	{
		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 学号,课程编号,学期名称, 任课教师,科目名称 from AnewCourse";
		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));
			defaultModel.addRow(insertRow);
		}
		table.revalidate();
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
	catch(Exception ex)
		 {
			System.out.println(ex.toString());
		}
   }
}