📄 wenzhang.jsp

📁 为html格式的静态网页形式

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
-->
</style></head>

<body><div align="center">
<jsp:useBean id="ConBean" scope="session" class="com.bitc.ch13.DBCon"/>	
<%
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rsl = stmt.executeQuery("SELECT * FROM jsp8_lei where vx = 0");
out.println("<table width=100% border=1 bordercolor=#FFFF00 bgcolor=#3399CC>");
int yiol = 0;
while(rsl.next()){
String v = rsl.getString("v");
if(yiol%8==0){
out.println("<tr align=center valign=middle>");
}  
out.println("<td><a href=wenzhangx.jsp?id="+v+">"+v+"</a></td>");
if((yiol+1)%8==0){
out.println("</tr>");
}
yiol++;
} 
out.println("</table>");
rsl.close();
stmt.close();
ConBean.close();
%>

</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -