public class MysqlTest {
private static final Logger logger= LoggerFactory.getLogger(MysqlTest.class);
public void getTabs() throws Exception{
//所有表
String sql="show TABLES";
List<String> list= DbTools.getList(sql);
if(list!=null&&!list.isEmpty()){
for(String t: list){
String sql2=" SELECT k.column_name" +
" FROM information_schema.table_constraints t " +
" JOIN information_schema.key_column_usage k " +
" USING (constraint_name,table_schema,table_name) " +
" WHERE t.constraint_type='PRIMARY KEY' " +
" AND t.table_schema='dbname' " +//数据库名
" AND t.table_name=? "; //表名
String result=DbTools.getStringValue(sql2,DbTools.makeParams(t));
System.out.println("table name:"+t+"\t"+",主键ID:"+result);
}
}
}
public static void main(String[] args) throws Exception{
new MysqlTest().getTabs();
}
}
java打印一个数据库的所有表的主键
最新推荐文章于 2021-11-14 16:56:30 发布