?? doshowsub.jsp
字號:
<%@ 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"/>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -