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

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

创建表

• 通过statement执行创表操作。

  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();
          statement.execute("create table test_table (id int,name varchar (10))");
      }
      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;
          }
      }
  }
  

• 通过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();
          PreparedStatement preparedStatement=conn.prepareStatement("create table test (id int,name varchar (10))");
          preparedStatement.execute();
      }
      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 #入门 #安装 #数据库