使用JDBC获取MySQL表结构代码如下:
1. 使用JDBC获取MySQL表结构
代码如下:
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名", "用户名", "密码");
//获取数据库元数据
DatabaseMetaData metaData = conn.getMetaData();
//获取表结构
ResultSet rs = metaData.getTables(null, null, "表名", new String[] { "TABLE" });
while (rs.next()) {
//获取表名
String tableName = rs.getString("TABLE_NAME");
//获取列名
ResultSet colRet = metaData.getColumns(null, "%", tableName, "%");
while (colRet.next()) {
String columnName = colRet.getString("COLUMN_NAME");
String dataType = colRet.getString("TYPE_NAME");
int datasize = colRet.getInt("COLUMN_SIZE");
int digits = colRet.getInt("DECIMAL_DIGITS");
int nullable = colRet.getInt("NULLABLE");
System.out.println(columnName + " " + dataType + " " + datasize + " " + digits + " " + nullable);
}
}
//关闭连接
conn.close();
本站系公益性非盈利分享网址,本文来自用户投稿,不代表码文网立场,如若转载,请注明出处
评论列表(37条)