package studentmanage;import java.awt.*;import javax.swing.*;import java.sql.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class ScoreDialog extends JDialog {  Connection con=null;  Statement stmt=null;  ResultSet rs=null;  int  courseid=0;  int semesterid=0;  String course="";  String semester="";  JPanel panel1 = new JPanel();  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JLabel jLabel4 = new JLabel();  JComboBox jComboBox1 = new JComboBox();  JTextField jTextField1 = new JTextField();  JComboBox jComboBox2 = new JComboBox();  JTextField jTextField2 = new JTextField();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();  public ScoreDialog(Frame frame, String title, boolean modal) {    super(frame, title, modal);    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  public ScoreDialog() {    this(null, "", false);  }  private void jbInit() throws Exception {    panel1.setLayout(null);    this.getContentPane().setLayout(null);    panel1.setBounds(new Rectangle(5, 2, 511, 300));    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setToolTipText("");    jLabel1.setText("課程號");    jLabel1.setBounds(new Rectangle(14, 136, 55, 20));    jLabel2.setBounds(new Rectangle(14, 71, 55, 20));    jLabel2.setText("學期號");    jLabel2.setToolTipText("");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel3.setToolTipText("");    jLabel3.setText("學期名稱");    jLabel3.setBounds(new Rectangle(218, 69, 81, 20));    jLabel4.setBounds(new Rectangle(218, 136, 81, 20));    jLabel4.setText("課程名稱");    jLabel4.setToolTipText("");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 16));    jComboBox1.setBounds(new Rectangle(84, 64, 122, 30));    jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));    jTextField1.setEditable(false);    jTextField1.setText("");    jTextField1.setBounds(new Rectangle(291, 65, 187, 30));    jComboBox2.setBounds(new Rectangle(84, 131, 122, 30));    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 16));    jTextField2.setBounds(new Rectangle(291, 131, 187, 30));    jTextField2.setText("");    jTextField2.setEditable(false);    jTextField2.setFont(new java.awt.Font("Dialog", 0, 16));    String sql1="select * from semester";    String sql2="select * from course";    DbConnect.loadClass();    con = DbConnect.makeConnect("127.0.0.1", "StudentScore", "sa", "");    stmt = DbConnect.makeStatement(con);    rs = DbConnect.makeResultSet(stmt, sql1);    try{      rs.next();      jComboBox1.addItem(String.valueOf(rs.getInt("semesterid")));     jTextField1.setText(rs.getString("semestername"));      while(rs.next()){        jComboBox1.addItem(String.valueOf(rs.getInt("semesterid")));      }      DbConnect.close(rs);      rs=DbConnect.makeResultSet(stmt, sql2);      rs.next();      jComboBox2.addItem(String.valueOf(rs.getInt("courseid")));      jTextField2.setText(rs.getString("coursename"));      while(rs.next()){        jComboBox2.addItem(String.valueOf(rs.getInt("courseid")));      }      DbConnect.close(rs);    }catch(SQLException e){      System.out.print("數據訪問出錯");    }    jComboBox1.addActionListener(new ScoreDialog_jComboBox1_actionAdapter(this));    jComboBox2.addActionListener(new ScoreDialog_jComboBox2_actionAdapter(this));    jButton1.setBounds(new Rectangle(125, 202, 85, 40));    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));    jButton1.setToolTipText("");    jButton1.setText("確定");    jButton2.setText("取消");    jButton2.setToolTipText("");    jButton2.setMargin(new Insets(2, 14, 2, 14));    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));    jButton2.setBounds(new Rectangle(285, 202, 85, 40));    panel1.add(jComboBox1, null);    panel1.add(jLabel3, null);    panel1.add(jTextField1, null);    panel1.add(jComboBox2, null);    panel1.add(jLabel4, null);    panel1.add(jTextField2, null);    panel1.add(jLabel2, null);    panel1.add(jLabel1, null);    panel1.add(jButton1, null);    panel1.add(jButton2, null);    this.getContentPane().add(panel1, null);  }  void jComboBox1_actionPerformed(ActionEvent e) {    int num=Integer.parseInt(jComboBox1.getSelectedItem().toString());    String sql="select * from semester where semesterid="+num;    rs = DbConnect.makeResultSet(stmt, sql);    try{      rs.next();      jTextField1.setText(rs.getString("semestername"));    }catch(SQLException e1){      e1.printStackTrace();      System.out.print("數據訪問出錯");    }    DbConnect.close(rs);  }  void jComboBox2_actionPerformed(ActionEvent e) {    int num=Integer.parseInt(jComboBox2.getSelectedItem().toString());    String sql="select * from course where courseid="+num;    rs = DbConnect.makeResultSet(stmt, sql);    try{      rs.next();      jTextField2.setText(rs.getString("coursename"));    }catch(SQLException e1){      e1.printStackTrace();      System.out.print("數據訪問出錯");    }    DbConnect.close(rs);  }}class ScoreDialog_jComboBox1_actionAdapter implements java.awt.event.ActionListener {  ScoreDialog adaptee;  ScoreDialog_jComboBox1_actionAdapter(ScoreDialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jComboBox1_actionPerformed(e);  }}class ScoreDialog_jComboBox2_actionAdapter implements java.awt.event.ActionListener {  ScoreDialog adaptee;  ScoreDialog_jComboBox2_actionAdapter(ScoreDialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jComboBox2_actionPerformed(e);  }}