%@page contentType="text/html;charset=gb2312"%>
<%@page import ="java.sql.*"%>
<%@page import ="javax.sql.*"%>
<%@page import ="java.util.*"%>
<%@page import ="java.sql.DriverManager.*"%>
<%@include file="/henan/js/biaoti.js"%>
<%
Vector vector=new Vector();
Connection con=null;
String title=null;
//String shipin=null;
try{
String sql="SELECT * FROM ltinfo where category like '%321%' and info_history like '%发布%' order by id desc";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con =DriverManager.getConnection("jdbc:mysql://localhost:3306/hongta","root","mysql");
Statement stat=null;
stat=con.createStatement();
ResultSet rst=stat.executeQuery(sql);
while(rst.next()){
Vector vec=new Vector();
vec.add(rst.getString("id"));
vec.add(rst.getString("title"));
vec.add(rst.getString("createtime").substring(0,10));
//shipin=rst.getString("bodydescribe");
//shipin=shipin.substring(shipin.indexOf("/cenweb"));
//shipin=shipin.substring(0,shipin.indexOf("rm"))+"rm";
vec.add(rst.getString("bodydescribe"));
vector.add(vec);
}
rst.close();
}catch(Exception e){
e.printStackTrace();
out.print(e);
}
finally{
if(con!=null) try{ con.close();}catch(Exception e){}
}
int vecsize=vector.size();//记录总数
int pagesize=20; //每页多少条纪录,0为不分页
int pageNo=1; //当前页号,缺省为第一页
int pgCounter=0; //总页数
int pageUp=1;
int pageDown=1;
if (request.getParameter("pageno")!=null){
try{
Integer.parseInt(request.getParameter("pageno"));
pageNo=new Integer(request.getParameter("pageno")).intValue();
if(pageNo<1){pageNo=1;}
}catch (NumberFormatException ex) {
pageNo=1;
}
}else{
pageNo=1;
}
//计算页
int iFrom=0;
int iTo=0;
if (vecsize> 0){
if ((vecsize % pagesize)>0){
pgCounter=vecsize/pagesize + 1;
}else{
pgCounter=vecsize/pagesize;
}
if (pageNo>pgCounter){
pageNo=1;
}
if (pageNo!=1){
pageUp=pageNo-1;
}else{
pageUp=1;
}
if (pageNo!=pgCounter){
pageDown=pageNo+1;
}else{
pageDown=pgCounter;
}
iFrom=(pageNo-1) * pagesize; // from 从0计数
}
%>
欢迎光临河南黄河网