passratioframe.java~6~

我用过的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 PassRatioFrame extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblshow = new JLabel();
    JLabel lblid = new JLabel();
    JLabel lblnum1 = new JLabel();
    JLabel lblpass = new JLabel();
    JTextField txtid = new JTextField();
    JTextField txtnum1 = new JTextField();
    JTextField txtpass = new JTextField();
    JButton btninput = new JButton();
    JButton btncheck = new JButton();
    JButton btnclose = new JButton();
    JOptionPane jOptionPane1 = new JOptionPane();

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setSize(450,350);
        this.setLocation(200,150);
        lblshow.setFont(new java.awt.Font("宋体", Font.PLAIN, 30));
        lblshow.setText("考试通过率统计");
        lblshow.setBounds(new Rectangle(116, 27, 229, 52));
        lblid.setText("班级编号");
        lblid.setBounds(new Rectangle(34, 94, 91, 28));
        lblnum1.setText("参考人数");
        lblnum1.setBounds(new Rectangle(162, 95, 91, 27));
        lblpass.setText("通过人数");
        lblpass.setBounds(new Rectangle(298, 94, 111, 23));
        txtid.setBounds(new Rectangle(24, 144, 94, 34));
        txtnum1.setBounds(new Rectangle(153, 143, 100, 33));
        txtpass.setBounds(new Rectangle(284, 144, 100, 31));
        btninput.setBounds(new Rectangle(37, 236, 98, 35));
        btninput.setText("输入数据");
        btninput.addActionListener(new PassRatioFrame_btninput_actionAdapter(this));
        btncheck.setBounds(new Rectangle(167, 236, 96, 34));
        btncheck.setText("通过率查询");
        btncheck.addActionListener(new PassRatioFrame_btncheck_actionAdapter(this));
        btnclose.setBounds(new Rectangle(303, 236, 100, 33));
        btnclose.setText("关闭");
        jOptionPane1.setBounds(new Rectangle(180, 284, 14, 24));
        this.getContentPane().add(lblid);
        this.getContentPane().add(lblpass);
        this.getContentPane().add(txtid);
        this.getContentPane().add(txtnum1);
        this.getContentPane().add(txtpass);
        this.getContentPane().add(btninput);
        this.getContentPane().add(btncheck);
        this.getContentPane().add(btnclose);
        this.getContentPane().add(lblshow);
        this.getContentPane().add(lblnum1);
        this.getContentPane().add(jOptionPane1);

    }

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

    public void btncheck_actionPerformed(ActionEvent e) {
        PassFrame p=new PassFrame();
        p.setVisible(true);
        this.setVisible(false);
    }

    public void btninput_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();
            int num1=Integer.parseInt(this.txtnum1.getText());
            int pass=Integer.parseInt(this.txtpass.getText());
            float pt=(float)pass/num1;
            int num=s.executeUpdate("insert into passratio values("+this.txtid.getText()+","+this.txtnum1.getText()+","+this.txtpass.getText()+","+pt+")");
            if(num>0)
            {
                this.jOptionPane1.showMessageDialog(this,"插入数据成功！");
            }
        } catch (SQLException ex1) {
        }
    }
}


class PassRatioFrame_btninput_actionAdapter implements ActionListener {
    private PassRatioFrame adaptee;
    PassRatioFrame_btninput_actionAdapter(PassRatioFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class PassRatioFrame_btncheck_actionAdapter implements ActionListener {
    private PassRatioFrame adaptee;
    PassRatioFrame_btncheck_actionAdapter(PassRatioFrame adaptee) {
        this.adaptee = adaptee;
    }

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