JSTL：SQL

<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
-------------------------------------------------------------------------------------
 
<sql:setDataSource var="db" driver="com.mysql.cj.jdbc.Driver"
     url="jdbc:mysql://localhost:3306/my_db?useUnicode=true&characterEncoding=utf-8"
     user="root"  password="1234"/>
<%-- ?serverTimezone=UTC --%>
-------------------------------------------------------------------------------------
 
<sql:query dataSource="${db}" var="rs">
SELECT * from city where countrycode='AUS';
</sql:query>
 
<table>
<c:forEach var="row" items="${rs.rows}">
<tr>
   <td><c:out value="${row.name}"/></td>
   <td><c:out value="${row.district}"/></td>
   <td><c:out value="${row.population}"/></td>
</tr>
</c:forEach>
</table>
-------------------------------------------------------------------------------------
 <%--
<sql:update dataSource="${db}" var="result">
INSERT INTO websites (name,url,alexa,country) VALUES ('111',  111, 111, '111');
</sql:update>

-------------------------------------------------------------------------------------

 
<c:set var="aa" value="3"/>

<sql:update dataSource="${db}" var="count">
  DELETE FROM websites WHERE Id = ?
  <sql:param value="${aa}" />
</sql:update>
-------------------------------------------------------------------------------------

 

<c:set var="SiteId" value="3"/>
<sql:update dataSource="${db}" var="count">
  UPDATE websites SET name = 'RUNOOB' WHERE Id = ?
  <sql:param value="${SiteId}" />
</sql:update>
 --%>