废话不多说、上代码

import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class AnalysisDatabaseStructureServlet extends HttpServlet {    private static final long serialVersionUID = 1L;    Connection conn = null;    Statement st = null;    public AnalysisDatabaseStructureServlet() {        super();    }    //获取conn    public void init() throws ServletException {        try {            Class.forName("com.mysql.jdbc.Driver").newInstance();            conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/base", "root", "root");        } catch (InstantiationException e) {            e.printStackTrace();        } catch (IllegalAccessException e) {            e.printStackTrace();        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }    }        public void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        // 1、获取数据库所有表        StringBuffer sbTables = new StringBuffer();        List
     
       tables = new ArrayList
      
       ();        sbTables.append("-------------- 数据库中有下列的表 ----------
       
");        try {            DatabaseMetaData dbMetaData = conn.getMetaData();            ResultSet rs = dbMetaData.getTables(null, null, null,new String[] { "TABLE" });            while (rs.next()) {
   // ///TABLE_TYPE/REMARKS                sbTables.append("表名：" + rs.getString("TABLE_NAME") + "
       
");                sbTables.append("表类型：" + rs.getString("TABLE_TYPE") + "
       
");                sbTables.append("表所属数据库：" + rs.getString("TABLE_CAT") + "
       
");                sbTables.append("表所属用户名：" + rs.getString("TABLE_SCHEM")+ "
       
");                sbTables.append("表备注：" + rs.getString("REMARKS") + "
       
");                sbTables.append("------------------------------
       
");                tables.add(rs.getString("TABLE_NAME"));            }        } catch (SQLException e) {            e.printStackTrace();        }        // 2、遍历数据库表，获取各表的字段等信息        StringBuffer sbCloumns = new StringBuffer();        for (String tableName : tables) {            String sql = "select * from " + tableName;            try {                PreparedStatement ps = conn.prepareStatement(sql);                ResultSet rs = ps.executeQuery();                ResultSetMetaData meta = rs.getMetaData();                int columeCount = meta.getColumnCount();                sbCloumns.append("表 "+ tableName + "共有 "+columeCount+" 个字段。字段信息如下：
       
");                for (int i = 1; i < columeCount + 1; i++) {                    sbCloumns.append("字段名："+meta.getColumnName(i)+"
       
");                    sbCloumns.append("类型："+meta.getColumnType(i)+"
       
");                    sbCloumns.append("------------------------------
       
");                }            } catch (SQLException e) {                e.printStackTrace();            }            sbCloumns.append("------------------------------
       
");        }        response.setContentType("text/html");        PrintWriter out = response.getWriter();        out.println("");        out.println("");        out.println("  
       ");        out.println("  ");        out.println("" + sbTables.toString());        out.println("" + sbCloumns.toString());        out.println("  ");        out.println("");        out.flush();        out.close();    }    public void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        this.doGet(request, response);    }        //释放conn    public void destroy() {        super.destroy();        if (conn != null) {            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }        }    }}