手机WAP编程

开发平台：

Java

news0202.jsp：源码内容

							<%@ page contentType="text/vnd.wap.wml" import="java.sql.*" language="java"%>
<?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"/>
	</head>

	<card id="news" title="news" newcontext="true">
	
<do type="prev" name="Prev" label="Back"><prev/></do>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
  String url="jdbc:microsoft:sqlserver://172.0.0.1;DatabaseName=herald";
  String user="sa";
  String password="kurtCobain4551306";
  Connection conn=DriverManager.getConnection(url,user,password);
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  String sql="select top 7 
  NewsID,Title,UpdateTime,BigClassName,SmallClassName,SpecialID,click from News where 
  BigClassName='" & BigClassName &"'  order by NewsID DESC";
  ResultSet rs1=stmt.executeQuery(sql);
  while(rs1.next()){%>
<%=rs1.getString("NewsID")%>
<%=rs1.getString("BigClassName")%>
<%=rs1.getString("SmallClassName")%>
<%=rs1.getString("SpecialId")%>
<%=rs1.getString("Title") %>
<%}rs.close();%>
           <br/><a href="index.wml">返回主页</a><br/>
	</card>
</wml>

						