java遍历mysql表_[Java] Java 获取数据库所有表基本信息和表中的所有列基本信息代码...

importjava.io.IOException;importjava.io.PrintWriter;importjava.sql.Connection;importjava.sql.DatabaseMetaData;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;public class AnalysisDatabaseStructureServlet extendsHttpServlet {private static final long serialVersionUID = 1L;

Connection conn= null;

Statement st= null;publicAnalysisDatabaseStructureServlet() {super();

}//获取conn

public void init() throwsServletException {try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/base", "root