jdbc mysql 表结构_使用JDBC connect获取数据库表结构信息

1、这是生成代码的关键

引入maven依赖

mysql

mysql-connector-java

5.1.30

2、编写JAVA类

package com.yyj.mybties.jdbc;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

/**

* 获取数据库中表的结构

*/

public class JDBCdemo {

public static void main(String[] args) {

String driver = "com.mysql.jdbc.Driver";

String URL = "jdbc:mysql://localhost:3306/mybase";

Connection con = null;

List tableNames = new ArrayList();

try {

con= DriverManager.getConnection(URL,"root","");

getTableInfo(con,"users");

} catch(Exception e) {

System.out.println("Connect fail:" + e.getMessage());

}

}

private static void getTableInfo(Connection con,String tableName) throws SQLException {

DatabaseMetaData metaData = con.getMetaData();

ResultSet colRet = metaData.getColumns(null, "%", tableName, "%");

String columnName;

String columnType;

while(colRet.next()){

columnName = colRet.getString("COLUMN_NAME");

columnType = 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+" "+columnType+" "+datasize+" "+digits+" "+ nullable);

}

System.out.println("\n");

}

}

执行结果