viewallcourse.java

一个用Java写的简单学生成绩管理系统

import javax.swing.*;
import java.awt.*;
import java.sql.*;
import javax.swing.table.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ViewAllCourse extends JFrame
{
  private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
  private String source = "Jdbc:Odbc:srs";
  private JTable table;
  //public int N = 30; // 最大课程数
  public ViewAllCourse()
  {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

  }

  private void jbInit() throws Exception
  {
    this.setTitle("查看所有课程");
    this.setSize(450,250);
    this.setResizable(false);
    String[] columnNames = {"课程名","学分","授课老师","上课地点","上课时间"};
    Object[][] rowData =new Object[20][5];
    try
    {
      Class.forName(driver);
      Connection con = DriverManager.getConnection(source);
      String sql = "select * from course";
      PreparedStatement ptm = con.prepareStatement(sql);
      //Statement stm = con.createStatement();
      ResultSet rs = ptm.executeQuery();
      //String coursename,professor,address,time;
      //double xuefen;
      int count = 0;
      while (rs.next())
      {
        rowData[count][0] = rs.getString("coursename");
        rowData[count][1] = Integer.toString(rs.getInt("xuefen"));
        rowData[count][2] = rs.getString("professor");
        rowData[count][3] = rs.getString("address");
        rowData[count][4] = rs.getString("ctime");
        count++;
      }
      ptm.close();
    }
    catch(Exception ex)
    {
      JOptionPane.showConfirmDialog(null,"出现错误!","ERROR",JOptionPane.YES_OPTION);
      ex.printStackTrace();
      System.exit(1);
    }
    Container container = getContentPane();
    table = new JTable(rowData,columnNames);
    table.getColumn("学分").setMaxWidth(40);
    table.getColumn("上课地点").setMaxWidth(80);
    table.getColumn("授课老师").setMaxWidth(60);
    container.add(new JScrollPane(table),BorderLayout.CENTER);
    this.setVisible(false);
    //this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  }
}