<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" %>
<%@ 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" %>
<html>
<head>
<title>SELECT 操作</title>
</head>
<body>
<!--
JDBC 驱动名及数据库 URL
数据库的用户名与密码，需要根据自己的设置
useUnicode=true&characterEncoding=utf-8 防止中文乱码
-->
<sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://test1498384.com:3306/test1498384_db?useUnicode=true&characterEncoding=utf-8"
user="test1498384" password="passwd"/>
<sql:query dataSource="${snapshot}" var="result">
select max(case option_name when 'blogname' then option_value end) blogname,
max(case option_name when 'blogdescription' then option_value end) blogdescription,
max(case option_name when 'siteurl' then option_value end) siteurl
from wp_options ;
</sql:query>
<h1>JSP 数据库实例</h1>
<table border="0" width="100%">
<tr>
<th>站点名</th>
<th>站点说明</th>
<th>站点地址</th>
</tr>
<c:forEach var="row" items="${result.rows}">
<tr>
<td><c:out value="${row.blogname}"/></td>
<td><c:out value="${row.blogdescription}"/></td>
<td><c:out value="${row.siteurl}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>