package student;import java.awt.*;import java.awt.event.*;import javax.swing.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class mainFrame extends JFrame {  JPanel contentPane;  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JTextField jTextField1 = new JTextField();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();  JRadioButton jRadioButton1 = new JRadioButton();  JRadioButton jRadioButton2 = new JRadioButton();  JRadioButton jRadioButton3 = new JRadioButton();  JRadioButton jRadioButton4 = new JRadioButton();  Database database1 = new Database();  QueryDataSet queryDataSet1 = new QueryDataSet();  ParameterRow parameterRow1 = new ParameterRow();  Column column1 = new Column();  Column column2 = new Column();  ButtonGroup buttonGroup1 = new ButtonGroup();  JPasswordField jPasswordField1 = new JPasswordField();  QueryDataSet queryDataSet2 = new QueryDataSet();  QueryDataSet queryDataSet3 = new QueryDataSet();  QueryDataSet queryDataSet4 = new QueryDataSet();  QueryDataSet queryDataSet5 = new QueryDataSet();  ParameterRow parameterRow2 = new ParameterRow();  Column column3 = new Column();  Column column4 = new Column();  Column column5 = new Column();  Column column6 = new Column();  Column column7 = new Column();  //Construct the frame  public mainFrame() {    enableEvents(AWTEvent.WINDOW_EVENT_MASK);    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  //Component initialization  private void jbInit() throws Exception  {    contentPane = (JPanel) this.getContentPane();    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel1.setText("學號");    jLabel1.setBounds(new Rectangle(51, 34, 89, 24));    contentPane.setLayout(null);    this.setSize(new Dimension(341, 300));    this.setTitle("學生管理系統登陸");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));    jLabel2.setText("密碼");    jLabel2.setBounds(new Rectangle(49, 77, 82, 22));    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));    jTextField1.setText("");    jTextField1.setBounds(new Rectangle(145, 32, 116, 29));    jButton1.setBounds(new Rectangle(39, 200, 88, 28));    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));    jButton1.setText("確定");    jButton1.addActionListener(new mainFrame_jButton1_actionAdapter(this));    jButton2.setBounds(new Rectangle(175, 200, 95, 28));    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));    jButton2.setText("取消");    jButton2.addActionListener(new mainFrame_jButton2_actionAdapter(this));    jRadioButton1.setFont(new java.awt.Font("Dialog", 0, 15));    jRadioButton1.setSelected(true);    jRadioButton1.setText("學生");    jRadioButton1.setBounds(new Rectangle(60, 120, 69, 18));    jRadioButton2.setFont(new java.awt.Font("Dialog", 0, 15));    jRadioButton2.setText("老師");    jRadioButton2.setBounds(new Rectangle(170, 119, 69, 23));    jRadioButton3.setFont(new java.awt.Font("Dialog", 0, 15));    jRadioButton3.setToolTipText("");    jRadioButton3.setText("學生管理處");    jRadioButton3.setBounds(new Rectangle(166, 153, 122, 20));    jRadioButton4.setFont(new java.awt.Font("Dialog", 0, 15));    jRadioButton4.setText("輔導員");    jRadioButton4.setBounds(new Rectangle(60, 153, 90, 23));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:studentmanage", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    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);    parameterRow1.setColumns(new Column[] {column1, column2});    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from entermessage where enterNum=:enterNum and liebie=:liebie", parameterRow1, true, Load.ALL));    jPasswordField1.setBounds(new Rectangle(145, 77, 116, 29));    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 學號=:enterNum", parameterRow1, true, Load.ALL));    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student where 學號=:enterNum", parameterRow1, true, Load.ALL));    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "insert into stumessage values(\'03162337\',\'fda\',\'aa\',\'3333\',\'1983-10-8\',\'32ew\',\'ewe\',\'wew\',\'ewwee\',\'we" +      "w\',\'wewe\') ", null, true, Load.ALL));    column3.setColumnName("學號");    column3.setDataType(com.borland.dx.dataset.Variant.STRING);    column3.setServerColumnName("NewColumn1");    column3.setSqlType(0);    column4.setColumnName("學年");    column4.setDataType(com.borland.dx.dataset.Variant.STRING);    column4.setServerColumnName("NewColumn2");    column4.setSqlType(0);    column5.setColumnName("學期");    column5.setDataType(com.borland.dx.dataset.Variant.STRING);    column5.setServerColumnName("NewColumn1");    column5.setSqlType(0);    column6.setColumnName("課程名");    column6.setDataType(com.borland.dx.dataset.Variant.STRING);    column6.setServerColumnName("NewColumn2");    column6.setSqlType(0);    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stu_score where 學號=:學號 ", parameterRow2, true, Load.ALL));    column7.setColumnName("修習類別");    column7.setDataType(com.borland.dx.dataset.Variant.STRING);    column7.setServerColumnName("NewColumn1");    column7.setSqlType(0);    parameterRow2.setColumns(new Column[] {column3, column4, column5, column6, column7});    contentPane.add(jTextField1, null);    contentPane.add(jLabel1, null);    contentPane.add(jLabel2, null);    contentPane.add(jPasswordField1, null);    contentPane.add(jRadioButton1, null);    contentPane.add(jRadioButton2, null);    contentPane.add(jRadioButton3, null);    contentPane.add(jRadioButton4, null);    contentPane.add(jButton2, null);    contentPane.add(jButton1, null);    buttonGroup1.add(jRadioButton1);    buttonGroup1.add(jRadioButton2);    buttonGroup1.add(jRadioButton4);    buttonGroup1.add(jRadioButton3);  }  //Overridden so we can exit when window is closed  protected void processWindowEvent(WindowEvent e) {    super.processWindowEvent(e);    if (e.getID() == WindowEvent.WINDOW_CLOSING) {      System.exit(0);    }  }  void jButton1_actionPerformed(ActionEvent e) {   String enterNum=jTextField1.getText().trim();   String password= jPasswordField1.getText().trim();  if(enterNum.equals("")||password.equals("")){  JOptionPane.showMessageDialog(this,"該學生號或密碼不能為空","信息提示",2);  return;}else{   if(jRadioButton1.isSelected()){   parameterRow1.setString("liebie","學生");   parameterRow1.setString("enterNum",enterNum);   queryDataSet1.executeQuery();   if(enterNum.equals(queryDataSet1.getString("enterNum"))){     if(password.equals(queryDataSet1.getString("password"))){         parameterRow1.setString("enterNUm",enterNum);         queryDataSet2.executeQuery();        queryDataSet3.executeQuery();         studentFrame a=new studentFrame (this,database1,queryDataSet2,queryDataSet3,queryDataSet5,parameterRow2);         a.setSize(500,400);         a.show();     }else{         JOptionPane.showMessageDialog(this,"密碼錯誤","信息提示",2);         queryDataSet1.close();        return;       }   }else{    JOptionPane.showMessageDialog(this,"該學生號不存在","信息提示",2);       queryDataSet1.close();          return;     }   }   if(jRadioButton2.isSelected()){     parameterRow1.setString("liebie","老師");     parameterRow1.setString("enterNum",enterNum);   queryDataSet1.executeQuery();     if(enterNum.equals(queryDataSet1.getString("enterNum"))){       if(password.equals(queryDataSet1.getString("password"))){           JOptionPane.showMessageDialog(this,"登陸成功");              teacherFrame a=new teacherFrame(queryDataSet1,enterNum,"老師");              a.setSize(600,400);              a.show();         }else{           JOptionPane.showMessageDialog(this,"密碼錯誤","信息提示",2);           queryDataSet1.close();          return;         }     }else{      JOptionPane.showMessageDialog(this,"該登陸號不存在","信息提示",2);         queryDataSet1.close();            return;       }     }     if(jRadioButton4.isSelected()){       parameterRow1.setString("liebie","輔導員");       parameterRow1.setString("enterNum",enterNum);     queryDataSet1.executeQuery();       if(enterNum.equals(queryDataSet1.getString("enterNum"))){         if(password.equals(queryDataSet1.getString("password"))){             JOptionPane.showMessageDialog(this,"登陸成功");             mutaoyouangFrame a=new mutaoyouangFrame(queryDataSet1,queryDataSet1.getString("liebie"));             a.setSize(540,400);             a.show();           }else{             JOptionPane.showMessageDialog(this,"密碼錯誤","信息提示",2);             queryDataSet1.close();            return;           }       }else{        JOptionPane.showMessageDialog(this,"該輔導員號不存在","信息提示",2);           queryDataSet1.close();              return;         }       }       if(jRadioButton3.isSelected()){              parameterRow1.setString("liebie","學生管理處");              parameterRow1.setString("enterNum",enterNum);             queryDataSet1.executeQuery();              if(enterNum.equals(queryDataSet1.getString("enterNum"))){                if(password.equals(queryDataSet1.getString("password"))){                    JOptionPane.showMessageDialog(this,"登陸成功");                    xieshenjuanglichuFrame a=new xieshenjuanglichuFrame(queryDataSet1,"學生管理處");                    a.setSize(540,400);                    a.show();                  }else{                    JOptionPane.showMessageDialog(this,"密碼錯誤","信息提示",2);                    queryDataSet1.close();                   return;                  }              }else{               JOptionPane.showMessageDialog(this,"該學生管理處號不存在","信息提示",2);                  queryDataSet1.close();                     return;                }}              } }  void jButton2_actionPerformed(ActionEvent e) {    System.exit(0);  }}class mainFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {  mainFrame adaptee;  mainFrame_jButton1_actionAdapter(mainFrame adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class mainFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {  mainFrame adaptee;  mainFrame_jButton2_actionAdapter(mainFrame adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}