SSM简明教程:简单的十步教你搭建人生第一个SSM框架[ SSM框架整合教程(Spring+SpringMVC+MyBatis) ] | 您所在的位置:网站首页 › ssm框架系统架构图 › SSM简明教程:简单的十步教你搭建人生第一个SSM框架[ SSM框架整合教程(Spring+SpringMVC+MyBatis) ] |
SSM_BookSystem SSM框架基础
SSM_BookSystem ---> Hello CRUD 说明:本项目目前包含基础的CRUD 日期:2017-05-01 22:25:37 作者:hisenyuan 网站:hisen.me 源码:https://github.com/hisenyuan/SSM_BookSystem (最新更新会在此处) 预览:
一般idea创建工程的过程 打开idea ---> File ---> new ---> project ---> maven ---> create from archetype ---> maven-archetype-webapp ---> 接下来一般默认即可 最后在main目录下新建java文件夹,并且mark as source root。 首先创建如下的目录结构即可: ├── java │ └── com │ └── hisen │ ├── dao │ │ └── BookDao.java │ ├── entity │ │ └── Book.java │ ├── service │ │ ├── BookService.java │ │ └── impl │ │ └── BookServiceImpl.java │ └── web │ └── BookController.java ├── resources │ ├── jdbc.properties │ ├── logback.xml │ ├── mapper │ │ └── BookMapper.xml │ ├── mybatis-config.xml │ └── spring │ ├── spring-dao.xml │ ├── spring-service.xml │ └── spring-web.xml └── webapp ├── index.jsp └── WEB-INF ├── jsp │ ├── detail.jsp │ └── list.jsp └── web.xml 第一步:添加Spring、Spring MVC、Mybatis的依赖都配有详细的说明,这里不再重复 详情请看pom.xml 第二步:添加数据库配置文件 ├── resources │ ├── jdbc.properties创建数据库配置文件,内容如下 jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://127.0.0.1:3306/booksystem?useUnicode=true&characterEncoding=utf8 jdbc.username=root jdbc.password=hisen这里需要创建一个数据库,名为:booksystem 建表语句如下: CREATE TABLE `book` ( `book_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '图书ID', `name` varchar(100) NOT NULL COMMENT '图书名称', `number` int(11) NOT NULL COMMENT '图书数量', `detail` varchar(200) NOT NULL COMMENT '图书描述', PRIMARY KEY (`book_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='图书表'表结构如下: +---------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+----------------+ | book_id | bigint(20) | NO | PRI | NULL | auto_increment | | name | varchar(100) | NO | | NULL | | | number | int(11) | NO | | NULL | | | detail | varchar(200) | NO | | NULL | | +---------+--------------+------+-----+---------+----------------+ 第三步:添加mybatis配置文件 ├── resources │ ├── mybatis-config.xml在resources目录下新建文件:mybatis-config.xml 内容如下: 第四步:添加Spring配置文件在resources/spring目录下新建三个文件: │ └── spring │ ├── spring-dao.xml │ ├── spring-service.xml │ └── spring-web.xml详细内容详见:resources/spring/ 第五步:添加logback配置文件logback配置比log4j要简单点,功能类似 ├── resources │ ├── logback.xml在resources文件夹下新建文件:logback.xml %d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n 第六步:创建DAO、entity如下两个文件:BookDao.java、Book.java │ └── com │ └── hisen │ ├── dao │ │ └── BookDao.java │ ├── entity │ │ └── Book.java详细内容:BookDao.java 详细内容:Book.java 创建测试类: 测试基类:查看代码BaseTest.java BookDao:查看代码BookDaoTest.java 测试:addBook (由于没有预先准备数据,所以就先添加) 20:12:26.674 [main] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@7b7fdc8] will not be managed by Spring 20:12:26.709 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.777 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着0(String), 100(Integer), 描述0(String) 20:12:26.783 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.794 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着1(String), 101(Integer), 描述1(String) 20:12:26.798 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.799 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着2(String), 102(Integer), 描述2(String) 20:12:26.804 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.805 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着3(String), 103(Integer), 描述3(String) 20:12:26.810 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.812 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着4(String), 104(Integer), 描述4(String) 20:12:26.816 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.818 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着5(String), 105(Integer), 描述5(String) 20:12:26.822 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.825 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着6(String), 106(Integer), 描述6(String) 20:12:26.830 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.832 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着7(String), 107(Integer), 描述7(String) 20:12:26.836 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.837 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着8(String), 108(Integer), 描述8(String) 20:12:26.842 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: INSERT INTO book(`book_id`, `name`, `number`,`detail`) VALUES(?, ?, ?, ?) 20:12:26.843 [main] DEBUG com.hisen.dao.BookDao.addBook - ==> Parameters: 0(Long), 活着9(String), 109(Integer), 描述9(String) 20:12:26.848 [main] DEBUG com.hisen.dao.BookDao.addBook - Preparing: SELECT book_id, name, number, detail FROM book WHERE book_id = ? 20:15:04.047 [main] DEBUG com.hisen.dao.BookDao.queryById - ==> Parameters: 101(Long) 20:15:04.076 [main] DEBUG com.hisen.dao.BookDao.queryById - Preparing: SELECT book_id, name, number, detail FROM book WHERE book_id = ? 20:19:58.974 [main] DEBUG com.hisen.dao.BookDao.queryById - ==> Parameters: 101(Long) 20:19:59.004 [main] DEBUG com.hisen.dao.BookDao.queryById - |
CopyRight 2018-2019 实验室设备网 版权所有 |