如何使用 Java 中的 JDBC 连接更新(删除、插入或更新)表的内容
问题描述
如何使用 JDBC 连接更新(删除、插入或更新)表的内容?
解决方案
以下方法使用更新、删除和插入 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); } } }
结果
上述代码示例将产生以下结果。结果可能会有所不同。
id name job 2 ravi trainee 1 ronak manager
java_jdbc.html