xieshenjuanglichuframe.java~28~

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

package student;

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

public class xieshenjuanglichuFrame extends JFrame {
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  JPanel jPanel1 = new JPanel();
  String leibie;
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  Database database1 = new Database();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  JdbTable jdbTable1 = new JdbTable();
 QueryDataSet queryDataSet1;
  QueryDataSet queryDataSet3 = new QueryDataSet();
  ParameterRow parameterRow1 = new ParameterRow();
  Column column1 = new Column();
  QueryDataSet queryDataSet4 = new QueryDataSet();
  public xieshenjuanglichuFrame(QueryDataSet queryDataSet1,String leibie) {
    try {
      this.leibie=leibie;
      this.queryDataSet1=queryDataSet1;
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    this.setLocale(java.util.Locale.getDefault());
    this.getContentPane().setLayout(null);
    jTabbedPane1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTabbedPane1.setBounds(new Rectangle(1, 0, 536, 366));
    jPanel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("新学年");
    jLabel1.setBounds(new Rectangle(10, 78, 69, 33));
    jButton1.setBounds(new Rectangle(7, 142, 88, 33));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setText("录入");
    jButton1.addActionListener(new xieshenjuanglichuFrame_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(116, 208, 88, 33));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setText("删除");
    jButton2.addActionListener(new xieshenjuanglichuFrame_jButton2_actionAdapter(this));
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField1.setSelectionStart(11);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(71, 78, 154, 31));
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setForeground(Color.red);
    jLabel2.setText("格式为：2005－2006学年度");
    jLabel2.setBounds(new Rectangle(5, 8, 269, 48));
    jButton3.setText("修改");
    jButton3.addActionListener(new xieshenjuanglichuFrame_jButton3_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton3.setBounds(new Rectangle(119, 143, 88, 33));
    jButton4.setText("查找");
    jButton4.addActionListener(new xieshenjuanglichuFrame_jButton4_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setBounds(new Rectangle(9, 209, 88, 33));
    tableScrollPane1.setBounds(new Rectangle(258, 40, 264, 242));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:studentmanage", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from xieqi", null, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSet2);
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from xieqi where 学年=:学年", parameterRow1, true, Load.ALL));
    column1.setColumnName("学年");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    this.getContentPane().add(jTabbedPane1, null);
     jPanel1.add(tableScrollPane1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    mutaoyouangFrame a1=new mutaoyouangFrame(queryDataSet1,queryDataSet1.getString("liebie"));
    a1.setSize(600,400);
    parameterRow1.setColumns(new Column[] {column1});
    teacherFrame a2=new teacherFrame (queryDataSet1,"",leibie);
      System.out.print(leibie);
      jTabbedPane1.add(a1.jPanel1,  "学生基本信息");
     jTabbedPane1.add(a1.jPanel2,  "学生成绩查询");
     jTabbedPane1.add(a2.jPanel2,  "学生成绩修改");
     jTabbedPane1.add(a1.jPanel3,  "密码修改");
      jTabbedPane1.add(jPanel1, "jPanel1");
     jPanel1.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jButton4, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton3, null);



  }

  void jButton1_actionPerformed(ActionEvent e) {
    if(!(jTextField1.getText().trim().equals(""))){
    String xieliang=jTextField1.getText().trim();
         queryDataSet3.close();
         parameterRow1.setString("学年",xieliang);
          queryDataSet3.executeQuery();
   if(queryDataSet3.rowCount()>0){
    JOptionPane.showMessageDialog(this,"学期已存在","信息提示",2);
   }else{
   String sql="insert into xieqi values('"+xieliang+"')";
  database1.executeStatement(sql);
  queryDataSet2.refresh();
   jdbTable1.setDataSet(queryDataSet2);
 JOptionPane.showMessageDialog(this,"录入成功");
}
    }else{
    JOptionPane.showMessageDialog(this,"请输入完整");
    return;
    }
        }

  void jButton3_actionPerformed(ActionEvent e) {
    if(!(jTextField1.getText().trim().equals(""))){
      String xieliang=jTextField1.getText().trim();
     Dialog1 aa=new Dialog1(this,"学期修改",false,xieliang);
     aa.show();

      } else{
        JOptionPane.showMessageDialog(this,"请输入完整");
        return;
        }

  }

  void jButton4_actionPerformed(ActionEvent e) {
    if(!(jTextField1.getText().trim().equals(""))){
  String xieliang=jTextField1.getText().trim();
       queryDataSet3.close();
       parameterRow1.setString("学年",xieliang);
        queryDataSet3.executeQuery();
 if(queryDataSet3.rowCount()>0){
 queryDataSet3.refresh();
 jdbTable1.setDataSet(queryDataSet3);

 }else{
 JOptionPane.showMessageDialog(this,"学期不存在","信息提示",2);
}
  }else{
  JOptionPane.showMessageDialog(this,"请输入完整");
  return;
  }


  }

  void jButton2_actionPerformed(ActionEvent e) {
    if(!(jTextField1.getText().trim().equals(""))){
       String xieliang=jTextField1.getText().trim();
            queryDataSet3.close();
            parameterRow1.setString("学年",xieliang);
             queryDataSet3.executeQuery();
      if(queryDataSet3.rowCount()>0){
       String sql="delete from xieqi where 学年='"+xieliang+"'";
        database1.executeStatement(sql);
       queryDataSet2.refresh();
        jdbTable1.setDataSet(queryDataSet2);
      JOptionPane.showMessageDialog(this,"删除成功");

      }else{
       JOptionPane.showMessageDialog(this,"学期不存在","信息提示",2);

   }
       }else{
       JOptionPane.showMessageDialog(this,"请输入完整");
       return;
       }

  }
}

class xieshenjuanglichuFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  xieshenjuanglichuFrame adaptee;

  xieshenjuanglichuFrame_jButton1_actionAdapter(xieshenjuanglichuFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class xieshenjuanglichuFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  xieshenjuanglichuFrame adaptee;

  xieshenjuanglichuFrame_jButton3_actionAdapter(xieshenjuanglichuFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class xieshenjuanglichuFrame_jButton4_actionAdapter implements java.awt.event.ActionListener {
  xieshenjuanglichuFrame adaptee;

  xieshenjuanglichuFrame_jButton4_actionAdapter(xieshenjuanglichuFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class xieshenjuanglichuFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  xieshenjuanglichuFrame adaptee;

  xieshenjuanglichuFrame_jButton2_actionAdapter(xieshenjuanglichuFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}