package stumng;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.util.*;public class gradeQuest extends JFrame {  DBConnManager dbconnmanager = new DBConnManager();  BorderLayout borderLayout1 = new BorderLayout();  JPanel jPanel1 = new JPanel();  JComboBox jComboBox1 = new JComboBox();  JTextField jTextField1 = new JTextField();  JButton jButton1 = new JButton();  JScrollPane jScrollPane1 = new JScrollPane();  JButton jButton2 = new JButton();  JTable jTable1 = new JTable();  public gradeQuest() {    try {      jbInit();      //設置frame的大小      this.setSize(600, 400);      //得到當前屏幕大小      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();      //得到frame的大小      Dimension frameSize = this.getSize();      if (frameSize.height > screenSize.height) {        frameSize.height = screenSize.height;      }      if (frameSize.width > screenSize.width) {        frameSize.width = screenSize.width;      }      this.setTitle("查詢學生成績");      //設置frame在屏幕上顯示的位置      this.setLocation( (screenSize.width - frameSize.width) / 2,                       (screenSize.height - frameSize.height) / 2);     //按學號查詢該學生的基本信息    jButton1.addActionListener(new ActionListener()   {     public void actionPerformed(ActionEvent e)     {       Vector result = new Vector();       Vector resultdate = new Vector();       Vector headline = new Vector();       int astu_id = 0 ;       String str = "";       String aclass = "";       headline.add("stu_id");       headline.add("name");       headline.add("chinese");       headline.add("math");       headline.add("english");       headline.add("composite");       headline.add("total");       headline.add("class");       str = (String)jComboBox1.getSelectedItem();       if( str.equals("班級學生成績查詢") ) aclass = str;       else astu_id = Integer.parseInt(str);       result = dbconnmanager.stuGradeQuery(astu_id, aclass);       if( result.size() == 0 ) JOptionPane.showMessageDialog(null, "無記錄");       else {         for(int i = 0; i < result.size() / 7; i++) {           Vector temp = new Vector();           for (int j = 0; j <= 6; j++) {             String str1 = (String) result.elementAt(j + i * 7);             temp.add(str1);           }           resultdate.add(temp);         }         jTable1 = new JTable(resultdate, headline);         jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //滾動條設置左右滾         jScrollPane1.getViewport().add(jTable1, null); //在滾動條中放入表       }     }   });     //退出frame     jButton2.addActionListener(new ActionListener()    {      public void actionPerformed(ActionEvent e)      {        jButton2_actionPerformed(e);      }    });    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    this.getContentPane().setLayout(borderLayout1);    jTextField1.setFont(new java.awt.Font("Dialog", 0, 13));    jTextField1.setText("jTextField1");    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));    jButton1.setText("提交");    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 13));    jComboBox1.addItem("班級學生成績查詢");    jComboBox1.addItem("學生個人成績查詢");    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 13));    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));    jButton2.setText("退出");    this.getContentPane().add(jPanel1, BorderLayout.NORTH);    jPanel1.add(jComboBox1, null);    jPanel1.add(jTextField1, null);    jPanel1.add(jButton1, null);    jPanel1.add(jButton2, null);    this.getContentPane().add(jScrollPane1, BorderLayout.CENTER);  }  void jButton2_actionPerformed(ActionEvent e)  {    this.dispose();  }}