一个简单的计算考试通过率统计

package passratio; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JLabel; import java.awt.Rectangle; import java.awt.Font; import javax.swing.JTextField; import javax.swing.JButton; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.ResultSet; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.swing.JOptionPane; import java.sql.Statement; /** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class PassRatioFrame extends JFrame { // DbConn dbc; // Connection conn; JPanel contentPane; ResultSet rs; JLabel jLabel1 = new JLabel(); JTextField jTextField1 = new JTextField(); JTextField jTextField2 = new JTextField(); JTextField jTextField3 = new JTextField(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JButton jButton3 = new JButton(); JOptionPane jOptionPane1 = new JOptionPane(); public PassRatioFrame() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { contentPane = (JPanel) getContentPane(); contentPane.setLayout(null); setSize(new Dimension(400, 300)); setTitle("考试通过率统计对比"); jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15)); jLabel1.setText("考试通过率统计"); jLabel1.setBounds(new Rectangle(129, 40, 125, 46)); jTextField1.setBounds(new Rectangle(39, 150, 88, 30)); jTextField2.setBounds(new Rectangle(156, 150, 88, 30)); jTextField3.setBounds(new Rectangle(270, 150, 88, 30)); jLabel2.setText("班级号"); jLabel2.setBounds(new Rectangle(49, 98, 82, 34)); jLabel3.setToolTipText(""); jLabel3.setText("参考人数"); jLabel3.setBounds(new Rectangle(160, 96, 80, 34)); jLabel4.setText("通过人数"); jLabel4.setBounds(new Rectangle(283, 98, 78, 34)); jButton1.setBounds(new Rectangle(36, 215, 86, 31)); jButton1.setText("输入数据"); jButton1.addActionListener(new PassRatioFrame_jButton1_actionAdapter(this)); jButton2.setBounds(new Rectangle(150, 214, 103, 31)); jButton2.setText("通过率查询"); jButton2.addActionListener(new PassRatioFrame_jButton2_actionAdapter(this)); jButton3.setBounds(new Rectangle(274, 214, 86, 31)); jButton3.setText("关闭"); jButton3.addActionListener(new PassRatioFrame_jButton3_actionAdapter(this)); jOptionPane1.setBounds(new Rectangle(22, 257, 131, 28)); contentPane.add(jTextField2); contentPane.add(jTextField1); contentPane.add(jTextField3); contentPane.add(jLabel4); contentPane.add(jLabel2); contentPane.add(jLabel3); contentPane.add(jButton2); contentPane.add(jButton1); contentPane.add(jButton3); contentPane.add(jOptionPane1); contentPane.add(jLabel1); } public void jButton3_actionPerformed(ActionEvent e) { System.exit(0); } public void jButton2_actionPerformed(ActionEvent e) { ShowFrame obj=new ShowFrame(); obj.setVisible(true); } public void jButton1_actionPerformed(ActionEvent e) { if(TxtHandler.IsNumeric(jTextField1.getText()) && TxtHandler.IsNumeric(jTextField2.getText()) && TxtHandler.IsNumeric(jTextField3.getText())){ int Txtclass_id = Integer.valueOf(jTextField1.getText()); int Txttotal = Integer.valueOf(jTextField2.getText()); int Txtpass = Integer.valueOf(jTextField3.getText()); float Txtratio=(float)Txtpass/Txttotal; if(Txtratio>1) jOptionPane1.showMessageDialog(this,"数据有错，请仔细检查！", "系统提示",JOptionPane.INFORMATION_MESSAGE); else{ DbConn dbc=new DbConn(); Connection conn=dbc.getConnection(); try{ PreparedStatement pstmt=conn.prepareStatement ("insert into passratio(class_id,total,pass,ratio) values(? , ? , ? , ? )"); pstmt.setInt(1, Txtclass_id); pstmt.setInt(2, Txttotal); pstmt.setInt(3, Txtpass); pstmt.setFloat(4 , Txtratio); pstmt.executeUpdate(); jOptionPane1.showMessageDialog(this, "添加成功！","系统提示", JOptionPane.INFORMATION_MESSAGE); }catch(SQLException ce){ jOptionPane1.showMessageDialog(this, "数据有错，请仔细检查！","系统提示", JOptionPane.INFORMATION_MESSAGE); } } }else jOptionPane1.showMessageDialog(this,"数据有错，请输入正确信息！", "系统提示",JOptionPane.INFORMATION_MESSAGE); } } class PassRatioFrame_jButton1_actionAdapter implements ActionListener { private PassRatioFrame adaptee; PassRatioFrame_jButton1_actionAdapter(PassRatioFrame adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton1_actionPerformed(e); } } class PassRatioFrame_jButton2_actionAdapter implements ActionListener { private PassRatioFrame adaptee; PassRatioFrame_jButton2_actionAdapter(PassRatioFrame adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton2_actionPerformed(e); } } class PassRatioFrame_jButton3_actionAdapter implements ActionListener { private PassRatioFrame adaptee; PassRatioFrame_jButton3_actionAdapter(PassRatioFrame adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton3_actionPerformed(e); } }