方一:预处理
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>成语数据库中的20条记录</h1>
<%
String url="jdbc:mysql://localhost:3306/db?serverTimezone=PRC";
Class.forName("com.mysql.cj.jdbc.Driver");
Connection cn = DriverManager.getConnection(url,"root","12qwas");
PreparedStatement ps = cn.prepareStatement("select * from chengyu limit ?,?");
ps.setInt(1, 200);
ps.setInt(2, 20);
ResultSet rs = ps.executeQuery();
while(rs.next()){
String cy=rs.getString("cy");
out.println("<p>"+cy+"</p>");
}
rs.close();
ps.close();
cn.close();
%>
</body>
</html>
方二:
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: 夏之家
Date: 2022/11/3
Time: 17:19
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JDBC访问Mysql数据库</title>
</head>
<body>
<div>
<h2>的JDBC访问Mysql数据库</h2>
<%
String url = "jdbc:mysql://localhost:3306/jsp_test?serverTimezone=PRC";
Class.forName("com.mysql.cj.jdbc.Driver");
Connection cn = DriverManager.getConnection(url, "root", "root");
Statement stmt = cn.createStatement();
ResultSet rs = stmt.executeQuery("select * from stuinfo");
while (rs.next()) {
out.println("<tr>");
out.println("<td>" + rs.getString("Sno") + "</td>");
out.println("<td>" + rs.getString("Sname") + "</td>");
out.println("<td>" + rs.getString("Ssex") + "</td>");
out.println("<td>" + rs.getString("Sage") + "</td>");
out.println("<td>" + rs.getString("Sdept") + "</td>");
out.println("</tr>");
}
rs.close();
stmt.close();
cn.close();
%>
</div>
</body>
</html>