?? statservice.java
字號:
package com.tsinghuait.st0717.hospitalsystem.service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import com.tsinghuait.st0717.hospitalsystem.dao.SQLConnection;
import com.tsinghuait.st0717.hospitalsystem.dto.Stat;
public class StatService {
private int rowsCount = 0;
private int pageCount = 0;
public Collection searchReceiptByDate(String sql,int page,int pageSize) {
Collection<Stat> col=null;
try {
Statement st=new SQLConnection().getConnection().createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery(sql);
if (rs != null && rs.next()) {
col = new ArrayList<Stat>();
// 得到數據總條數
rs.last();
System.out.println(rs.getRow());
rowsCount = rs.getRow();
// 當前顯示頁
pageCount = (rowsCount / pageSize)
+ (rowsCount % pageSize == 0 ? 0 : 1);
System.out.println(pageCount + "頁數");
int rowStartIndex = (page - 1) * pageSize + 1;
rs.absolute(rowStartIndex);
int i = 0;
do {
Stat dto = new Stat();
//dto.setId(rs.getInt("id"));
dto.setItems(rs.getString("items"));
dto.setPay(rs.getFloat("pay"));
dto.setPayee(rs.getString("payee"));
//dto.setPayeeId(rs.getInt("payeeId"));
dto.setName(rs.getString("name"));
dto.setPdate(rs.getDate("pdate"));
dto.setIsFinished(rs.getByte("isFinished"));
col.add(dto);
i++;
} while (rs.next() && i < pageSize);
}
} catch (SQLException e) {
e.printStackTrace();
}
return col;
}
// 返回顯示頁的顯示行
public int getPageCount() {
return pageCount;
}
// 返回所有行
public int getRowsCount() {
return this.rowsCount;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -