1.在navicat中进行表的设计的时候,可以直接勾选
2.插入数据
INSERT INTO TABLE_DATA_TEST_ITEMS values(ID, ?, 0, null, null, null, 1, ?, ?);
3.插入之后获取到自增ID
//针对上面的SQL进行插入
PreparedStatement pst;
pst = conn.prepareStatement(sql);
pst.setString(1,strFolderName);
pst.setInt(2, parentNode.getID());
pst.setString(3, strOracleVersion);
pst.executeUpdate();
//插入之后直接调用函数getGeneratedKeys获取结果集
ResultSet rs = pst.getGeneratedKeys();
if(rs.next()) {
nNodeID = rs.getInt(1);
}
参考博客:
https://www.cnblogs.com/51python/p/11443602.html
https://blog.csdn.net/weixin_31225753/article/details/113324387