一个简单的学生成绩系统

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(""); } } }