<%
int pageSize=23;
int pageNow=1;
int rowCount=0;
int pageCount=0;
//動態的接受pageNow
String sPageNow = request.getParameter("pageNow");
if(sPageNow !=null)
pageNow = Integer.parseInt(sPageNow);
String yea = request.getParameter("yea");
String mon = request.getParameter("mon");
if(yea!=null){
session.setAttribute("yea",yea);}
yea=(String)session.getAttribute("yea");
if(mon!=null){
session.setAttribute("mon",mon);}
mon=(String)session.getAttribute("mon");
String pp =null;
if(yea.equals("2009")){
pp = "cefxreport09/";
}else{
pp = "cefxreport/";
}
%>
<%
java.util.Date d=new java.util.Date();
//java.text.SimpleDateFormat dformat=new java.text.SimpleDateFormat("yyyy-MM-dd HH-mm-ss");
java.text.SimpleDateFormat dformat1=new java.text.SimpleDateFormat("MM");
//java.text.SimpleDateFormat df=new java.text.SimpleDateFormat("yyyy");
String month =dformat1.format(d);
if(mon!=null){month=mon;}
//String month = request.getParameter("month");
//String year = df.format(d);
//if(year.equals("2010")){
//out.println("歡迎光臨!!");
//}
String path = "jan/";
if(month.equals("01")){
path="jan/";
}
String pname = null;
if(request.getParameter("file")!=null){
pname = request.getParameter("file").trim();}
if(pname!=null){
session.setAttribute("pname2",pname);}
pname=(String)session.getAttribute("pname2");
Connection conn = null;
DBConnection db = new DBConnection("dbcon.dbConfig");
PreparedStatement pstmt = null;
request.setCharacterEncoding("UTF-8");
//IState statebean = null;
try
{
conn = db.getConnection("dbcon.dbConfig");
ResultSet rs = null;
if(conn != null)
{
//if(!yea.equals("select"))
String count = "select count(*) from fxreport where repname like '%"+pname+"%' and yea="+yea+" and mon="+mon;
pstmt = conn.prepareStatement(count);
rs = pstmt.executeQuery();
int num = 0;
if(rs.next())
{
num = rs.getInt(1);
rowCount = num;
}
rs.close();
if(pageSize > rowCount)
pageSize = rowCount;
if(pageSize==0)pageSize=1;
/////////////////////////////////
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount = rowCount/pageSize+1;
}
String sql = "select * from fxreport where repname like '%"+pname+"%' and yea="+yea+" and mon="+mon+" order by id desc limit ?,?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,pageSize*(pageNow-1));
if(pageSize*pageNow < rowCount ){
pstmt.setInt(2,pageSi
ze);
num = pageSize;
}else{
pstmt.setInt(2,rowCount-(pageNow-1)*pageSize);
num = rowCount-(pageNow-1)*pageSize;
}
rs = pstmt.executeQuery();
String repname = null;
String time1 = null;
for(int i=0;i{
%>
<%
rs.next();
repname = rs.getString(2);
time1=rs.getString(5);
//System.out.print((String)request.getAttribute("pna"));
%>
<%=repname %>
|
<%=time1 %>
|
<%}
rs.close();
}
} catch (SQLException e)
{
e.getMessage();
throw new SysException(e.getMessage());
}finally{
if(pstmt != null)
try
{
pstmt.close();
} catch (SQLException e)
{
e.getMessage();
}
db.closeConnection();
conn.close();
}
%>
<%
//上一頁
if(pageNow!= 1)
out.println("[上一頁]");
String sty="sty3";
for(int i=1;i<=pageCount;i++){
if(i==pageNow){sty="sty4";}
else{sty="sty3";}
out.println("["+i+"]");
}
//下一頁
if(pageNow!=pageCount&&pageCount!=1)
out.println("[下一頁]");
%>
|
|
