javaweb mvc crud分页

MySQl+eclipse+Tomcat8+JDK8+Druid+Jdbctemplate+jsp+servlet

MYSQL

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.26 : Database - jdbctemp
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jdbctemp` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `jdbctemp`;

/*Table structure for table `goods` */

DROP TABLE IF EXISTS `goods`;

CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `price` decimal(18,2) NOT NULL,
  `color` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

/*Data for the table `goods` */

insert  into `goods`(`id`,`name`,`price`,`color`) values (1,'华硕','11.00','黑色'),(2,'小米','11.00','蓝色'),(3,'红米','11.00','黑色'),(4,'苹果','11.00','淡黄色'),(5,'清华同方','11.00','黄色'),(6,'TinkPad','1.00','黑色'),(7,'TinkPad','11.00','黑色'),(8,'三星','11.00','黄色'),(10,'清华同方','11.00','黄色'),(11,'清华同方','1.00','黑色'),(12,'三星','11.00','黑色'),(13,'TinkPad','11.00','蓝色'),(14,'TinkPad','11.00','淡黄色'),(15,'三星','11.00','蓝色'),(16,'外星人','11.00','红色'),(17,'华硕','11.00','黄色'),(18,'华为','2.00','黄色'),(19,'TinkPad','2.00','蓝色'),(20,'外星人','2.00','红色'),(21,'清华同方','2.00','淡黄色'),(22,'小米','2.00','蓝色'),(24,'红米','1.00','淡黄色'),(25,'TinkPad','11.00','淡黄色'),(26,'三星','11.00','蓝色'),(27,'三星','11.00','蓝色'),(28,'外星人','11.00','蓝色'),(29,'外星人','11.00','蓝色'),(31,'外星人','11.00','蓝色'),(32,'外星人','11.00','淡黄色'),(33,'外星人','11.00','淡黄色'),(34,'TinkPad','11.00','蓝色');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

MVC三层结构

Dao层连接数据库crud接口，DaoImpl实现Dao具体的crud
entity 实体包根据数据表建实体类 get,set方法进行封装
Service控制层接口，ServiceImpl实现Service层返回DaoImpl的方法
Servlet进行页面数据查询渲染到jsp

源代码地址

链接: https://pan.baidu.com/s/1hvHyc8PvHRxM8REnRd3GFA 提取码: ywat 复制这段内容后打开百度网盘手机App，操作更方便哦