获取MySql表结构

import java.sql.*;

public class testMySql {

	public static void main(String[] args) {
		String driver = "com.mysql.jdbc.Driver";
		String userName = "cloud";
		String userPasswd = "bigbig";
		String database = "webmon_test";
		String jdbc = "jdbc:mysql//10.1.1.26:3306/" + database;
		try {
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(jdbc, userName,
					userPasswd);
			if(!conn.isClosed()){
				Statement state=conn.createStatement();
				String tableName="test";  //
				String sql="Select * from "+tableName;
				ResultSet rs=state.executeQuery(sql);
				ResultSetMetaData rsmd=rs.getMetaData();
				
				int column=rsmd.getColumnCount(); //获取列数
				
				//注意：这个for循环中，下标是从i=1开始，如果从0开始，则会报错（貌似是Index……）
				for(int i=1;i<=column;i++){
					System.out.println(rsmd.getColumnTypeName(column));
				}
				
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}