📄 jspexample.jsp
字号:
<%@ page import="java.sql.*" %>
<html>
<head>
<title>showbooks</title>
</head>
<body>
<h1>Library Book</h1><br>
<form id="form1" name="form1" method="post" action="">
<table width="300" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="150" height="39"><label>
<input type="submit" name="Submit" value="提交" />
</label></td>
<td width="150"> </td>
</tr>
<tr>
<td height="36">View Basket </td>
<td> </td>
</tr>
<tr>
<td height="144" colspan="2" valign="top">
<%
String jdbcDriverName="org.postgresql.Driver";
Driver driver = (Driver) Class.forName(jdbcDriverName).newInstance();
DriverManager.registerDriver(driver);
Connection dbcon = DriverManager.getConnection("jdbc:postgresql://localhost/library","pkme","");
Statement st = dbcon.createStatement();
%>
<table width="100%" height="144" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>Add to Cart </td>
<td>Title</td>
</tr>
<%ResultSet rt = st.executeQuery("select name from title5 ");
String
while(rt.next())
{
out.println("<tr>");
String bookName=rt.getString("name");
out.print("<td><label><input type='checkbox' name='checkbox' value=<%%>")
out.println("<td>"+bookName+"</td>");
out.println("</tr>");
out.println(rt.getFetchSize());
}
%>
</table></td>
</tr>
</table>
<label>
<input type="checkbox"name="checkbox1" value="a">
</label>
<label>
<input type="checkbox" name="checkbox2" value="checkbox">
</label>
<label>
<input type="checkbox" name="checkbox3" value="checkbox">
</label>
<label></label>
</form>
<p> </p>
<%
rt.close();
st.close();
dbcon.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -