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(132, 43, 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(jLabel1);
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);
}
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);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
JAVA复习资料_机试.rar (58个子文件)
ACCP4.0复习资料_机试
连接数据库的方法.doc 166KB
4-用户信息查找
userinfor
userinfor.jpx 4KB
bak
userinfor
src
userinfor
UserApplication.java 2KB
GetInfoFrm.java 4KB
DBGet.java 2KB
userinfor.jpx.local 3KB
JavaForSql.library 478B
classes
userinfor
UserApplication$1.class 814B
UserApplication.class 1KB
GetInfoFrm_jbtSelect_actionAdapter.class 694B
GetInfoFrm.class 3KB
DBGet.class 2KB
package cache
userinfor.dep2 7KB
1-考试通过率统计
SimpleGame.jpx 4KB
SimpleGame.jpx.local 2KB
bak
simplegame
src
simplegame
SimpleGameFrame.java 5KB
SimpleGameClass.java 2KB
SQL_Server_pubs.sql 808B
classes
simplegame
SimpleGameClass.class 1KB
SimpleGameFrame_jButton2_actionAdapter.class 726B
SimpleGameClass$1.class 817B
SimpleGameFrame_jButton1_actionAdapter.class 726B
SimpleGameFrame.class 4KB
package cache
simplegame.dep2 7KB
2-数字小游戏
PassRatio
PassRatio.jpx 4KB
bak
passratio
src
passratio
DbConn.java 614B
TxtHandler.java 295B
PassRatioFrame.java 6KB
ShowFrame.java 4KB
PassRatio.java 2KB
DbConn.jbx 95B
classes
package cache
passratio.dep2 13KB
passratio
ShowFrame_jButton2_actionAdapter.class 685B
PassRatio.class 1KB
ShowFrame_jButton1_actionAdapter.class 685B
PassRatioFrame_jButton1_actionAdapter.class 715B
PassRatioFrame_jButton3_actionAdapter.class 715B
ShowFrame.class 4KB
PassRatioFrame.class 5KB
PassRatio$1.class 790B
DbConn.class 1012B
TxtHandler.class 589B
PassRatioFrame_jButton2_actionAdapter.class 715B
PassRatio.jpx.local 3KB
3-4-DataBase
JAVATest_Data.MDF 1024KB
JAVATest_Log.LDF 1024KB
3-修改用户密码
RePasswrod
RePasswrod.jpx 4KB
bak
repasswrod
src
repasswrod
newpassApplication.java 2KB
newpassFrame.java 5KB
DBOperate.java 3KB
RePasswrod.jpx.local 2KB
classes
package cache
repasswrod.dep2 7KB
repasswrod
newpassFrame.class 4KB
newpassApplication.class 1KB
about.png 423B
newpassApplication$1.class 829B
newpassFrame_REButton_actionAdapter.class 708B
DBOperate.class 3KB
共 58 条
- 1
bingchunliu
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0