换个姿势访问openGauss？（24）使用编程语言访问

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/

SELECT操作

说明： 请先完成创建表和插入操作。

• 使用prepareStatement执行查询操作可以使用预编译，动态的添加参数也可以执行普通的SQL语句。

  ini复制代码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;
          }
      }
  

• 使用Statement执行查询语句。

  ini复制代码 public static void main(String[] args) throws SQLException {
          Connection conn = getConnect();
          Statement statement = conn.createStatement();
          ResultSet resultSet=statement.executeQuery("select * from test");
          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;
          }
      }
  

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/