public class ContactBean{
private Connection conn;
Vector v;
private String condition;
public ContactBean(String temp)throws Exception{
conn = DatabaseConn.getConnection();
v = new Vector();
condition=temp;
System.out.println(temp);
}
public int getAvailableCount() throws Exception{
int ret=0;
Statement stmt = conn.createStatement();
String strSql = "select count(*) from TKFGL_YHGL"+condition;
System.out.println(strSql);
ResultSet rset = stmt.executeQuery(strSql);
while(rset.next()){
ret = rset.getInt(1);
}
rset.close();
stmt.close();
return ret;
}
public PageBean listData(String temp,String page)throws Exception{
try{
PageBean pageBean = new PageBean(this);
int PageNum = Integer.parseInt(page);
Statement stmt=conn.createStatement();
System.out.println(temp);
String strSql="select top "+PageNum*pageBean.rowsPerPage+
" * from TKFGL_YHGL"+temp+" order by QY";
System.out.println("---------------------------------------");
System.out.println(strSql);
ResultSet rset = stmt.executeQuery(strSql);
int i = 0;
while(rset.next()){
if(i>(PageNum-1)*pageBean.rowsPerPage-1){
Object[] obj = new Object[11];
obj[0]=rset.getString(1);
obj[1]=rset.getString(2);
obj[2]=rset.getString(3);
obj[3]=rset.getString(4);
obj[4]=rset.getString(5);
obj[5]=rset.getString(6);
obj[6]=rset.getString(7);
obj[7]=rset.getString(8);
obj[8]=rset.getString(9);
obj[9]=rset.getString(10);
obj[10]=rset.getString(11);
v.add(obj);
}
i++;
}
rset.close();
stmt.close();