📄 index.jsp
字号:
<%@ page import="java.util.Iterator.*" errorPage="WEB-INF/error.jsp" contentType="text/html;charset=gb2312"%>
<%@ taglib prefix="c" uri = "http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head>
<title>index **</title>
</head>
<body>
<jsp:include page="header.jsp" />
<br>
<br>
<form method="post" action=".jsp">
<p>下午好: ${sessionScope.Username} 登陆</p>
<center>
<table width="100%" >
<thead align="left">
<font size=5px>以下是本站目前的所有出售图书:</font><font size=21 color="blue">
</thead>
<tr align="left">
<th>书名</th>
<th>作者</th>
<th>出版社</th>
<th>类别</th>
<th>卖方电话号码</th>
</tr>
<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:test" var="mydb" />
<sql:query sql = "select * from classmates" var="myuser" dataSource="${mydb}" />
<c:forEach var="user" items="${myuser.rows}">
<tr>
<td>《${user.name }》</td>
<td>${user.sex }</td>
<td>${user.qq }</td>
<td>${user.email }</td>
<td>${user.tel }</td>
</tr>
</c:forEach>
</table>
</center>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -