DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("com.oceanbase.jdbc.Driver");
dataSource.setUrl("jdbc:oceanbase://ip:port/utmgr");
dataSource.setUsername("");
dataSource.setPassword("");
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
String[] returnGeneratedKeys = new String[]{"ID"};
KeyHolder keyHolder = new GeneratedKeyHolder();
String sql = "INSERT INTO CONFIG_INFO(DATA_ID, GROUP_ID, TENANT_ID, APP_NAME, CONTENT, MD5, SRC_IP, SRC_USER, GMT_CREATE, GMT_MODIFIED, C_DESC, C_USE, EFFECT, TYPE, C_SCHEMA, ENCRYPTED_DATA_KEY) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
jdbcTemplate.update(new PreparedStatementCreator() {
@Override
public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement(sql, returnGeneratedKeys);
ps.setString(1, "1");
ps.setString(2, "1");
ps.setString(3, "1");
ps.setString(4, "1");
ps.setString(5, "server: port");
ps.setString(6, "80cb8b9f94b1bce6011374ac2dee5e75");
ps.setString(7, "1");
ps.setString(8, "1");
ps.setTimestamp(9, Timestamp.valueOf("2023-11-23 10:09:21"));
ps.setTimestamp(10, Timestamp.valueOf("2023-11-23 10:09:25"));
ps.setString(11, "e");
ps.setString(12, "e");
ps.setString(13, "e");
ps.setString(14, "e");
ps.setString(15, "e");
ps.setString(16, "e");
return ps;
}
}, keyHolder);
Number nu = keyHolder.getKey();
if (nu == null) {
throw new IllegalArgumentException("insert fail");
}
System.out.println(nu);
} catch (CannotGetJdbcConnectionException e) {
throw e;
}
CREATE TABLE "UTMGR"."CONFIG_INFO" (
"ID" NUMBER(20) DEFAULT "SEQ_ID"."NEXTVAL",
"DATA_ID" VARCHAR2(255) CONSTRAINT "CONFIG_INFO_OBNOTNULL_1700665028701610" NOT NULL ENABLE,
"GROUP_ID" VARCHAR2(128),
"CONTENT" CLOB CONSTRAINT "CONFIG_INFO_OBNOTNULL_1700665028701747" NOT NULL ENABLE,
"MD5" VARCHAR2(32),
"GMT_CREATE" DATE DEFAULT sysdate CONSTRAINT "CONFIG_INFO_OBNOTNULL_1700665028701776" NOT NULL ENABLE,
"GMT_MODIFIED" DATE DEFAULT sysdate CONSTRAINT "CONFIG_INFO_OBNOTNULL_1700665028702024" NOT NULL ENABLE,
"SRC_USER" CLOB,
"SRC_IP" VARCHAR2(50),
"APP_NAME" VARCHAR2(128),
"TENANT_ID" VARCHAR2(128) DEFAULT '',
"C_DESC" VARCHAR2(256),
"C_USE" VARCHAR2(64),
"EFFECT" VARCHAR2(64),
"TYPE" VARCHAR2(64),
"C_SCHEMA" CLOB,
"ENCRYPTED_DATA_KEY" CLOB,
CONSTRAINT "CONFIG_INFO_OBPK_1700665028701578" PRIMARY KEY ("ID")
)
CREATE SEQUENCE "SEQ_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE NOORDER NOCYCLE;