利用eXtremeComponents标签来实现分页实例

package www.eternal.com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class StudDAO { private Connection conn = null ; private Statement stmt = null ; private PreparedStatement pstmt = null ; private ResultSet rs = null; private static final String URL = "jdbc:mysql://localhost:3306/page"; private static final String USERNAME = "root" ; private static final String PASSWORD = "root" ; private List<Map<String,String>> list = new ArrayList<Map<String,String>>() ; private Map<String,String> map = null ; public StudDAO() { } //数据库连接 public synchronized Connection getConnection() { try { Class.forName("com.mysql.jdbc.Driver") ; conn = DriverManager.getConnection (URL,USERNAME,PASSWORD) ; } catch (ClassNotFoundException e) { e.printStackTrace () ; return null ; } catch (SQLException e) { e.printStackTrace () ; return null ; } return conn ; } public List<Map<String,String>> query() { try { if (this.getConnection()!=null) { pstmt = this.getConnection().prepareStatement("select * from student") ; rs = pstmt.executeQuery() ; while (rs.next()) { map = new HashMap<String,String>() ; map.put("stuName", rs.getString("stuName")) ; map.put("address", rs.getString("address")) ; map.put("stuPhone", rs.getString("stuPhone")) ; list.add(map) ; } } } catch(SQLException e) { e.printStackTrace() ; } return list ; } }