MySQL 查找指定表名的表的主键

梁云亮

于 2025-05-01 21:41:35 发布

阅读量387

点赞数 2

分类专栏： # MySQL / MariaDB JDBC 文章标签： mysql 获取表的主键

本文链接：https://blog.csdn.net/lianghecai52171314/article/details/147655923

版权

MySQL / MariaDB 同时被 2 个专栏收录

54 篇文章

订阅专栏

JDBC

16 篇文章

订阅专栏

原理

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
WHERE TABLE_NAME = 表名 AND CONSTRAINT_NAME = 'PRIMARY'

方法

public static String getPk(String tableName) {
    String sql = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = ? AND CONSTRAINT_NAME = 'PRIMARY'";
    PreparedStatement ps = null;
    ResultSet rs = null;
    String res = null;
    try {
        final Connection conn = JdbcUtil.getConnection();
        ps = conn.prepareStatement(sql);
        ps.setString(1, tableName);
        rs = ps.executeQuery();
        if (rs.next()) {
            res = rs.getString("COLUMN_NAME");
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        JdbcUtil.release(ps, rs);
    }
    return res;
}