?? contactbean.java
字號:
package com.jspdev.ch13;
import java.util.*;
import com.jspdev.util.*;
import java.sql.*;
public class ContactBean
{
private Connection conn;
Vector v;
public ContactBean()throws Exception
{
conn=DatabaseConn.getConnection();
v=new Vector();
}
public int getAvailableCount()throws Exception
{
int ret=0;
Statement stmt=conn.createStatement();
String strSql="select count(*) from contact";
ResultSet rset=stmt.executeQuery(strSql);
while(rset.next())
{
ret=rset.getInt(1);
}
return ret;
}
public PageBean listData(String page)throws Exception
{
try
{
PageBean pageBean=new PageBean(this);
int pageNum=Integer.parseInt(page);
Statement stmt=conn.createStatement();
String strSql="select top "+pageNum*pageBean.rowsPerPage+" * from contact order by userName";
ResultSet rset=stmt.executeQuery(strSql);
int i=0;
while(rset.next())
{
if(i>(pageNum-1)*pageBean.rowsPerPage-1)
{
Object[] obj=new Object[6];
obj[0]=rset.getString("userName");
obj[1]=new Integer(rset.getInt("mobile"));
obj[2]=rset.getString("phone");
obj[3]=rset.getString("mail");
obj[4]=rset.getDate("lastcontact");
obj[5]=rset.getString("mem");
v.add(obj);
}
i++;
}
rset.close();
stmt.close();
pageBean.curPage=pageNum;
pageBean.data=v;
return pageBean;
}
catch(Exception e)
{
e.printStackTrace();
throw e;
}
}
public Vector getResult()throws Exception
{
//listDate("2");
return v;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -