//获取表中自增长的列,如果没有返回为 null
public static String getSinceColumn(Connection con, String table){
String sinceColumn = null;
try {
String sql = "Select so.name Table_name,sc.name Iden_Column_name,ident_current(so.name) curr_value, "
+ "ident_incr(so.name) incr_value, "
+ "ident_seed(so.name) seed_value "
+ "from sysobjects so Inner Join syscolumns sc on so.id = sc.id "
+ "and columnproperty(sc.id, sc.name, 'IsIdentity') = 1 "
+ "Where upper(so.name) = upper('"+ table +"') ";
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()){
sinceColumn = rs.getString(2);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return sinceColumn;
}
获取表中自增长的列
最新推荐文章于 2024-09-24 11:03:03 发布