package student;import javax.swing.*;import java.awt.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;import java.awt.event.*;import javax.swing.border.*;import com.borland.dbswing.*;public class studentFrame extends JFrame {  JTabbedPane jTabbedPane1 = new JTabbedPane();  JPanel jPanel1 = new JPanel();  JPanel jPanel2 = new JPanel();  JPanel jPanel3 = new JPanel();  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JComboBox jComboBox1 = new JComboBox();  JLabel jLabel3 = new JLabel();  JTextField jTextField2 = new JTextField();  JLabel jLabel4 = new JLabel();  JTextField jTextField3 = new JTextField();  JLabel jLabel5 = new JLabel();  JComboBox jComboBox2 = new JComboBox();  JLabel jLabel6 = new JLabel();  JTextField jTextField4 = new JTextField();  JLabel jLabel7 = new JLabel();  JTextField jTextField5 = new JTextField();  JLabel jLabel8 = new JLabel();  JTextField jTextField6 = new JTextField();  JLabel jLabel9 = new JLabel();  JTextField jTextField7 = new JTextField();  JLabel jLabel10 = new JLabel();  JTextField jTextField8 = new JTextField();  JLabel jLabel11 = new JLabel();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();   mainFrame  a;   Database database;  QueryDataSet queryDataSet;  QueryDataSet queryDataSet1;  JLabel jLabel12 = new JLabel();  JLabel jLabel13 = new JLabel();  JPanel jPanel4 = new JPanel();  Border border1;  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JComboBox jComboBox3 = new JComboBox();  JLabel jLabel14 = new JLabel();  JLabel jLabel15 = new JLabel();  JComboBox jComboBox4 = new JComboBox();  JLabel jLabel16 = new JLabel();  JTextField jTextField1 = new JTextField();  JLabel jLabel17 = new JLabel();  JComboBox jComboBox5 = new JComboBox();  JButton jButton3 = new JButton();  ParameterRow parameterRow1;  QueryDataSet queryDataSet2;  QueryDataSet queryDataSet3 = new QueryDataSet();  QueryDataSet queryDataSet4 = new QueryDataSet();  QueryDataSet queryDataSet5 = new QueryDataSet();  QueryDataSet queryDataSet6 = new QueryDataSet();  QueryDataSet queryDataSet7 = new QueryDataSet();  QueryDataSet queryDataSet8 = new QueryDataSet();  QueryDataSet queryDataSet9 = new QueryDataSet();  QueryDataSet queryDataSet10 = new QueryDataSet();  QueryDataSet queryDataSet11 = new QueryDataSet();  JLabel jLabel18 = new JLabel();  JLabel jLabel19 = new JLabel();  JLabel jLabel20 = new JLabel();  JPasswordField jPasswordField1 = new JPasswordField();  JPasswordField jPasswordField2 = new JPasswordField();  JPasswordField jPasswordField3 = new JPasswordField();  JButton jButton4 = new JButton();  JButton jButton5 = new JButton();  QueryDataSet queryDataSet12 = new QueryDataSet();  ParameterRow parameterRow2 = new ParameterRow();  Column column1 = new Column();  Column column2 = new Column();  QueryDataSet queryDataSet13 = new QueryDataSet();  public studentFrame(mainFrame  a,Database database,QueryDataSet queryDataSet,QueryDataSet queryDataSet1,QueryDataSet queryDataSet2, ParameterRow parameterRow2) {    try {     this.a=a;     this.database=database;     this.queryDataSet=queryDataSet;     this.queryDataSet1=queryDataSet1;     this.queryDataSet2= queryDataSet2;    this.parameterRow1=parameterRow2;     jbInit();    a();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    border1 = new EtchedBorder(EtchedBorder.RAISED,Color.white,new Color(165, 163, 151));    this.getContentPane().setLayout(null);    jTabbedPane1.setEnabled(true);    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 15));    jTabbedPane1.setDebugGraphicsOptions(0);    jTabbedPane1.setToolTipText("");    jTabbedPane1.setVerifyInputWhenFocusTarget(true);    jTabbedPane1.setBounds(new Rectangle(5, 16, 544, 376));    jPanel1.setAlignmentY((float) 0.5);    jPanel1.setDebugGraphicsOptions(0);    jPanel1.setMinimumSize(new Dimension(1, 1));    jPanel1.setOpaque(true);    jPanel1.setPreferredSize(new Dimension(10, 10));    jPanel1.setRequestFocusEnabled(true);    jPanel1.setToolTipText("");    jPanel1.setLayout(null);    jPanel2.setLayout(null);    jPanel2.setAlignmentX((float) 0.5);    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel1.setText("姓       名");    jLabel1.setBounds(new Rectangle(8, 8, 62, 26));    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel2.setText("性      別");    jLabel2.setBounds(new Rectangle(8, 51, 74, 26));    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox1.setBounds(new Rectangle(83, 51, 105, 26));    jComboBox1.addItem("男");    jComboBox1.addItem("女");    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel3.setText("身份證號");    jLabel3.setBounds(new Rectangle(3, 168, 73, 26));    jTextField2.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField2.setText("");    jTextField2.setBounds(new Rectangle(83, 173, 106, 26));    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel4.setText("出生日期");    jLabel4.setBounds(new Rectangle(4, 89, 72, 26));    jTextField3.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField3.setMaximumSize(new Dimension(2147483647, 2147483647));    jTextField3.setText("");    jTextField3.setBounds(new Rectangle(83, 87, 105, 26));    jTextField3.addActionListener(new studentFrame_jTextField3_actionAdapter(this));    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel5.setText("政治面貌");    jLabel5.setBounds(new Rectangle(215, 88, 101, 26));    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox2.setBounds(new Rectangle(278, 90, 94, 26));    jComboBox2.addItem("中共黨員");    jComboBox2.addItem("中青團員");    jComboBox2.addItem("群眾");    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel6.setText("籍貫");    jLabel6.setBounds(new Rectangle(215, 48, 44, 26));    jTextField4.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField4.setText("");    jTextField4.setBounds(new Rectangle(278, 48, 94, 26));    jLabel7.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel7.setText("個人電話");    jLabel7.setBounds(new Rectangle(4, 130, 74, 26));    jTextField5.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField5.setText("");    jTextField5.setBounds(new Rectangle(83, 130, 105, 26));    jLabel8.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel8.setText("家庭電話");    jLabel8.setBounds(new Rectangle(215, 131, 75, 26));    jTextField6.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField6.setText("");    jTextField6.setBounds(new Rectangle(278, 131, 94, 26));    jLabel9.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel9.setText("家庭住址");    jLabel9.setBounds(new Rectangle(4, 212, 73, 26));    jTextField7.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField7.setText("");    jTextField7.setBounds(new Rectangle(83, 215, 304, 26));    jLabel10.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel10.setText("家庭郵編");    jLabel10.setBounds(new Rectangle(215, 173, 83, 26));    jTextField8.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField8.setText("");    jTextField8.setBounds(new Rectangle(278, 173, 94, 26));    jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel11.setText("學號");    jLabel11.setBounds(new Rectangle(215, 15, 47, 19));    jButton1.setBounds(new Rectangle(72, 272, 107, 27));    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));    jButton1.setText("保存");    jButton1.addActionListener(new studentFrame_jButton1_actionAdapter(this));    jButton2.setBounds(new Rectangle(236, 271, 123, 30));    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));    jButton2.setText("退出");    jLabel12.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel12.setText("");    jLabel12.setBounds(new Rectangle(83, 10, 103, 24));    jLabel13.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel13.setText("");    jLabel13.setBounds(new Rectangle(278, 5, 93, 29));    jPanel4.setBorder(border1);    jPanel4.setBounds(new Rectangle(11, 95, 465, 194));    jPanel4.setLayout(null);    tableScrollPane1.setBounds(new Rectangle(3, 5, 456, 186));    jComboBox3.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox3.setBounds(new Rectangle(84, 12, 141, 24));    jComboBox3.addActionListener(new studentFrame_jComboBox3_actionAdapter(this));    jLabel14.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel14.setText("學年");    jLabel14.setBounds(new Rectangle(15, 11, 52, 25));    jLabel15.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel15.setText("學期");    jLabel15.setBounds(new Rectangle(237, 13, 47, 24));    jComboBox4.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox4.setBounds(new Rectangle(282, 13, 107, 26));    jComboBox4.addActionListener(new studentFrame_jComboBox4_actionAdapter(this));    jLabel16.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel16.setText("課程名");    jLabel16.setBounds(new Rectangle(233, 49, 65, 26));    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField1.setBounds(new Rectangle(282, 48, 108, 27));    jTextField1.addActionListener(new studentFrame_jTextField1_actionAdapter(this));    jLabel17.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel17.setText("修習類別");    jLabel17.setBounds(new Rectangle(15, 54, 77, 23));    jComboBox5.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox5.setBounds(new Rectangle(84, 56, 140, 22));    jComboBox5.addActionListener(new studentFrame_jComboBox5_actionAdapter(this));    jButton3.setBounds(new Rectangle(403, 48, 73, 26));    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));    jButton3.setText("確定");    jButton3.addActionListener(new studentFrame_jButton3_actionAdapter(this));    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 學年=:學年 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 學年=:學年 and 學期=:學期 and 修習類別=:修習類別 and " +      "學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 學年=:學年 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet6.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 學年=:學年 and 學期=:學期 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet7.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where  學期=:學期 and 修習類別=:修習類別 \nand 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet9.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where  學期=:學期 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet10.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 學年=:學年 and 修習類別=:修習類別 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet8.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 修習類別=:修習類別 and 學號=:學號", parameterRow1, true, Load.ALL));    queryDataSet11.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 課程名=:課程名 and 學號=:學號", parameterRow1, true, Load.ALL));    jPanel3.setLayout(null);    jLabel18.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel18.setText("原密碼");    jLabel18.setBounds(new Rectangle(93, 55, 66, 29));    jLabel19.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel19.setRequestFocusEnabled(true);    jLabel19.setVerifyInputWhenFocusTarget(true);    jLabel19.setText("新密碼");    jLabel19.setBounds(new Rectangle(93, 109, 58, 29));    jLabel20.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel20.setText("確認密碼");    jLabel20.setBounds(new Rectangle(93, 166, 94, 29));    jPasswordField1.setText("");    jPasswordField1.setBounds(new Rectangle(188, 55, 123, 29));    jPasswordField2.setText("");    jPasswordField2.setBounds(new Rectangle(188, 109, 123, 29));    jPasswordField3.setText("");    jPasswordField3.setBounds(new Rectangle(188, 166, 123, 29));    jButton4.setBounds(new Rectangle(116, 225, 101, 29));    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));    jButton4.setBorderPainted(true);    jButton4.setText("確定");    jButton4.addActionListener(new studentFrame_jButton4_actionAdapter(this));    jButton5.setBounds(new Rectangle(248, 225, 101, 29));    jButton5.setFont(new java.awt.Font("Dialog", 0, 15));    jButton5.setBorderPainted(true);    jButton5.setText("退出");    queryDataSet12.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from entermessage where enterNum=:enterNum and \nliebie=:liebie", parameterRow2, true, Load.ALL));    column1.setColumnName("enterNum");    column1.setDataType(com.borland.dx.dataset.Variant.STRING);    column1.setServerColumnName("NewColumn1");    column1.setSqlType(0);    column2.setColumnName("liebie");    column2.setDataType(com.borland.dx.dataset.Variant.STRING);    column2.setServerColumnName("NewColumn2");    column2.setSqlType(0);    queryDataSet13.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from xieqi", null, true, Load.ALL));    jTabbedPane1.add(jPanel1,   "學生基本信息");    jPanel1.add(jLabel1, null);    jPanel1.add(jLabel4, null);    jPanel1.add(jTextField3, null);    jPanel1.add(jLabel5, null);    jPanel1.add(jComboBox2, null);    jPanel1.add(jTextField6, null);    jPanel1.add(jLabel8, null);    jPanel1.add(jTextField5, null);    jPanel1.add(jLabel7, null);    jPanel1.add(jLabel3, null);    jPanel1.add(jTextField2, null);    jPanel1.add(jTextField8, null);    jPanel1.add(jLabel10, null);    jPanel1.add(jTextField7, null);    jPanel1.add(jLabel9, null);    jPanel1.add(jLabel6, null);    jPanel1.add(jTextField4, null);    jPanel1.add(jButton1, null);    jPanel1.add(jButton2, null);    jPanel1.add(jLabel11, null);    jPanel1.add(jComboBox1, null);    jPanel1.add(jLabel2, null);    jPanel1.add(jLabel12, null);    jPanel1.add(jLabel13, null);    jTabbedPane1.add(jPanel2, "成績查詢");    jPanel2.add(jPanel4, null);    jPanel4.add(tableScrollPane1, null);    jPanel2.add(jLabel14, null);    jPanel2.add(jLabel17, null);    jPanel2.add(jComboBox3, null);    jPanel2.add(jComboBox5, null);    jPanel2.add(jLabel15, null);    jPanel2.add(jLabel16, null);    jPanel2.add(jTextField1, null);    jPanel2.add(jComboBox4, null);    jPanel2.add(jButton3, null);    jComboBox3.addItem("所有學年");        queryDataSet13.executeQuery();      int i=queryDataSet13.rowCount();       for(int a=0;a<i;a++){       jComboBox3.addItem(queryDataSet13.getString("學年"));        queryDataSet13.next();      }    jComboBox4.addItem("所有學期");    jComboBox4.addItem("第一學期");    jComboBox4.addItem("第二學期");    jComboBox5.addItem("所有");    jComboBox5.addItem("必修");    jComboBox5.addItem("選修");    tableScrollPane1.getViewport().add(jdbTable1, null);    jTabbedPane1.add(jPanel3, "密碼修改");    jPanel3.add(jPasswordField1, null);    jPanel3.add(jPasswordField2, null);    jPanel3.add(jPasswordField3, null);    jPanel3.add(jLabel20, null);    jPanel3.add(jLabel19, null);    jPanel3.add(jLabel18, null);    jPanel3.add(jButton4, null);    jPanel3.add(jButton5, null);    this.getContentPane().add(jTabbedPane1, null);    jTabbedPane1.setSelectedIndex(0);   parameterRow1.setString("學號",queryDataSet1.getString("學號"));    jdbTable1.setDataSet(queryDataSet2);    parameterRow2.setColumns(new Column[] {column1, column2});  }public void a(){jLabel12.setText(queryDataSet1.getString("姓名"));jLabel13.setText(queryDataSet1.getString("學號"));if(queryDataSet.rowCount()>0){jComboBox1.setSelectedItem(queryDataSet.getString("性別"));jTextField2.setText(queryDataSet.getString("身份證號"));String date=String.valueOf(queryDataSet.getTimestamp("出生日期")).substring(0,10);jTextField3.setText(date);jComboBox2.setSelectedItem(queryDataSet.getString("政治面貌"));jTextField5.setText(queryDataSet.getString("個人電話"));jTextField4.setText(queryDataSet.getString("籍貫"));jTextField6.setText(queryDataSet.getString("家庭電話"));jTextField8.setText(queryDataSet.getString("家庭郵編"));jTextField7.setText(queryDataSet.getString("家庭住址"));