JDBC DB TableName

来源：互联网发布：mac怎么玩穿越火线编辑：程序博客网时间：2024/05/22 15:41

获取表结构.

Java代码

package com.pear.db;
import java.sql.*;
/**
* Created with IntelliJ IDEA.
* User: pear
* Date: 12-11-13
* Time: 上午11:09
* To change this template use File | Settings | File Templates.
*/
public class DB {
public static void main(String args[]) throws Exception {
System.out.println("************************************************");
String sql = "select * from common_mail_config";
Class.forName("com.mysql.jdbc.Driver");
DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/emp","root", "root");
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet resultSet = ps.executeQuery();
ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
int totalColumn = resultSetMetaData.getColumnCount();
for (int i = 1; i <= totalColumn; i++) {
System.out.print(resultSetMetaData.getColumnLabel(i));
System.out.print("|");
}
System.out.println();
while (resultSet.next()) {
for (int i = 1; i <= totalColumn; i++) {
System.out.print(resultSet.getObject(i));
System.out.print("|");
}
System.out.println();
}
System.out.println("************************************************");
resultSet.close();
ps.close();
conn.close();
}
}