<%@ page language="java" contentType="text/html; charset=windows-31j" pageEncoding="SHIFT-JIS"%>
<%@ page import="java.sql.*" %>
Sample JSP
| ISBN | TITLE | AUTHOR | PRICE |
|---|
<%
try {
data.ConnectOpen();
ResultSet res = data.ExeQuery("SELECT * FROM books ORDER BY price");
while (res.next()){
%>
| <%= res.getString(1) %> |
<%= res.getString(2) %> |
<%= res.getString(3) %> |
<%= res.getString(4) %> |
<%
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
data.ConnectClose();
} catch (Exception e) {
e.printStackTrace();
}
}
%>