JDBC DB TableName

获取表结构.

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();
    }

}