根据我给你的代码可以在页面显示所有的记录 但是数据太多的话不能分页就很麻烦了!我现在要根据可滚动的结果集实现分页。要求每页显示15条记录分页功能有: 首页,下一页 上一页 末页 希望高手门能实现,并给出代码!望能与其结为朋友联系:qq:59431800 email:[email protected]
//操作数据的executeMe.java
package method;
import testdemo1.DBConnection;
import method.userBean;
import java.sql.*;
import java.util.*;
import java.util.Iterator;
public class executeMe{
private Connection dbconn = null;
public executeMe() {
try {
dbconn =DBConnection.getConnection();
if (dbconn != null) {
System.out.println("数据库已经连接!");
}
}catch (Exception ex) {
ex.printStackTrace();
} }
//查询所有
public Iterator select(){
Vector v = new Vector();
String sqlstr = "select * from user_info where quanx<>'系统管理员' order by RIG_TIME desc";
try{
Statement stmt = dbconn.createStatement();
ResultSet rs= stmt.executeQuery(sqlstr);
while(rs.next()){
userBean u=new userBean();
u.setUSER_ID(rs.getString("USER_ID"));
u.setUSERNAME(rs.getString("USERNAME"));
u.setPASSWORD(rs.getString("PASSWORD"));
u.setGENDER(rs.getString("GENDER"));
u.setREALNAME(rs.getString("REALNAME"));
u.setEMAIL(rs.getString("EMAIL"));
u.setTELEPHONE(rs.getString("TELEPHONE"));
u.setCOMPANY(rs.getString("COMPANY"));
u.setADDRESS(rs.getString("ADDRESS"));
u.setCODING(rs.getString("CODING"));
u.setRIG_TIME(rs.getString("RIG_TIME"));
u.setQUANX(rs.getString("QUANX"));
v.add(u);
}
rs.close();
stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}finally{
try{
if (dbconn != null) dbconn.close();
System.out.println("断开连接!");
}catch(SQLException ex){
ex.printStackTrace();
}
}
Iterator it=v.iterator();
return it; }
public Iterator select(String USER_ID){
Vector v = new Vector();
String sqlstr = "select * from user_info where USER_ID='"+USER_ID+"' order by RIG_TIME desc";
try{
Statement stmt = dbconn.createStatement();
ResultSet rs= stmt.executeQuery(sqlstr);
while(rs.next()){
userBean u=new userBean();
u.setUSER_ID(rs.getString("USER_ID"));
u.setUSERNAME(rs.getString("USERNAME"));
u.setPASSWORD(rs.getString("PASSWORD"));
u.setGENDER(rs.getString("GENDER"));
u.setREALNAME(rs.getString("REALNAME"));
u.setEMAIL(rs.getString("EMAIL"));
u.setTELEPHONE(rs.getString("TELEPHONE"));
u.setCOMPANY(rs.getString("COMPANY"));
u.setADDRESS(rs.getString("ADDRESS"));
u.setCODING(rs.getString("CODING"));
u.setRIG_TIME(rs.getString("RIG_TIME"));
u.setQUANX(rs.getString("QUANX"));
v.add(u);
}
rs.close();
stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}finally{
try{
if (dbconn != null) dbconn.close();
System.out.println("断开连接!");
}catch(SQLException ex){
ex.printStackTrace();
}
}
Iterator it=v.iterator();
return it; }
}
代码后面还有
//操作数据的executeMe.java
package method;
import testdemo1.DBConnection;
import method.userBean;
import java.sql.*;
import java.util.*;
import java.util.Iterator;
public class executeMe{
private Connection dbconn = null;
public executeMe() {
try {
dbconn =DBConnection.getConnection();
if (dbconn != null) {
System.out.println("数据库已经连接!");
}
}catch (Exception ex) {
ex.printStackTrace();
} }
//查询所有
public Iterator select(){
Vector v = new Vector();
String sqlstr = "select * from user_info where quanx<>'系统管理员' order by RIG_TIME desc";
try{
Statement stmt = dbconn.createStatement();
ResultSet rs= stmt.executeQuery(sqlstr);
while(rs.next()){
userBean u=new userBean();
u.setUSER_ID(rs.getString("USER_ID"));
u.setUSERNAME(rs.getString("USERNAME"));
u.setPASSWORD(rs.getString("PASSWORD"));
u.setGENDER(rs.getString("GENDER"));
u.setREALNAME(rs.getString("REALNAME"));
u.setEMAIL(rs.getString("EMAIL"));
u.setTELEPHONE(rs.getString("TELEPHONE"));
u.setCOMPANY(rs.getString("COMPANY"));
u.setADDRESS(rs.getString("ADDRESS"));
u.setCODING(rs.getString("CODING"));
u.setRIG_TIME(rs.getString("RIG_TIME"));
u.setQUANX(rs.getString("QUANX"));
v.add(u);
}
rs.close();
stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}finally{
try{
if (dbconn != null) dbconn.close();
System.out.println("断开连接!");
}catch(SQLException ex){
ex.printStackTrace();
}
}
Iterator it=v.iterator();
return it; }
public Iterator select(String USER_ID){
Vector v = new Vector();
String sqlstr = "select * from user_info where USER_ID='"+USER_ID+"' order by RIG_TIME desc";
try{
Statement stmt = dbconn.createStatement();
ResultSet rs= stmt.executeQuery(sqlstr);
while(rs.next()){
userBean u=new userBean();
u.setUSER_ID(rs.getString("USER_ID"));
u.setUSERNAME(rs.getString("USERNAME"));
u.setPASSWORD(rs.getString("PASSWORD"));
u.setGENDER(rs.getString("GENDER"));
u.setREALNAME(rs.getString("REALNAME"));
u.setEMAIL(rs.getString("EMAIL"));
u.setTELEPHONE(rs.getString("TELEPHONE"));
u.setCOMPANY(rs.getString("COMPANY"));
u.setADDRESS(rs.getString("ADDRESS"));
u.setCODING(rs.getString("CODING"));
u.setRIG_TIME(rs.getString("RIG_TIME"));
u.setQUANX(rs.getString("QUANX"));
v.add(u);
}
rs.close();
stmt.close();
}catch(Exception ex){
ex.printStackTrace();
}finally{
try{
if (dbconn != null) dbconn.close();
System.out.println("断开连接!");
}catch(SQLException ex){
ex.printStackTrace();
}
}
Iterator it=v.iterator();
return it; }
}
代码后面还有
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货