📄 new2.jsp
字号:
<html>
<head>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<title>分类新闻</title>
</head>
<body>
<table width="75%" align="center">
<%
int x,i,j,pageNo=1,pageLine=6;
if (request.getParameter("page")!=null)
pageNo=Integer.parseInt(request.getParameter("page"));
String sql,tempclass;
tempclass=(String)request.getParameter("class");
out.print("<tr><td align='center'><font size='4'><b>");
out.print(tempclass);
out.print("</b></font></td></tr>");
sql="select * from news where class='"+tempclass+"'";
ResultSet rs=sqlbean.executeQuery(sql);
x=0;
while(rs.next())
{x++;
out.print("<tr><td>");
out.print("<b>* </b>");
out.print("<font size='3'><a href='newscontext.jsp?title=");
out.print(rs.getString("title"));
out.print("'>");
out.print(rs.getString("title"));
out.print("</a></font></td></tr>");
}
%>
<%--out.print(x);
rs.absolute(2);
for(i=1,j=pageLine;i<=j;i++)
{
rs.relative(1);
out.print("<tr><td>");
out.print("<b>* </b>");
out.print("<font size='3'><a href='newscontext.jsp?title=");
out.print(rs.getString("title"));
out.print("'>");
out.print(rs.getString("title"));
out.print("</a></font></td></tr>");
}
--%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -