passframe.java~17~

我用过的SQL的数据库

package passratio;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JOptionPane;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 任炳林
 * @version 1.0
 */
public class PassFrame extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblshow = new JLabel();
    JLabel lblid = new JLabel();
    JTextField txtid = new JTextField();
    JLabel lblshow1 = new JLabel();
    JButton btncheck = new JButton();
    JButton btnclose = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();

    public PassFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(450,400);
        this.setLocation(200,150);
        lblshow.setFont(new java.awt.Font("宋体", Font.PLAIN, 35));
        lblshow.setText("通过率查询");
        lblshow.setBounds(new Rectangle(126, 25, 214, 55));
        btnclose.setBounds(new Rectangle(234, 268, 103, 41));
        btnclose.setText("关闭");
        btnclose.addActionListener(new PassFrame_btnclose_actionAdapter(this));
        btncheck.setBounds(new Rectangle(62, 268, 102, 42));
        btncheck.setText("查询");
        btncheck.addActionListener(new PassFrame_btncheck_actionAdapter(this));
        lblshow1.setBounds(new Rectangle(51, 188, 347, 56));
        txtid.setBounds(new Rectangle(180, 115, 183, 37));
        jOptionPane1.setBounds(new Rectangle(175, 167, 21, 12));
        this.getContentPane().add(txtid);
        this.getContentPane().add(lblshow1);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(btnclose);
        this.getContentPane().add(lblshow);
        this.getContentPane().add(lblid);
        this.getContentPane().add(jOptionPane1);
        lblid.setText("请输入班级号");
        lblid.setBounds(new Rectangle(44, 111, 107, 38));
    }

    public static void main(String[] args) {
        PassFrame passframe = new PassFrame();
        passframe.setVisible(true);
    }

    public void btncheck_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
        }
        try {
            Connection con = java.sql.DriverManager.getConnection(
                    "jdbc:odbc:test");
            Statement s=con.createStatement();
            ResultSet rs=s.executeQuery("select *from passratio where class_id='"+this.txtid.getText()+"'");
            if(this.txtid.getText().equals( rs.getInt(2)))
            {

                String aa="参考人数为："+rs.getInt(3)+"通过人数为："+rs.getInt(4)+"通过率为："+rs.getFloat(5)*100+"%";
                this.lblshow1.setText(aa);
            }
            else
            {
               this.lblshow1.setText("数据库中没有该班的信息，请核实！");
            }
            con.close();
            s.close();
            rs.close();
        } catch (SQLException ex1) {
        }
    }

    public void btnclose_actionPerformed(ActionEvent e) {
        System.exit(0);
    }
}


class PassFrame_btnclose_actionAdapter implements ActionListener {
    private PassFrame adaptee;
    PassFrame_btnclose_actionAdapter(PassFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnclose_actionPerformed(e);
    }
}


class PassFrame_btncheck_actionAdapter implements ActionListener {
    private PassFrame adaptee;
    PassFrame_btncheck_actionAdapter(PassFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncheck_actionPerformed(e);
    }
}