-
使用PreparedStatement执行更新操作,然后执行查询语句判断更新是否成功。
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; public class JdbcConn { public static void main(String[] args) throws SQLException { Connection conn = getConnect(); Statement statement = conn.createStatement(); PreparedStatement preparedStatement=conn.prepareStatement("update test set name='wangwu' where id=1"); preparedStatement.execute(); preparedStatement=conn.prepareStatement("select * from test;"); ResultSet resultSet=preparedStatement.executeQuery(); while (resultSet.next()){ System.out.println(resultSet.getObject("id")+" "+ resultSet.getObject("name")); } conn.close(); } public static Connection getConnect() { String driver = "org.opengauss.Driver"; String sourceURL = "jdbc:opengauss://127.0.0.1:8080/test?user=myuser&password=myPassWord"; Properties info = new Properties(); Connection conn = null; try { Class.forName(driver); } catch (Exception var9) { var9.printStackTrace(); return null; } try { conn = DriverManager.getConnection(sourceURL); System.out.println("连接成功!"); return conn; } catch (Exception var8) { var8.printStackTrace(); return null; } } }
01-01
2025
02-07
1412