MySQl+eclipse+Tomcat8+JDK8+Druid+Jdbctemplate+jsp+servlet
MYSQL
;
;
;
;
;
;
CREATE DATABASE `jdbctemp`
;
USE `jdbctemp`
;
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
;
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','蓝色');
;
;
;
;
MVC三层结构
Dao层连接数据库crud接口，DaoImpl实现Dao具体的crud entity 实体包根据数据表建实体类 get,set方法进行封装 Service控制层接口，ServiceImpl实现Service层返回DaoImpl的方法 Servlet进行页面数据查询渲染到jsp
源代码地址
链接: https://pan.baidu.com/s/1hvHyc8PvHRxM8REnRd3GFA 提取码: ywat 复制这段内容后打开百度网盘手机App，操作更方便哦
