在java中更新sqlite\u序列表

68de4m5k 于 2021-08-01 发布在 Java

关注(0)|答案(1)|浏览(328)

我在java中使用sqlite jdbc，我生成了一个sqlite表（在java中），我想给autoincrement一个自定义值，以4521开头，但我不知道如何在java中实现，我知道我必须改变 SQLITE_SEQUENCE 但我不知道如何在java中实现它。这是我的java代码：）请帮我谢谢。

private static void hasDatabase() throws ClassNotFoundException,
        SQLException {
    // TODO Auto-generated method stub
    Connection myConn = null;
    Statement myStmt = null;
    Statement mystmtTwo = null;
    Class.forName("org.sqlite.JDBC");
    myConn = DriverManager.getConnection("jdbc:sqlite:mylibrary.db");
    myStmt = myConn.createStatement();
    myStmt.execute("CREATE TABLE mymembers ( idmymembers    INTEGER      PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,"
            + "membername     VARCHAR (45) NOT NULL,"
            + "memberlastname VARCHAR (45) NOT NULL,"
            + "memberage      INT (11)     NOT NULL,"
            + "membergender   VARCHAR (45) NOT NULL);");    
    mystmtTwo = myConn.createStatement();
    mystmtTwo.execute("UPDATE SQLITE_SEQUENCE SET seq = 98111 WHERE name = 'mymembers';");
}

Java sql sqlite

来源：https://stackoverflow.com/questions/62674158/update-the-sqlite-sequence-table-in-java

1条答案

按热度按时间

hivapdat1#

如果你需要设置 autoincrement 空表上的序列 insert 将此值转换为 sqlite_sequence ，不是 update .
考虑以下示例（jcabi jdbc用于处理查询）：

final JdbcSession session = new JdbcSession(src);
session
    .sql("CREATE TABLE members(id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL)")
    .execute();
session
    .sql("INSERT INTO sqlite_sequence values(?,?)")
    .set("members")
    .set(123)
    .insert(Outcome.VOID);
session
    .sql("INSERT INTO members values(null)")
    .execute();
session
    .sql("INSERT INTO members values(null)")
    .execute();
final List<Integer> values = session
    .sql("SELECT id FROM members")
    .select(new ListOutcome<>(rset -> rset.getInt("id")));
MatcherAssert.assertThat(
    values,
    Matchers.equalTo(Arrays.asList(124, 125))
);

展开查看全部

赞(0）回复(0）举报 2021-08-01

我来回答

在java中更新sqlite\u序列表

1条答案

相关问题

热门标签

最新问答