doshowsub.jsp

JSP+SQL2005 MVC模式 下载后改DB.java类的SQL密码就可用。

<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.ResultSet,com.model.javabean.SubSingle,java.util.ArrayList" %>
<jsp:useBean id="mydb" class="com.model.javabean.DB"/>
<%
String num=request.getParameter("num");
System.out.print(num);

String sql="select * from tb_issue where iss_card_type="+num+" order by iss_time desc";
ResultSet rs=mydb.Read(sql);
ArrayList sublist = new ArrayList();
if(rs.next()){
    rs.previous();
    while(rs.next()){
       SubSingle sub = new SubSingle();
       sub.setId(rs.getInt("id"));
       sub.setSubtitle(rs.getString("iss_title"));
       sub.setIssuer(rs.getString("iss_author"));
       sub.setTime(rs.getTimestamp("iss_time").toLocaleString());
       sub.setContent(rs.getString("iss_content"));
       sub.setTypenum(rs.getInt("iss_card_type"));
       sublist.add(sub);
    }
    mydb.closed();
    session.setAttribute("sublist",sublist);
  System.out.print("有数据");      
}
else{
	session.setAttribute("sublist",null);
	System.out.print("没数据");
	}
%>
<jsp:forward page="showsubject.jsp"/>