如何更新,编辑和删除行?(How to update, edit & delete rows ?)
优质
小牛编辑
125浏览
2023-12-01
问题描述 (Problem Description)
如何使用JDBC连接更新(删除,插入或更新)表的内容?
解决方案 (Solution)
以下方法使用update,delete和insert SQL命令来编辑或删除行内容。
import java.sql.*;
public class updateTable {
public static void main(String[] args) {
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
} catch(ClassNotFoundException e) {
System.out.println("Class not found "+ e);
}
try {
Connection con = DriverManager.getConnection (
"jdbc:derby://localhost:1527/testDb","username", "password");
Statement stmt = con.createStatement();
String query1 = "update emp set name = 'ravi' where id = 2";
String query2 = "delete from emp where id = 1";
String query3 = "insert into emp values (1,'ronak','manager')";
stmt.execute(query1);
stmt.execute(query2);
stmt.execute(query3);
ResultSet rs = stmt.executeQuery("SELECT * FROM emp");
System.out.println("id name job");
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
String job = rs.getString("job");
System.out.println(id+" "+name+" "+job);
}
} catch(SQLException e) {
System.out.println("SQL exception occured" + e);
}
}
}
结果 (Result)
上面的代码示例将产生以下结果。 结果可能会有所不同。
id name job
2 ravi trainee
1 ronak manager