Java连接MySQL数据库后,我们可以将数据库中的数据传递给HTML页面进行展示。下面是一个简单的示例:
import java.sql.*;import java.io.*;import javax.servlet.*;import javax.servlet.http.*;public class ExampleServlet extends HttpServlet {protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {res.setContentType("text/html");PrintWriter out = res.getWriter();String dbUrl = "jdbc:mysql://localhost:3306/mydb";String dbUser = "root";String dbPass = "password";try {Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPass);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");out.println("");out.println("
" + rs.getString("col1") + " - " + rs.getString("col2") + "
");}out.println("");rs.close();stmt.close();conn.close();}catch(Exception e) {e.printStackTrace();}finally {out.close();}}}上面的代码会取出MySQL中mydb库中的mytable表中的所有数据,并将每行数据的col1和col2作为一段HTML显示在页面上。