-
使用prepareStatement执行查询操作可以使用预编译,动态的添加参数也可以执行普通的SQL语句。
public static void main(String[] args) throws SQLException { Connection conn = getConnect(); PreparedStatement preparedStatement=conn.prepareStatement("select * from test where id=?;"); preparedStatement.setObject(1,1); 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; } }