mid_index.jsp

来自「安装方法 1:MS SQL 把SETSQL.SQL用查询分析器导入你现在所在的」· JSP 代码 · 共 50 行

<%@ page language="java" contentType="text/vnd.wap.wml;charset=gb2312" %>
<%@ page import="java.sql.*" errorPage=""%>

<%@ include file="inc/conn.jsp" %>

<?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>

<card id="card01" title="首页">
<%

%>
<p>
<br/>

<% 

String sql_type = "select    type from midtype";

rs=stmt.executeQuery(sql_type);
while (rs.next()) {

String rs_type  =  rs.getString("type");

//out.print(rs_type);

%>

<a href="mid_list.jsp?TYPE=<%=rs_type%>"><%=rs_type%></a><br/>

<% 
}
rs.close();

	if(conn!=null)
	{
		conn.close();
	}
	if(stmt!=null)
	{
		stmt.close();
	}
%><br/>
<a href="mid_search.jsp">自定义查找</a><br/>
<%@ include file="noclassfoot.jsp"%>

</p>
</card>
</wml>