package scoreSystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JOptionPane;
import myClass.*;
import dbLink.*;
public class AddFrame extends Frame implements ActionListener{
Button btnExit,btnOk;
Label lbID,lbName,lbPingshiScore,lbKaoshiScore;
TextField txtID,txtName,txtPingshiScore,txtKaoshiScore;
Student student;
/**
*
*/
public AddFrame(){
super("添加学生");
this.getLevs();
lbID=new Label("编号:");
lbName=new Label("姓名:");
lbPingshiScore=new Label("平时:");
lbKaoshiScore=new Label("考试:");
txtID=new TextField(10);
txtName=new TextField(10);
txtPingshiScore=new TextField(10);
txtKaoshiScore=new TextField(10);
btnOk=new Button("确定");
btnExit=new Button("退出");
btnOk.addActionListener(this);
btnExit.addActionListener(this);
this.setLayout(new GridLayout(5,2));
this.add(lbID); this.add(txtID);
this.add(lbName); this.add(txtName);
this.add(lbPingshiScore);this.add(txtPingshiScore);
this.add(lbKaoshiScore);this.add(txtKaoshiScore);
this.add(btnOk);
this.add(btnExit);
this.pack();
this.setSize(300, 200);
this.show();
}
public void getLevs(){
if(MySqlLink.joinDB()==true){
String sqlString="select * from levs";
MySqlLink.query(sqlString);
try{while(MySqlLink.rs.next()){
Student.kaoShiLev=MySqlLink.rs.getDouble(1);
Student.pingShiLev=MySqlLink.rs.getDouble(2);
String temp="考试占"+Student.kaoShiLev*100+"%"+"平时占"+Student.pingShiLev*100+"%"+"[可以在系统设置中更改]";
new JOptionPane().showMessageDialog(null,temp);
}
}catch(Exception ex){
System.out.println(ex);
}
}
}
public void insertToDatabase(Student student){
String sqlString="insert into stuinfo(id,name,pingshi,kaoshi,score) values('"+ student.getID() +"','"+ student.getName() +"',"+ student.getPingShiScore() +","+ student.getKaoShiScore() +","+ student.getScore() +")";
if(MySqlLink.executeSQL(sqlString)==true){
new JOptionPane().showMessageDialog(null,"添加成功!");
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==btnExit){
this.dispose();
}
if(e.getSource()==btnOk){
student=new Student();
student.setID(txtID.getText());
student.setName(txtName.getText());
student.setPingShiScore(Integer.parseInt(txtPingshiScore.getText()));
student.setKaoShiScore(Integer.parseInt(txtKaoshiScore.getText()));
student.setScore();
insertToDatabase(student);
txtID.setText("");txtName.setText("");txtPingshiScore.setText("");txtKaoshiScore.setText("");
}
}
}
StudentScoreSystem.rar （16个子文件） 
StudentScoreSystem 
.project 394B bin scoreSystem SettingFrame.class 3KB AddFrame.class 4KB QueryFrame.class 3KB TestSystem.class 439B MainFrame.class 2KB dbLink MySqlLink.class 2KB myClass Student.class 2KB src scoreSystem MainFrame.java 1KB AddFrame.java 3KB SettingFrame.java 2KB QueryFrame.java 2KB TestSystem.java 156B dbLink MySqlLink.java 2KB myClass Student.java 1KB .classpath 294B资源评论
