java连接mysql传值给html

更新时间:02-09 教程 由 迷糊 分享

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("MySQL Data");out.println("");while(rs.next()) {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显示在页面上。

声明:关于《java连接mysql传值给html》以上内容仅供参考,若您的权利被侵害,请联系13825271@qq.com
本文网址:http://www.25820.com/tutorial/14_2073967.html