mutaoyouangframe.java

学生管理系统:有辅导员登入,学生登入和老师登入界面

package student;

import javax.swing.*;
import java.awt.*;
import javax.swing.border.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import java.awt.event.*;
import com.borland.dx.dataset.*;

public class mutaoyouangFrame extends JFrame {
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();

  JLabel jLabel2 = new JLabel();
  JComboBox jComboBox2 = new JComboBox();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JPanel jPanel4 = new JPanel();
  Border border1;
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  ParameterRow parameterRow1 = new ParameterRow();
  QueryDataSet queryDataSet3 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  QueryDataSet queryDataSet4 = new QueryDataSet();
  QueryDataSet queryDataSet5 = new QueryDataSet();
  Column column3 = new Column();
  QueryDataSet queryDataSet6 = new QueryDataSet();
  QueryDataSet queryDataSet7 = new QueryDataSet();
  Column column4 = new Column();
  QueryDataSet queryDataSet8 = new QueryDataSet();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JComboBox jComboBox3 = new JComboBox();
  JComboBox jComboBox4 = new JComboBox();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JPanel jPanel5 = new JPanel();
  Border border2;
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JdbTable jdbTable2 = new JdbTable();
  QueryDataSet queryDataSet9 = new QueryDataSet();
  QueryDataSet queryDataSet10 = new QueryDataSet();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JPasswordField jPasswordField1 = new JPasswordField();
  JPasswordField jPasswordField2 = new JPasswordField();
  JPasswordField jPasswordField3 = new JPasswordField();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  Column column8 = new Column();
  QueryDataSet queryDataSet11 = new QueryDataSet();
QueryDataSet queryDataSet;
  String leibie;
  JButton jButton7 = new JButton();
  QueryDataSet queryDataSet12 = new QueryDataSet();
  JButton jButton8 = new JButton();
  QueryDataSet queryDataSet13 = new QueryDataSet();
  public mutaoyouangFrame(QueryDataSet queryDataSet,String leibie) {
    try {
     this.leibie=leibie;
      this.queryDataSet=queryDataSet;
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    border1 = new EtchedBorder(EtchedBorder.RAISED,Color.white,new Color(165, 163, 151));
    border2 = new EtchedBorder(EtchedBorder.RAISED,Color.white,new Color(165, 163, 151));
    this.getContentPane().setLayout(null);
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTabbedPane1.setBounds(new Rectangle(-1, 2, 514, 342));
    jPanel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("院系");
    jLabel1.setBounds(new Rectangle(13, 17, 66, 26));
    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 15));
    jComboBox1.setBounds(new Rectangle(82, 15, 118, 28));
    jComboBox1.addActionListener(new mutaoyouangFrame_jComboBox1_actionAdapter(this));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setText("班级");
    jLabel2.setBounds(new Rectangle(13, 72, 66, 31));
    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 15));
    jComboBox2.setBounds(new Rectangle(82, 73, 118, 28));
    jComboBox2.addActionListener(new mutaoyouangFrame_jComboBox2_actionAdapter(this));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setText("学号");
    jLabel3.setBounds(new Rectangle(13, 134, 66, 23));
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(82, 124, 118, 28));
    jTextField1.addActionListener(new mutaoyouangFrame_jTextField1_actionAdapter(this));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel4.setText("姓名");
    jLabel4.setBounds(new Rectangle(13, 184, 66, 25));
    jTextField2.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(82, 181, 118, 28));
    jPanel4.setBorder(border1);
    jPanel4.setBounds(new Rectangle(219, 8, 276, 270));
    jPanel4.setLayout(null);
    tableScrollPane1.setBounds(new Rectangle(5, 6, 266, 261));
    jdbTable1.setFont(new java.awt.Font("Dialog", 0, 15));
    jdbTable1.setDebugGraphicsOptions(0);
    jdbTable1.setDoubleBuffered(false);
    jdbTable1.setAutoCreateColumnsFromModel(true);
    jdbTable1.setDataSet(queryDataSet1);
    jButton1.setBounds(new Rectangle(31, 235, 68, 30));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setText("确定");
    jButton1.addActionListener(new mutaoyouangFrame_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(128, 274, 68, 30));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setText("退出");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:studentmanage", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage", null, true, Load.ALL));
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from depart", null, true, Load.ALL));
    column1.setColumnName("系部名");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from class 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 班级=:班级名", parameterRow1, true, Load.ALL));
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 学号 in (\'11\',\'22\')", null, true, Load.ALL));
    column3.setColumnName("学号");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setServerColumnName("NewColumn1");
    column3.setSqlType(0);
    queryDataSet6.setReadOnly(false);
    queryDataSet6.setSchemaName("");
    queryDataSet6.setTableName("");
    queryDataSet6.setResolveOrder(null);
    queryDataSet6.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 学号=:学号", parameterRow1, true, Load.ALL));
    column4.setColumnName("姓名");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setServerColumnName("NewColumn1");
    column4.setSqlType(0);
    queryDataSet7.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from  student where 班级=:班级名 and 姓名=:姓名", parameterRow1, true, Load.ALL));
    queryDataSet8.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from  student where 学号=:学号 and 姓名=:姓名", parameterRow1, true, Load.ALL));
    jPanel2.setLayout(null);
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel5.setText("系别");
    jLabel5.setBounds(new Rectangle(10, 24, 69, 25));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel6.setText("班级");
    jLabel6.setBounds(new Rectangle(10, 75, 64, 23));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel7.setText("学号");
    jLabel7.setBounds(new Rectangle(10, 134, 49, 22));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel8.setText("姓名");
    jLabel8.setBounds(new Rectangle(10, 188, 48, 21));
    jComboBox3.setFont(new java.awt.Font("Dialog", 0, 15));
    jComboBox3.setBounds(new Rectangle(56, 25, 109, 24));
    jComboBox3.addActionListener(new mutaoyouangFrame_jComboBox3_actionAdapter(this));
    jComboBox4.setFont(new java.awt.Font("Dialog", 0, 15));
    jComboBox4.setBounds(new Rectangle(56, 74, 109, 24));
    jComboBox4.addActionListener(new mutaoyouangFrame_jComboBox4_actionAdapter(this));
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(56, 132, 109, 24));
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField4.setText("");
    jTextField4.setBounds(new Rectangle(56, 185, 109, 24));
    jPanel5.setBorder(border2);
    jPanel5.setBounds(new Rectangle(202, 25, 302, 257));
    jPanel5.setLayout(null);
    jButton3.setBounds(new Rectangle(16, 242, 77, 29));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton3.setText("确定");
    jButton3.addActionListener(new mutaoyouangFrame_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(100, 243, 77, 29));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setToolTipText("");
    jButton4.setText("取消");
    tableScrollPane2.setBounds(new Rectangle(10, 7, 286, 239));
    queryDataSet10.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stu_score where 学号=:学号", parameterRow1, true, Load.ALL));
    jPanel3.setLayout(null);
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel9.setText("原密码");
    jLabel9.setBounds(new Rectangle(121, 51, 90, 28));
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel10.setText("新密码");
    jLabel10.setBounds(new Rectangle(121, 112, 95, 28));
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel11.setRequestFocusEnabled(true);
    jLabel11.setText("确认密码 ");
    jLabel11.setBounds(new Rectangle(121, 163, 91, 32));
    jPasswordField1.setFont(new java.awt.Font("Dialog", 0, 15));
    jPasswordField1.setText("");
    jPasswordField1.setBounds(new Rectangle(212, 49, 119, 30));
    jPasswordField2.setFont(new java.awt.Font("Dialog", 0, 15));
    jPasswordField2.setText("");
    jPasswordField2.setBounds(new Rectangle(212, 110, 119, 30));
    jPasswordField3.setFont(new java.awt.Font("Dialog", 0, 15));
    jPasswordField3.setText("");
    jPasswordField3.setBounds(new Rectangle(212, 165, 119, 30));
    jButton5.setBounds(new Rectangle(135, 232, 86, 29));
    jButton5.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton5.setText("确定");
    jButton5.addActionListener(new mutaoyouangFrame_jButton5_actionAdapter(this));
    jButton6.setBounds(new Rectangle(253, 232, 86, 29));
    jButton6.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton6.setText("取消");
    jPanel3.setFont(new java.awt.Font("Dialog", 0, 15));
    column5.setSqlType(0);
    column5.setServerColumnName("NewColumn2");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setColumnName("liebie");
    column6.setSqlType(0);
    column6.setServerColumnName("NewColumn1");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setColumnName("enterNum");
    column7.setColumnName("enterNum");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setServerColumnName("NewColumn1");
    column7.setSqlType(0);
    column8.setColumnName("liebie");
    column8.setDataType(com.borland.dx.dataset.Variant.STRING);
    column8.setServerColumnName("NewColumn2");
    column8.setSqlType(0);
    parameterRow1.setColumns(new Column[] {column4, column2, column1, column3, column7, column8});
    queryDataSet11.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from entermessage where enterNum=:enterNum and \nliebie=:liebie", parameterRow1, true, Load.ALL));
    jButton7.setText("修改");
    jButton7.addActionListener(new mutaoyouangFrame_jButton7_actionAdapter(this));
    jButton7.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton7.setBounds(new Rectangle(128, 234, 68, 30));
    queryDataSet12.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 学号=:学号 and 姓名=:姓名", parameterRow1, true, Load.ALL));
    jButton8.setText("录入");
    jButton8.addActionListener(new mutaoyouangFrame_jButton8_actionAdapter(this));
    jButton8.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton8.setBounds(new Rectangle(31, 273, 68, 30));
    queryDataSet13.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student where 学号=:学号", parameterRow1, true, Load.ALL));
    this.getContentPane().add(jTabbedPane1, null);
    jTabbedPane1.add(jPanel1,"学生基本信息");
    jPanel1.add(jLabel1, null);
    jPanel1.add(jComboBox1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jComboBox2, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jPanel4, null);
    jPanel4.add(tableScrollPane1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);