我非常初学者,我从事自己的项目,我必须为所有学校科目添加一个id。但是我希望这些ID显示在屏幕上,并且不想看到:1,101,201,301。
try {
ResultSet rs = dbmd.getTables(null, "APP", "SUBJECTROWS", null);
if (!rs.next()) {
createStatement.execute("create table subjectrows(id INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,"
+ "col1 varchar(20), col2 varchar(20))");
}
} catch (...
您可以尝试在语句中添加以下内容Id INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)