package student;import javax.swing.*;import java.awt.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;import java.awt.event.*;import com.borland.dbswing.*;public class Frame2 extends JFrame {  JLabel jLabel8 = new JLabel();  JTextField jTextField6 = new JTextField();  JLabel jLabel4 = new JLabel();  JButton jButton2 = new JButton();  JLabel jLabel1 = new JLabel();  JTextField jTextField7 = new JTextField();  JLabel jLabel3 = new JLabel();  JTextField jTextField3 = new JTextField();  JLabel jLabel2 = new JLabel();  JButton jButton1 = new JButton();  JTextField jTextField8 = new JTextField();  JTextField jTextField5 = new JTextField();  JLabel jLabel9 = new JLabel();  JLabel jLabel11 = new JLabel();  JLabel jLabel7 = new JLabel();  JPanel jPanel1 = new JPanel();  JTextField jTextField2 = new JTextField();  JComboBox jComboBox2 = new JComboBox();  JLabel jLabel6 = new JLabel();  JComboBox jComboBox1 = new JComboBox();  JTextField jTextField4 = new JTextField();  JLabel jLabel10 = new JLabel();  JLabel jLabel5 = new JLabel();  JComboBox jComboBox3 = new JComboBox();  JComboBox jComboBox4 = new JComboBox();String Class;  Database database1 = new Database();  QueryDataSet queryDataSet1 = new QueryDataSet();  ParameterRow parameterRow1 = new ParameterRow();  Column column1 = new Column();  QueryDataSet queryDataSet2 = new QueryDataSet();String mark;  QueryDataSet queryDataSet3 = new QueryDataSet();  Column column2 = new Column();String stuno;  String stuName;  QueryDataSet queryDataSet4 = new QueryDataSet();  public Frame2(String Class,String mark,String stuno,String stuName) {    try {     this.stuName=stuName;     this.stuno=stuno;      this.mark=mark;          this.Class=Class;      jbInit();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    jPanel1.setLayout(null);    jPanel1.setToolTipText("");    jPanel1.setBounds(new Rectangle(0, 0, 539, 343));    jPanel1.setRequestFocusEnabled(true);    jPanel1.setPreferredSize(new Dimension(10, 10));    jPanel1.setOpaque(true);    jPanel1.setMinimumSize(new Dimension(1, 1));    jPanel1.setDebugGraphicsOptions(0);    jPanel1.setAlignmentY((float) 0.5);    jLabel7.setBounds(new Rectangle(4, 130, 74, 26));    jLabel7.setText("個人電話");    jLabel7.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel11.setBounds(new Rectangle(6, 15, 47, 19));    jLabel11.setText("學號");    jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel9.setBounds(new Rectangle(4, 212, 73, 26));    jLabel9.setText("家庭住址");    jLabel9.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField5.setBounds(new Rectangle(83, 130, 105, 26));    jTextField5.setText("");    jTextField5.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField8.setBounds(new Rectangle(278, 173, 94, 26));    jTextField8.setText("");    jTextField8.setFont(new java.awt.Font("Dialog", 0, 15));    jButton1.setText("保存");    jButton1.addActionListener(new Frame2_jButton1_actionAdapter(this));    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));    jButton1.setBounds(new Rectangle(72, 272, 107, 27));    jLabel2.setBounds(new Rectangle(8, 51, 74, 26));    jLabel2.setText("性      別");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField3.setBounds(new Rectangle(83, 87, 105, 26));    jTextField3.setText("");    jTextField3.setMaximumSize(new Dimension(2147483647, 2147483647));    jTextField3.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel3.setBounds(new Rectangle(3, 168, 73, 26));    jLabel3.setText("身份證號");    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField7.setBounds(new Rectangle(83, 215, 304, 26));    jTextField7.setText("");    jTextField7.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel1.setBounds(new Rectangle(208, 8, 62, 26));    jLabel1.setText("姓       名");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));    jButton2.setText("退出");    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));    jButton2.setBounds(new Rectangle(236, 271, 123, 30));    jLabel4.setBounds(new Rectangle(4, 89, 72, 26));    jLabel4.setText("出生日期");    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField6.setBounds(new Rectangle(278, 131, 94, 26));    jTextField6.setText("");    jTextField6.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel8.setBounds(new Rectangle(215, 131, 75, 26));    jLabel8.setText("家庭電話");    jLabel8.setFont(new java.awt.Font("Dialog", 0, 15));    this.getContentPane().setLayout(null);    jTextField2.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField2.setText("");    jTextField2.setBounds(new Rectangle(83, 173, 106, 26));    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox2.setBounds(new Rectangle(278, 90, 94, 26));    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel6.setText("籍貫");    jLabel6.setBounds(new Rectangle(215, 48, 44, 26));    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 15));    jComboBox1.setBounds(new Rectangle(83, 51, 105, 26));    jTextField4.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField4.setText("");    jTextField4.setBounds(new Rectangle(278, 48, 94, 26));    jLabel10.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel10.setText("家庭郵編");    jLabel10.setBounds(new Rectangle(215, 173, 83, 26));    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel5.setText("政治面貌");    jLabel5.setBounds(new Rectangle(215, 88, 101, 26));    jComboBox3.setBounds(new Rectangle(81, 8, 105, 26));    jComboBox4.setBounds(new Rectangle(278, 8, 94, 26));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:studentmanage", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    column1.setColumnName("班級");    column1.setDataType(com.borland.dx.dataset.Variant.STRING);    column1.setServerColumnName("NewColumn1");    column1.setSqlType(0);    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student where 班級=:班級", parameterRow1, true, Load.ALL));    queryDataSet2.setAccumulateResults(false);    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage,student where stumessage.學號=student.學號 and " +      "student.班級=:班級\n", parameterRow1, true, Load.ALL));    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 學號=:學號", parameterRow1, true, Load.ALL));    column2.setColumnName("學號");    column2.setDataType(com.borland.dx.dataset.Variant.STRING);    column2.setServerColumnName("NewColumn1");    column2.setSqlType(0);    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student where student.學號 not in (select stumessage.學號 " +      "from stumessage) and student.班級=:班級", parameterRow1, true, Load.ALL));    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(jComboBox1, null);    jPanel1.add(jLabel2, null);    jPanel1.add(jLabel1, null);    jPanel1.add(jLabel11, null);    jPanel1.add(jComboBox4, null);    jPanel1.add(jComboBox3, null);    this.getContentPane().add(jPanel1, null);    jComboBox2.addItem("中共黨員");    jComboBox2.addItem("中青團員");    jComboBox2.addItem("群眾");    jComboBox1.addItem("男");    jComboBox1.addItem("女");    parameterRow1.setColumns(new Column[] {column1, column2});    parameterRow1.setString("班級",Class);  if(mark=="修改"){   queryDataSet2.executeQuery();  int i=queryDataSet2.rowCount();    for(int a=0;a<i;a++){   jComboBox3.addItem(String.valueOf(queryDataSet2.getString("學號")));    jComboBox4.addItem(String.valueOf(queryDataSet2.getString("姓名")));    queryDataSet2.next();  }}if(mark=="錄入"){   queryDataSet4.executeQuery();  int i=queryDataSet4.rowCount();    for(int a=0;a<i;a++){   jComboBox3.addItem(String.valueOf(queryDataSet4.getString("學號")));    jComboBox4.addItem(String.valueOf(queryDataSet4.getString("姓名")));    queryDataSet4.next();  }}    jComboBox3.addActionListener(new Frame2_jComboBox3_actionAdapter(this));   jComboBox4.addActionListener(new Frame2_jComboBox4_actionAdapter(this));   if((!stuno.equals(""))&&(!stuName.equals(""))){    jComboBox3.setSelectedItem(stuno);     jComboBox4.setSelectedItem(stuName);   }   queryDataSet3.close();   parameterRow1.setString("學號",String.valueOf(jComboBox3.getSelectedItem()));    queryDataSet3.executeQuery();    if(queryDataSet3.rowCount()>0){    jComboBox1.setSelectedItem(String.valueOf(queryDataSet3.getString("性別")));    jTextField4.setText(String.valueOf(queryDataSet3.getString("籍貫")));     jTextField2.setText(queryDataSet3.getString("身份證號"));     String date=String.valueOf(queryDataSet3.getTimestamp("出生日期")).substring(0,10);       jTextField3.setText(date);      jComboBox2.setSelectedItem(queryDataSet3.getString("政治面貌"));      jTextField5.setText(queryDataSet3.getString("個人電話"));      jTextField6.setText(queryDataSet3.getString("家庭電話"));      jTextField8.setText(queryDataSet3.getString("家庭郵編"));      jTextField7.setText(queryDataSet3.getString("家庭住址"));    } }  void jComboBox3_actionPerformed(ActionEvent e) {     queryDataSet3.close();    jComboBox4.setSelectedIndex(jComboBox3.getSelectedIndex());    parameterRow1.setString("學號",String.valueOf(jComboBox3.getSelectedItem()));    queryDataSet3.executeQuery();    jComboBox1.setSelectedItem(String.valueOf(queryDataSet3.getString("性別")));    jTextField4.setText(String.valueOf(queryDataSet3.getString("籍貫")));    jTextField2.setText(queryDataSet3.getString("身份證號"));    String date=String.valueOf(queryDataSet3.getTimestamp("出生日期")).substring(0,10);      jTextField3.setText(date);     jComboBox2.setSelectedItem(queryDataSet3.getString("政治面貌"));     jTextField5.setText(queryDataSet3.getString("個人電話"));     jTextField6.setText(queryDataSet3.getString("家庭電話"));     jTextField8.setText(queryDataSet3.getString("家庭郵編"));     jTextField7.setText(queryDataSet3.getString("家庭住址"));    }  void jComboBox4_actionPerformed(ActionEvent e) {   queryDataSet3.close();    jComboBox3.setSelectedIndex(jComboBox4.getSelectedIndex());       parameterRow1.setString("學號",String.valueOf(jComboBox3.getSelectedItem()));       queryDataSet3.executeQuery();       jComboBox1.setSelectedItem(String.valueOf(queryDataSet3.getString("性別")));       jTextField4.setText(String.valueOf(queryDataSet3.getString("籍貫")));       jTextField2.setText(queryDataSet3.getString("身份證號"));       String date=String.valueOf(queryDataSet3.getTimestamp("出生日期")).substring(0,10);         jTextField3.setText(date);        jComboBox2.setSelectedItem(queryDataSet3.getString("政治面貌"));        jTextField5.setText(queryDataSet3.getString("個人電話"));        jTextField6.setText(queryDataSet3.getString("家庭電話"));        jTextField8.setText(queryDataSet3.getString("家庭郵編"));        jTextField7.setText(queryDataSet3.getString("家庭住址"));  }  void jButton1_actionPerformed(ActionEvent e) {    String sql="delete from stumessage where 學號='"+jComboBox3.getSelectedItem()+"'";      database1.executeStatement(sql);      if(!(jTextField3.getText().trim().equals(""))){      String sql1="insert into stumessage values('"+jComboBox3.getSelectedItem()          +"','"+jComboBox4.getSelectedItem()+"','"+jComboBox1.getSelectedItem()          +"','"+jTextField2.getText().trim()+"',"+jTextField3.getText().trim()          +",'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()          +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()          +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()           +"')";         database1.executeStatement(sql1);          }else{         String sql1="insert into stumessage (學號,姓名,性別,身份證號,政治面貌,籍貫,個人電話,家庭電話,家庭住址,家庭郵編) values('"+jComboBox3.getSelectedItem()          +"','"+jComboBox4.getSelectedItem()+"','"+jComboBox1.getSelectedItem()          +"','"+jTextField2.getText().trim()+"',"+"'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()          +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()          +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()          +"')";               database1.executeStatement(sql1);             }  }}class Frame2_jComboBox3_actionAdapter implements java.awt.event.ActionListener {  Frame2 adaptee;  Frame2_jComboBox3_actionAdapter(Frame2 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jComboBox3_actionPerformed(e);  }}class Frame2_jComboBox4_actionAdapter implements java.awt.event.ActionListener {  Frame2 adaptee;  Frame2_jComboBox4_actionAdapter(Frame2 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jComboBox4_actionPerformed(e);  }}class Frame2_jButton1_actionAdapter implements java.awt.event.ActionListener {  Frame2 adaptee;  Frame2_jButton1_actionAdapter(Frame2 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}