selected.java

使用java编写的一个学生选课系统

package Srs;

import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JCheckBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import java.sql.*;
import javax.swing.JButton;

public class Selected extends JFrame implements ActionListener{

	private JTable table;
	private String Id_0;
	private JButton button;
	/**
	 * Launch the application
	 * @param args
	 */

	/**
	 * Create the frame
	 */
	public Selected(String Id) {
		super();
		Id_0 = Id;
		getContentPane().setLayout(null);
		setBounds(100, 100, 500, 375);
		this.setLocationRelativeTo(null);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(65, 96, 376, 193);
		getContentPane().add(scrollPane);
		
		String[] col = {"课程编号", "课程名称", "课程说明" ,"授课教师","教师信息","上课时间",
        		"上课地点"};
        DefaultTableModel model = new DefaultTableModel(col,0);
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载access数据库驱动
           } catch (ClassNotFoundException e1) {
        	System.out.println("加载驱动不成功");
            e1.printStackTrace();
           }
           try{

        	   Connection conn = DriverManager.getConnection(
        		"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=mydb.mdb");
               Statement stmt = conn.createStatement();
               ResultSet rs=stmt.executeQuery("select * from RequiredCourse");
           
              while(rs.next()){
              
              String id = rs.getString("课程编号");
              String name = rs.getString("课程名称");
              String tel = rs.getString("课程说明");
              String teacher = rs.getString("授课教师");
              String teachernews = rs.getString("教师信息");
              String time = rs.getString("上课时间");
              String place = rs.getString("上课地点");
              Object[] rowData={id,name,tel,teacher,teachernews,time,place};
              model.addRow(rowData);//添加在表模板中
           }
           }catch(SQLException e1){
        	   System.out.println("连接数据库未成功");
           e1.getStackTrace();
           }
           try{

        	   Connection conn = DriverManager.getConnection(
        		"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=mydb.mdb");
               Statement stmt = conn.createStatement();
               ResultSet rs=stmt.executeQuery("select * from "+Id_0);
           
              while(rs.next()){
              
              String id = rs.getString("课程编号");
              String name = rs.getString("课程名称");
              String tel = rs.getString("课程说明");
              String teacher = rs.getString("授课教师");
              String teachernews = rs.getString("教师信息");
              String time = rs.getString("上课时间");
              String place = rs.getString("上课地点");
              Object[] rowData={id,name,tel,teacher,teachernews,time,place};
              model.addRow(rowData);//添加在表模板中
           }
           }catch(SQLException e1){
        	   System.out.println("连接数据库未成功");
           e1.getStackTrace();
           }
        table = new JTable(model);
        table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); 
		scrollPane.setViewportView(table);

		final JLabel label = new JLabel();
		label.setFont(new Font("幼圆", Font.BOLD, 18));
		label.setText("已选课程信息");
		label.setBounds(189, 27, 120, 42);
		getContentPane().add(label);

		button = new JButton();
	    button.setFont(new Font("@宋体", Font.BOLD, 15));
		button.setText("返   回");
		button.addActionListener(this);
		button.setBounds(189, 295, 106, 28);
		getContentPane().add(button);
		//
	}
	public void actionPerformed(ActionEvent e){
		if(e.getSource() == button){
			AfterLoad after = new AfterLoad("360601");
		    after.setVisible(true);
		    this.setVisible(false);
		}
		
	}

}