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>
