分类:
2008-10-17 13:50:24
package org.cdy.
public class DBPaging {
private int totalPage;
public static int currentPage = 1;
private int pageSize;
private DBManager instance;
public DBPaging() {
instance = DBManager.getInstance("org.cdy.");
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalPage() {
return totalPage;
}
public void gotoPage(int page) {
switch (page) {
case 0:// first page
currentPage = 1;
break;
case -1:// previous page
if (currentPage > 1) {
--currentPage;
} else
currentPage = 1;
break;
case 2:// next page
if (currentPage < totalPage)
++currentPage;
else
currentPage = totalPage;
break;
case -4:// last page
currentPage = totalPage;
break;
}
DBPaging.setCurrentPage(currentPage);
}
public void setTotalPage(String userName) {
this.totalPage = instance.getTotalPage(userName, pageSize);
}
public void setTotalPage() {
this.totalPage = instance.getTotalPage(pageSize);
}
public static int getCurrentPage() {
return currentPage;
}
public static void setCurrentPage(int currentPage) {
DBPaging.currentPage = currentPage;
}
}
package org.cdy.
public class DBPaging {
private int totalPage;
public static int currentPage = 1;
private int pageSize;
private DBManager instance;
public DBPaging() {
instance = DBManager.getInstance("org.cdy.");
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalPage() {
return totalPage;
}
public void gotoPage(int page) {
switch (page) {
case 0:// first page
currentPage = 1;
break;
case -1:// previous page
if (currentPage > 1) {
--currentPage;
} else
currentPage = 1;
break;
case 2:// next page
if (currentPage < totalPage)
++currentPage;
else
currentPage = totalPage;
break;
case -4:// last page
currentPage = totalPage;
break;
}
DBPaging.setCurrentPage(currentPage);
}
public void setTotalPage(String userName) {
this.totalPage = instance.getTotalPage(userName, pageSize);
}
public void setTotalPage() {
this.totalPage = instance.getTotalPage(pageSize);
}
public static int getCurrentPage() {
return currentPage;
}
public static void setCurrentPage(int currentPage) {
DBPaging.currentPage = currentPage;
}
}
//下面就是这个数据库管理员DBManager的定义
view plaincopy to clipboardprint?
package org.cdy.
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Locale;
import javax.ejb.Local;
import org.cdy.
import org.cdy.
public class DBManager {
private static DBManager instance = null;// 单例模式,学过设计模式的应该知道是怎么会事
public static synchronized DBManager getInstance(String className) {
if (instance != null) {
return instance;
}
try {
instance = (DBManager) Class.forName(className).newInstance();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return instance;
}
protected DBManager() {
}
public int getTotalPage(int pageSize) {
int totalPage = 1;
int totalRow = 0;
String sql = null;
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
conn = DBConnection.getConnection();
sql = "select * from note";
try {
pst = conn.prepareStatement(sql);
// System.out.println("fdffffffffffffff");
rs = pst.executeQuery();
// System.out.println("fdffffffffffffff");
while (rs.next()) {
++totalRow;
}
[1]