主题:如何写"更新"这一部分的代码?添加,删除,查询已经写好,高手请进
谁能写写"更新"这部分的代码,更新部分代码和"添加"很相似.
其中"添加"这部分代码为:
package SalarySystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JOptionPane;
import myClass.Worker;
import jdbcodbc.*;
public class AddFrame extends Frame implements ActionListener{
Button btnExit,btnOk;
Label lbID,lbName,lbSalary;
TextField txtID,txtName,txtSalary;
Worker worker;
/**
*
*/
public AddFrame(){
super("ADD Worker");
lbID=new Label("ID:");
lbName=new Label("Name:");
lbSalary=new Label("Salary:");
txtID=new TextField(10);
txtName=new TextField(10);
txtSalary=new TextField(10);
btnOk=new Button("OK");
btnExit=new Button("Exit");
btnOk.addActionListener(this);
btnExit.addActionListener(this);
this.setLayout(new GridLayout(4,2));
this.add(lbID); this.add(txtID);
this.add(lbName); this.add(txtName);
this.add(lbSalary);this.add(txtSalary);
this.add(btnOk);
this.add(btnExit);
this.pack();
this.setVisible(true);
}
public void insertToDatabase(Worker worker){
if(MyDBLink.joinDB()==true)
{String sqlString="insert into salary (worker_ID,worker_name,worker_salary) values('"+ worker.getID() +"','"+ worker.getName() +"',"+ worker.getSalary() +")";
if(MyDBLink.executeSQL(sqlString)==true){
new JOptionPane().showMessageDialog(null,"ADD Success!");
}
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==btnExit){
this.dispose();
}
if(e.getSource()==btnOk){
worker=new Worker(txtID.getText(),txtName.getText(),Integer.parseInt(txtSalary.getText()));
insertToDatabase(worker);
txtID.setText("");
txtName.setText("");
txtSalary.setText("");
}
}
}
其中"添加"这部分代码为:
package SalarySystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JOptionPane;
import myClass.Worker;
import jdbcodbc.*;
public class AddFrame extends Frame implements ActionListener{
Button btnExit,btnOk;
Label lbID,lbName,lbSalary;
TextField txtID,txtName,txtSalary;
Worker worker;
/**
*
*/
public AddFrame(){
super("ADD Worker");
lbID=new Label("ID:");
lbName=new Label("Name:");
lbSalary=new Label("Salary:");
txtID=new TextField(10);
txtName=new TextField(10);
txtSalary=new TextField(10);
btnOk=new Button("OK");
btnExit=new Button("Exit");
btnOk.addActionListener(this);
btnExit.addActionListener(this);
this.setLayout(new GridLayout(4,2));
this.add(lbID); this.add(txtID);
this.add(lbName); this.add(txtName);
this.add(lbSalary);this.add(txtSalary);
this.add(btnOk);
this.add(btnExit);
this.pack();
this.setVisible(true);
}
public void insertToDatabase(Worker worker){
if(MyDBLink.joinDB()==true)
{String sqlString="insert into salary (worker_ID,worker_name,worker_salary) values('"+ worker.getID() +"','"+ worker.getName() +"',"+ worker.getSalary() +")";
if(MyDBLink.executeSQL(sqlString)==true){
new JOptionPane().showMessageDialog(null,"ADD Success!");
}
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==btnExit){
this.dispose();
}
if(e.getSource()==btnOk){
worker=new Worker(txtID.getText(),txtName.getText(),Integer.parseInt(txtSalary.getText()));
insertToDatabase(worker);
txtID.setText("");
txtName.setText("");
txtSalary.setText("");
}
}
}