picringlast.jsp

来自「wml和jsp实现wap网站后台管理及手机显示的过程。」· JSP 代码 · 共 29 行

JSP
29
字号
<%@ page contentType="text/vnd.wap.wml" language="java" import="java.sql.*"%>
<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml"><wml>	<head>	<meta forua="true" http-equiv="Cache-Control" content="max-age=0;charset=gb2312"/>	</head>
	<card id ="picring" title="picring">
	<p>
<do type="prev" name="Prev" label="Back"><prev/></do>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();    String url ="jdbc:mysql://localhost/picring?user=nangua&password=2003herald&useUnicode=true&characterEncoding=8859_1";    Connection con= DriverManager.getConnection(url);    Statement statement=con.createStatement();    String big=request.getParameter("big");
    String small=request.getParameter("small");
    String str="";
    if(request.getParameter("small")!=null)str="select * from class"+big+" where parentid="+small;
    else str="select * from class"+big;    ResultSet rs=statement.executeQuery(str);    while(rs.next()){%>
<%String filepath=rs.getString("filepath");%>
<a href="<%=filepath%>"><%=rs.getString("title")%></a><br/>
<%}rs.close();%>
<br/><a href="http://herald.seu.edu.cn/ewap/index.wml">返回主页</a><br/>
</p>
</card></wml>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?