JAVA与mysql动态字段查询_Java查询MySQL数据库的字段及类型

Java查询MySQL数据库的字段及类型

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

import java.util.Hashtable;

public class GetDBFiled {

public static void conn() {

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

String url = "jdbc:mysql://localhost:3306/databaseName";

String user = "root";

String password = "密码";

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, user, password);

if (!conn.isClosed()) {

String sql = "select * from pic";

System.out.println("Succeeded connecting to the Database!");

Statement statement =conn.createStatement();

ResultSet rs = statement.executeQuery(sql);

if (rs.next()) {

// 得到ResultSetMetaData

ResultSetMetaData rsmd = rs.getMetaData();

System.out.println(rsmd.getColumnCount());

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

Hashtable hst = new Hashtable();

// 把字段名放入Name

String name = String.valueOf(rsmd.getColumnLabel(i));

hst.put("Name", name);

// 把字段类型放入Type

String type = String.valueOf(rsmd.getColumnType(i));

hst.put("Type", type);

System.out.println(hst.get("Name")+" "+hst.get("Type"));

}

}

}

} catch (Exception e) {

System.out.println("出现异常");

}

}

}

分享到：

2010-07-15 13:05

浏览 2823

评论