浏览成绩.java~73~

学生信息管理系统(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.*;
import java.sql.*;

/**
 * <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;
  String operator,password,right="2",mode;
  Connection connection;
  Connection con;
  Statement statement;
  Statement statement1;
  Statement stmt;
  int incourse=0,decourse=0,allcourse=0;
  ResultSet rs1,rs2;



  public 浏览成绩(Frame frame, String title, boolean modal) {
    super(frame, title, modal);

  }

  public 浏览成绩(String op,String pw,String rt,String md) {
    this(null, "", false);
    operator=op;password=pw;right=rt;mode=md;
    try {
       jbInit();
       pack();
     }
     catch(Exception ex) {
       ex.printStackTrace();
    } }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    this.setFocusable(false);
    this.setDefaultLookAndFeelDecorated(false);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jPanel1.setBounds(new Rectangle(23, 7, 261, 158));
    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(450, 200));
    jPanel3.setOpaque(true);
    jPanel3.setBounds(new Rectangle(39, 191, 460, 205));
    jPanel2.setDebugGraphicsOptions(0);
    jPanel2.setMaximumSize(new Dimension(32767, 32767));
    jPanel2.setBounds(new Rectangle(303, 7, 197, 111));

    jdbNavToolBar1.setBounds(new Rectangle(44, 164, 452, 28));
    ///////////////////////////////
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setPreferredSize(new Dimension(120, 30));
    jButton4.setSelected(false);
    jButton4.setText("总分");
    jButton4.addActionListener(new 浏览成绩_jButton4_actionAdapter(this));
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 20));
    jTextField4.setBorder(BorderFactory.createRaisedBevelBorder());
    jTextField4.setEditable(false);
    jTextField4.setText("");
    jTextField4.setBounds(new Rectangle(340, 117, 120, 44));
    this.setModal(false);
    this.setTitle("");
    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(jButton1, null);
    this.getContentPane().add(jPanel2, null);
    this.getContentPane().add(jPanel3, null);
    jPanel3.add(tableScrollPane1, null);
    this.getContentPane().add(jPanel1, null);

    this.getContentPane().add(jTextField4, null);
    jPanel2.add(jButton2, null);
    jPanel2.add(jButton3, null);
    jPanel2.add(jButton4, null);

   if(right.equals("0")) jdbNavToolBar1.setEnabled(false);
   else jdbNavToolBar1.setEnabled(true);

 this.getContentPane().add(jdbNavToolBar1, null);

  }

  void jButton1_actionPerformed(ActionEvent e) {

    String sql = "";
      //System.out.print(mode);
String str1=jTextField1.getText(),str2=jTextField2.getText(),str3=jTextField3.getText();
    if(Integer.parseInt(right)==0)
    {

      //判断查询条件
    sql="select  distinct 学生课程.学号,课程.课名,学生课程.成绩 from 课程,学生课程 where 学号=";
    sql+="'"+operator+"'";
    sql+=" AND 课程.课号=学生课程.课号";
    }//if学生查询
    else if(Integer.parseInt(right)==1)
    {
      sql= "select 学生课程.学号,学生课程.课号,学生课程.成绩 from 课程,学生课程 where ";
      sql+="课程.模块号="+mode;
      sql+=" AND 课程.课号=学生课程.课号";
      //判断查询条件
    if(str1.length()!=0||str2.length()!=0||str3.length()!=0)
               {sql+=" AND ";}
    if(str1.length()!=0)
        {sql+="学号="+"'"+str1+"'";
         if(str2.length()!=0||str3.length()!=0)
           sql+=" AND ";
       }
   if(str2.length()!=0){sql+="课号=" +str2;
                             if(str3.length()!=0)sql+=" AND ";
   }
   if(str3.length()!=0){sql+="成绩="+str3;}

    }
    else{
    sql="select *from 学生课程";
    //判断查询条件
     if(str1.length()!=0||str2.length()!=0||str3.length()!=0)
                {sql+=" where ";}
     if(str1.length()!=0)
         {sql+="学号="+"'"+str1+"'";
          if(str2.length()!=0||str3.length()!=0)
            sql+=" AND ";
        }
    if(str2.length()!=0){sql+="课号=" +str2;
                              if(str3.length()!=0)sql+=" AND ";
    }
    if(str3.length()!=0){sql+="成绩="+str3;}
    }
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) {
  if(Integer.parseInt(right)==0) JOptionPane.showMessageDialog(this,"无此权限！","警告",JOptionPane.INFORMATION_MESSAGE);
  else {
    增加成绩 增加成绩1 = new 增加成绩();
    增加成绩1.setBounds(50, 50,400, 380);
    增加成绩1.setTitle("增加成绩");
    增加成绩1.show();
  }
}
  void cancel() {
              dispose();
         }
  void jButton3_actionPerformed(ActionEvent e) {
           if (e.getSource() == jButton3) {
             cancel();
           }
  }
  JButton jButton4 = new JButton();
  JTextField jTextField4 = new JTextField();



//////////////总分//////////////////////////////////
  void jButton4_actionPerformed(ActionEvent e) {
    allcourse=0;incourse=0;decourse=0;
    if(Integer.parseInt(right)==0){
       String url = "jdbc:odbc:学生信息管理";
       String usern = "sample";
       String passw = "";
       try {
          Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
          connection = DriverManager.getConnection(url, usern, passw);
       }
       catch ( ClassNotFoundException cnfex ) {
          System.err.println( "装载 JDBC/ODBC 驱动程序失败。" );
          cnfex.printStackTrace();
          System.exit( 1 );
       }
       catch ( SQLException sqlex ) {
          System.err.println( "无法连接数据库" );
          sqlex.printStackTrace();
          System.exit( 1 );
       }

     String sql1="SELECT * FROM 学生课程 WHERE 学号=";
     sql1+="'"+operator+"'";

   String sql2="SELECT 违纪类型.扣分 FROM 违纪记录,违纪类型 WHERE 违纪记录.学号=";
   sql2+="'"+operator+"'"+" AND "+"违纪记录.违纪号=违纪类型.违纪号";
  /////////////incource///////////
   try {
           statement = connection.createStatement();
           rs1 = statement.executeQuery(sql1);    //执行SQL语句
                     // 显示查询结果
        }
        catch ( SQLException sqlex ) {
           sqlex.printStackTrace();
        }

    //System.out.println(sql1);
    //System.out.println(sql2);
  try{
       while(rs1.next())
         incourse+=Integer.parseInt(rs1.getString(3));
  }catch(SQLException ex){}
  /////////////////decource;///////////
  try {
           statement1 = connection.createStatement();
           rs2 = statement1.executeQuery(sql2);    //执行SQL语句
                     // 显示查询结果
        }
        catch ( SQLException sqlex ) {
           sqlex.printStackTrace();
        }

    //System.out.println(sql2);
   // System.out.println(sql2);
  try{
       while(rs2.next())
         decourse+=Integer.parseInt(rs2.getString(1));
  }catch(SQLException ex){}

    //System.out.println("incourse"+incourse);
     //System.out.println("ok");
  //  System.out.println("decourse"+incourse);
           if(decourse>30)decourse=30;
   allcourse=incourse-decourse;
    jTextField4.setText(String.valueOf(allcourse));
  }else{JOptionPane.showMessageDialog(this,"无此权限！","警告",JOptionPane.INFORMATION_MESSAGE);}
}

}







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);
  }
}

class 浏览成绩_jButton4_actionAdapter implements java.awt.event.ActionListener {
  浏览成绩 adaptee;

  浏览成绩_jButton4_actionAdapter(浏览成绩 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}