Java中实现增、删、改、查功能

一起学习

//添加操作
public void btnInsert_actionPerformed(ActionEvent e) {
String name = this.txtName.getText().trim();
String sex = this.txtSex.getText().trim();
String grade = this.txtGrade.getText().trim();
String score = this.txtScore.getText().trim();
if (name.equals("") || sex.equals("") || grade.equals("") ||
score.equals("")) {
JOptionPane.showMessageDialog(this, "您输入的不合法!");
}
String sqlString = "insert into Score values('" name "','" sex
"','" grade "','" score "')";
int rows = db.exeUpdate(sqlString);
if (rows == 0) {
JOptionPane.showMessageDialog(this, "添加失败！");
} else {
JOptionPane.showMessageDialog(this, " 添加成功！ ");
}
}

//删除操作
public void btnDelect_actionPerformed(ActionEvent e) {
String name = this.txtName.getText().trim();
if (name.equals("")) {
JOptionPane.showMessageDialog(this, "你输入的数据不完整");
return;
}
String sqlString = "delete from Score where Name='" name "'";
int rows = db.exeUpdate(sqlString);
if (rows == 0) {
JOptionPane.showMessageDialog(this, "删除失败");
return;
} else {
JOptionPane.showMessageDialog(this, "删除成功");
}
}

//查询操作
public void btnSelect_actionPerformed(ActionEvent e) {
String name = this.txtName.getText().trim();
if (name.equals("")) {
JOptionPane.showMessageDialog(this, "查找条件不完整");
return;
}
String sqlString = "select * from Score where name='" name "'";
Vector rs = db.exeQuery(sqlString);
if (rs.size() == 0) {
JOptionPane.showMessageDialog(this, "查找失败");

}
String Sex = ((Vector) rs.get(0)).get(2).toString();
String Grade = ((Vector) rs.get(0)).get(3).toString();
String Sore = ((Vector) rs.get(0)).get(4).toString();

this.txtSex.setText(Sex);
this.txtGrade.setText(Grade);
this.txtScore.setText(Sore);

}

//更新操作
public void btnUpdate_actionPerformed(ActionEvent e) {
String name = this.txtName.getText().trim();
String sex = this.txtSex.getText().trim();
String grade = this.txtGrade.getText().trim();
String score = this.txtScore.getText().trim();
if (name.equals("") || sex.equals("") || grade.equals("") ||
score.equals("")) {
JOptionPane.showMessageDialog(this, "您输入的数据不合法!!");
return;
}
String sqlString = "update Score set Sex='" sex "',Grade = '"
grade "',Score='" score "' where Name='"
name "'";
int rows = db.exeUpdate(sqlString);
if (rows == 0) {
JOptionPane.showMessageDialog(this, "更新失败!");
} else {
JOptionPane.showMessageDialog(this, "更新成功!");
}

}

下载本文示例代码


Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能Java中实现增、删、改、查功能