index.jsp
****************
<?xml version="1.0" encoding="gb2312"?>
娱乐场 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("
");
}
dbm=null;
%>
indexlist.jsp
****************
<?xml version="1.0" encoding="gb2312"?>
String cardid=request.getParameter("card");
if (cardid!=null&&(!cardid.equals(""))){
String sql="select iokesort,iokename from ioketype where tn="+cardid;
// out.println("
");
List rslist=new ArrayList();
DBManager dbm=new DBManager();
rslist=dbm.Select_Data(sql);
for(int i=0;iout.println("
");
}
dbm=null;
}
%>
list.jsp
******************
<?xml version="1.0" encoding="gb2312"?>
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("
");
}
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;
%>
view.jsp
************************
<?xml version="1.0" encoding="gb2312"?>
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;
%>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10294527/viewspace-125366/,如需转载,请注明出处,否则将追究法律责任。