浏览档案.java~6~

学生信息管理系统(JBuilder x 开发,采用RSA 512位公钥加密,私钥用于找回密码,2006-4-5)

package untitled3;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2001</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class 浏览档案 extends JDialog {
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  FlowLayout flowLayout1 = new FlowLayout();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JPanel jPanel2 = new JPanel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JPanel jPanel3 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  FlowLayout flowLayout2 = new FlowLayout();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  private int counter=0;
  JLabel jLabel4 = new JLabel();
  JRadioButton jRadioButton1 = new JRadioButton();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField4 = new JTextField();
  private String operator,password,right,mode;

  public 浏览档案(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public 浏览档案(String op,String pw,String rt,String md) {
    this(null, "", false);
     operator=op;password=pw;right=rt;mode=md;
  }

private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jPanel1.setBounds(new Rectangle(23, 7, 261, 219));
    jPanel1.setLayout(flowLayout1);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setPreferredSize(new Dimension(80, 30));
    jLabel1.setText("学号：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setPreferredSize(new Dimension(80, 30));
    jLabel2.setText("姓名：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setPreferredSize(new Dimension(80, 30));
    jLabel3.setText("班级：");
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField1.setPreferredSize(new Dimension(120, 30));
    jTextField1.setText("");
    jTextField2.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField2.setPreferredSize(new Dimension(120, 30));
    jTextField2.setText("");
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField3.setPreferredSize(new Dimension(120, 30));
    jTextField3.setText("");
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setPreferredSize(new Dimension(120, 30));
    jButton1.setText("查找");
    jButton1.addActionListener(new 浏览档案_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setPreferredSize(new Dimension(120, 30));
    jButton2.setText("增加");
    jButton2.addActionListener(new 浏览档案_jButton2_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton3.setPreferredSize(new Dimension(120, 30));
    jButton3.setText("返回");
    jButton3.addActionListener(new 浏览档案_jButton3_actionAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:学生信息管理", "sample", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    jPanel3.setLayout(flowLayout2);
    jdbTable1.setFont(new java.awt.Font("Dialog", 0, 15));

    tableScrollPane1.setFont(new java.awt.Font("Dialog", 0, 15));
    tableScrollPane1.setPreferredSize(new Dimension(600, 200));
    jPanel3.setPreferredSize(new Dimension(650, 210));
    jPanel3.setBounds(new Rectangle(23, 264, 650, 239));
    jPanel2.setBounds(new Rectangle(302, 11, 197, 91));
    jdbNavToolBar1.setBounds(new Rectangle(25, 228, 452, 28));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel4.setPreferredSize(new Dimension(80, 30));
    jLabel4.setText("重修：");
    jRadioButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jRadioButton1.setMaximumSize(new Dimension(120, 30));
    jRadioButton1.setOpaque(true);
    jRadioButton1.setPreferredSize(new Dimension(120, 30));
    jRadioButton1.setText("是/否");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel5.setPreferredSize(new Dimension(80, 30));
    jLabel5.setText("期次：");
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField4.setPreferredSize(new Dimension(120, 30));
    jTextField4.setText("");
    jPanel1.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jTextField3, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jRadioButton1, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jTextField4, null);
    jPanel1.add(jButton1, null);
    this.getContentPane().add(jPanel1, null);

    this.getContentPane().add(jPanel3, null);
    jPanel3.add(tableScrollPane1, null);
    this.getContentPane().add(jdbNavToolBar1, null);
    this.getContentPane().add(jPanel2, null);
    jPanel2.add(jButton2, null);
    jPanel2.add(jButton3, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    String sql = "";

String str1=jTextField1.getText(),str2=jTextField2.getText(),str3=jTextField3.getText(),str4=String.valueOf(jRadioButton1.isSelected()),str5=jTextField3.getText();
     sql= "select * from 学生 where 重修="+str4;
     //判断查询条件
     if(Integer.parseInt(right)==1)
    {         // 学生.学号,学生.姓名,学生.班级,学生.期次,学生.总分
      sql= "select 学生.* from 用户,学生 where 学生.重修="+str4+" AND ";
      sql+="用户.模块号="+mode;
      sql+=" AND 用户.用户=学生.学号";

      //判断查询条件
      if(str1.length()!=0||str2.length()!=0||str3.length()!=0||str5.length()!=0)
                     {sql+=" AND ";}
          if(str1.length()!=0)
              {sql+="学生.学号="+"'"+str1+"'";
               if(str2.length()!=0||str3.length()!=0||str5.length()!=0)
                 sql+=" AND ";
             }
         if(str2.length()!=0){sql+="学生.姓名=" +"'"+str2+"'";
                                   if(str3.length()!=0||str5.length()!=0)sql+=" AND ";
         }
         if(str3.length()!=0){sql+="学生.班级="+"'"+str3+"'";
              if(str5.length()!=0)sql+=" AND ";
         }
       if(str5.length()!=0)sql+="学生.期次="+"'"+str5+"'";

//System.out.print(sql);

    }//if()老师查询
else{
     if(str1.length()!=0||str2.length()!=0||str3.length()!=0||str5.length()!=0)
                {sql+=" AND ";}
     if(str1.length()!=0)
         {sql+="学号="+"'"+str1+"'";
          if(str2.length()!=0||str3.length()!=0||str5.length()!=0)
            sql+=" AND ";
        }
    if(str2.length()!=0){sql+="姓名=" +"'"+str2+"'";
                              if(str3.length()!=0||str5.length()!=0)sql+=" AND ";
    }
    if(str3.length()!=0){sql+="班级="+"'"+str3+"'";
         if(str5.length()!=0)sql+=" AND ";
    }
  if(str5.length()!=0)sql+="期次="+"'"+str5+"'";
}
if(counter==0){
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL));
    counter++;
}
  else
       {queryDataSet1.close();
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL));
    }
    jdbTable1.setDataSet(queryDataSet1);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }

  void jButton2_actionPerformed(ActionEvent e) {
    增加档案 增加档案1=new 增加档案();
                      增加档案1.setBounds(50,50,640,480);
                      增加档案1.setTitle("增加档案");
                      增加档案1.show();

  }
  void cancel() {
              dispose();
         }
  void jButton3_actionPerformed(ActionEvent e) {
           if (e.getSource() == jButton3) {
             cancel();
           }
  }

}

class 浏览档案_jButton1_actionAdapter implements java.awt.event.ActionListener {
  浏览档案 adaptee;

  浏览档案_jButton1_actionAdapter(浏览档案 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class 浏览档案_jButton2_actionAdapter implements java.awt.event.ActionListener {
  浏览档案 adaptee;

  浏览档案_jButton2_actionAdapter(浏览档案 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class 浏览档案_jButton3_actionAdapter implements java.awt.event.ActionListener {
  浏览档案 adaptee;

  浏览档案_jButton3_actionAdapter(浏览档案 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}