<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*"%>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<%
String userName = "pcm";
String userPasswd = "123456";
String dbName = "Meng";
String tableName = "meng_contents";
String url = "jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();
try{
    Connection connection=DriverManager.getConnection(url);
    Statement statement = connection.createStatement();
    String sql="SELECT * FROM "+tableName;
    ResultSet rs = statement.executeQuery(sql); //获得数据结果集合

    ResultSetMetaData rmeta = rs.getMetaData(); //确定数据集的列数，亦字段数

    int numColumns=rmeta.getColumnCount(); // 输出每一个数据值


    out.print("id");
    out.print("|");
    out.print("xxx");
    out.print("<br>");

    /* 打印查询结果 */
    while(rs.next()) {
     out.print(rs.getString(1)+" ");
     out.print("|");
     out.print(rs.getString(2));
     out.print("<br>");
    }

    out.print("<br>");
    out.print("数据库操作成功");
    rs.close();
    statement.close();
    connection.close();
} catch (Exception e){
    out.println(e.toString());
}
%>