oceanbase jdbc连接

import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.sql.ResultSet;
    import java.sql.Statement;

    public class oceanbaseTest {
        public static void main(String[] args) {
            try {

                Class.forName("com.oceanbase.jdbc.Driver");
                Connection connection = DriverManager.getConnection("jdbc:oceanbase://xxx:xxx/username?&user=username@database#cluster&password=xxxxx");
                
                System.out.println(connection.getAutoCommit());
                Statement sm = connection.createStatement();
                //新建表 t_meta_form
                sm.executeUpdate("CREATE TABLE t_meta_form (name varchar(36) , id int)");
                //插入数据
                sm.executeUpdate("insert into t_meta_form values ('an','1')");
                //查询数据，并输出结果
                ResultSet rs = sm.executeQuery("select * from t_meta_form");
                while (rs.next()) {
                    String name = rs.getString("name");
                    String id = rs.getString("id");
                    System.out.println(name + ','+ id);
                }
                //删除表
                sm.executeUpdate("drop table t_meta_form");
            }catch (SQLException ex) {
                System.out.println("error!");
                ex.printStackTrace() ;
            }catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
        }
    }

 

<!-- OceanBase JDBC 驱动依赖 --> 
    <dependency>
        <groupId>com.oceanbase</groupId>
        <artifactId>oceanbase-client</artifactId>
        <version>2.4.7.1</version>
    </dependency>

 

翻译

搜索

复制