51CTO下载-分页查询.docVIP

使用Jdbc+Servlet+Mysql实现数据库分页查询及页面展示 1.项目整体概况 2．BaseDao类的建立 是为了连接数据库 import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class BaseDao { private static final String driver=com.mysql.jdbc.Driver; private static final String url=jdbc:mysql://localhost:3306/school; private static final String username=root; private static final String password=admin; private static Connection con; static{ try { Class.forName(driver);//注册驱动 con=DriverManager.getConnection(url, username, password);//连接数据库 } catch (Exception e) { e.printStackTrace(); } } public static Connection getCon(){ return con; } //测试数据库是否连接成功 public static void main(String[] args) { Connection con1=BaseDao.getCon(); System.out.println(con1); } } 2．数据库表resource封装类Resource public class Resource { private int resourceId;//资源ID private String resourceName;//资源名称 private String resourceIconcls;//资源图标 private String resourceModle;//资源模型 public int getResourceId() { return resourceId; } public void setResourceId(int resourceId) { this.resourceId = resourceId; } public Resource(int resourceId, String resourceName, String resourceIconcls, String resourceModle) { super(); this.resourceId = resourceId; this.resourceName = resourceName; this.resourceIconcls = resourceIconcls; this.resourceModle = resourceModle; } public String getResourceName() { return resourceName; } public void setResourceName(String resourceName) { this.resourceName = resourceName; } public String getResourceIconcls() { return resourceIconcls; } public void setResourceIconcls(String resourceIconcls) { this.resourceIconcls = resourceIconcls; } public String getResourceModle() { return resourceModle; } public void setResourceModle(String resourceModle) { this.resourceModle = resourceModle; } } 4．创建resource表的接口ResourceDao import java.util.List; import com.bdqn.jdbcForMysql.entity.Resource; public interface ResourceDao { //得到资源表里面