<%
List rslist=new ArrayList();
DBManager dbm=new DBManager();
rslist=dbm.Select_Data("select iokesort,iokename from ioketype where tn=0");
for(int i=0;iout.println(""+((ArrayList)rslist.get(i)).get(1)+"
");
}
dbm=null;
%>

<%
String cardid=request.getParameter("card");
if (cardid!=null&&(!cardid.equals(""))){
String sql="select iokesort,iokename from ioketype where tn="+cardid;
// out.println(" "+rs.getString("iokename")+"
");
List rslist=new ArrayList();
DBManager dbm=new DBManager();
rslist=dbm.Select_Data(sql);
for(int i=0;iout.println(" "+((ArrayList)rslist.get(i)).get(1)+"
");
}
dbm=null;
}
%>
返回

<%
String card=request.getParameter("card");
String iokesort=request.getParameter("iokesort");
int RowCount; //记录总数
int PageSize=8; //一页显示的记录数
int PageCount; //总页数
int PageNo; //待显示页码

String Page= request.getParameter("page");//取得要显示的页码
if(Page==null){
PageNo=1;
}else{
PageNo= java.lang.Integer.parseInt(Page);
if(PageNo<1) PageNo=1;
}

List rslist=new ArrayList();
DBManager dbm=new DBManager();
String sql="select id,title from iokecontent where iokesort="+iokesort;
//取得符合条件的总记录数
RowCount=dbm.Select_Count_SQL(sql);
if(RowCount!=0){
//计算总页数
PageCount=(RowCount+PageSize-1)/PageSize;
rslist=dbm.queryByPage_SQL_OrderBy(RowCount,PageSize,PageNo,sql+" order by id desc");//按id降序排序
for(int i=0;iout.println(""+((ArrayList)rslist.get(i)).get(1)+"
");
}
if(PageNo>1){
%>
上一页
<%}
if(PageNo%>
下一页
<%}
}else{
out.println("对不起此类栏目没有新增内容！");
}

sql="select iokename from ioketype where iokesort="+card;
String iokename="";
rslist=dbm.Select_Data(sql);
for(int i=0;iiokename=((ArrayList)rslist.get(i)).get(0).toString();
}
dbm=null;
%>


返回<%=iokename%>

返回首页

<%
String card=request.getParameter("card");
String iokesort=request.getParameter("iokesort");
String id=request.getParameter("id");
String PageNo=request.getParameter("page");

String sql="select info from iokecontent where id="+id;
List rslist=new ArrayList();
DBManager dbm=new DBManager();
rslist=dbm.Select_Data(sql);
for(int i=0;iString content=new String("");
content=((ArrayList)rslist.get(i)).get(0).toString();
content=content.replaceAll("

","
");
content=content.replaceAll("

","
");
content=content.replaceAll("
","
");
out.println(content+"
");

}
dbm=null;
%>
返回