文章目录
一、数据库搭建1、环境要求2、数据库环境 二、基本环境搭建1、新建maven项目2、导入pom依赖3、Maven资源过滤设置4、建立基本结构和框架 三、MyBatis层1、数据库配置文件2、IDEA关联数据库3、编写MyBatis的核心配置文件4、编写数据库对应的实体类5、编写Dao层的 Mapper接口6、编写接口对应的 Mapper.xml 文件7、编写Service层的接口和实现类 四、Spring层1、Spring整合MyBatis层2、Spring整合Service层3、Spring整合MVC层4、Spring配置整合文件5、web.xml 五、Controller 和 视图层1、BookController 类编写2、创建web3、编写首页4、书籍列表页面5、添加书籍页面6、修改书籍页面7、删除书籍功能 六、配置Tomcat,进行运行一、数据库搭建
1、环境要求
IDEAMySQL 5.7.19Tomcat 9Maven2、数据库环境
在ssmbuild数据库创建存放书籍数据的数据库表
CREATE DATABASE `ssmbuild`;USE `ssmbuild`;DROP TABLE IF EXISTS `books`;CREATE TABLE `books` (`bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id',`bookName` VARCHAR(100) NOT NULL COMMENT '书名',`bookCounts` INT(11) NOT NULL COMMENT '数量',`detail` VARCHAR(200) NOT NULL COMMENT '描述',KEY `bookID` (`bookID`)) ENGINE=INNODB DEFAULT CHARSET=utf8INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES (1,'Java',1,'从入门到放弃'),(2,'MySQL',10,'从删库到跑路'),(3,'Linux',5,'从进门到进牢');
二、基本环境搭建
1、新建maven项目
2、导入pom依赖
<dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.47</version></dependency><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>servlet-api</artifactId><version>2.5</version></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.2</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.2</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.2</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.1.9.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.1.9.RELEASE</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.10</version></dependency><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.8.13</version></dependency></dependencies>
3、Maven资源过滤设置
<!--在build中配置resources,来防止我们资源导出失败的问题--><build><resources><resource><directory>src/main/resources</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>true</filtering></resource><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>true</filtering></resource></resources></build>
4、建立基本结构和框架
mybatis-config.xml<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-////DTD Config 3.0//EN""/dtd/mybatis-3-config.dtd"><configuration></configuration>
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd"></beans>
项目所需的基本环境已经搭建好了
三、MyBatis层
1、数据库配置文件
database.properties
jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=UTF-8jdbc.username=rootjdbc.password=147258
2、IDEA关联数据库
3、编写MyBatis的核心配置文件
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-////DTD Config 3.0//EN""/dtd/mybatis-3-config.dtd"><configuration><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings><typeAliases><package name="com.shu.pojo"/></typeAliases><mappers><mapper class="com.shu.dao.BookMapper"/></mappers></configuration>
4、编写数据库对应的实体类
使用lombok插件
com.kuang.pojo.Books
package com.shu.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;@Data@AllArgsConstructor@NoArgsConstructorpublic class Books {private int bookID;private String bookName;private int bookCounts;private String detail;}
5、编写Dao层的 Mapper接口
package com.shu.dao;import com.shu.pojo.Books;import com.shu.pojo.Users;import org.apache.ibatis.annotations.Param;import java.util.List;public interface BookMapper {//增加一本书int addBook(Books books);//删除一本书int deleteBookById(@Param("bookId") int id);//修改一本书int updateBook(Books books);//查询一本书Books queryBookById(@Param("bookId") int id);//查询所有书List<Books> queryAllBook();//通过书名查询Books queryBookByName(@Param("bookName") String bookName);}
6、编写接口对应的 Mapper.xml 文件
需要导入MyBatis的包
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapperPUBLIC "-////DTD Config 3.0//EN""/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.shu.dao.BookMapper"><!--添加书籍--><insert id="addBook" parameterType="Books">insert into books(bookName,bookCounts,detail) values (#{bookName},#{bookCounts},#{detail})</insert><!--通过书籍ID删除书籍--><delete id="deleteBookById" parameterType="int">delete from books where bookID=#{bookId}</delete><!--修改书籍信息--><update id="updateBook" parameterType="Books">update booksset bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}where bookID=#{bookID}</update><!--通过书籍ID查询书籍--><select id="queryBookById" resultType="Books">select * from bookswhere bookID=#{bookId}</select><!--查询所有书籍--><select id="queryAllBook" resultType="Books">select * from books</select><!--通过书名查询书籍--><select id="queryBookByName" resultType="Books">select * from bookswhere bookName=#{bookName}</select></mapper>
7、编写Service层的接口和实现类
接口:
package com.shu.service;import com.shu.pojo.Books;import java.util.List;public interface BookService {//增加一本书int addBook(Books books);//删除一本书int deleteBookById( int id);//修改一本书int updateBook(Books books);//查询一本书Books queryBookById(int id);//查询所有书List<Books> queryAllBook();Books queryBookByName(String bookName);}
实现类:
package com.shu.service;import com.shu.dao.BookMapper;import com.shu.pojo.Books;import java.util.List;public class BookServiceImpl implements BookService{//service调dao层 组合dao层private BookMapper bookMapper;public void setBookMapper(BookMapper bookMapper) {this.bookMapper = bookMapper;}//增加书籍public int addBook(Books books) {return bookMapper.addBook(books);}//通过书籍ID删除public int deleteBookById(int id) {return bookMapper.deleteBookById(id);}//修改书籍public int updateBook(Books books) {return bookMapper.updateBook(books);}//通过书籍id查询书籍public Books queryBookById(int id) {return bookMapper.queryBookById(id);}//查询所有书籍public List<Books> queryAllBook() {return bookMapper.queryAllBook();}//通过书籍名查询书籍public Books queryBookByName(String bookName){return bookMapper.queryBookByName(bookName);}}
底层需求操作编写成。
四、Spring层
1、Spring整合MyBatis层
我们这里数据源使用c3p0连接池
spring-dao.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd/schema/context/schema/context/spring-context.xsd"><context:property-placeholder location="classpath:database.properties"/><bean id="dataSource" class="com.mchange.boPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><property name="maxPoolSize" value="30"/><property name="minPoolSize" value="10"/><property name="autoCommitOnClose" value="false"/><property name="checkoutTimeout" value="10000"/><property name="acquireRetryAttempts" value="2"/></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><property name="configLocation" value="classpath:mybatis-config.xml"/></bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><property name="basePackage" value="com.shu.dao"/></bean></beans>
2、Spring整合Service层
spring-service.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xmlns:tx="/schema/tx" xmlns:aop="/schema/aop"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd/schema/context/schema/context/spring-context.xsd/schema/tx/schema/tx/spring-tx.xsd /schema/aop /schema/aop/spring-aop.xsd"><context:component-scan base-package="com.shu.service"/><bean id="BookServiceImpl" class="com.shu.service.BookServiceImpl"><property name="bookMapper" ref="bookMapper"/></bean><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="*" propagation="REQUIRED"/></tx:attributes></tx:advice><aop:config><aop:pointcut id="txPointCut" expression="execution(* com.shu.dao.*.*(..))"/><aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/></aop:config></beans>
3、Spring整合MVC层
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:mvc="/schema/mvc"xmlns:context="/schema/context"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd/schema/mvc/schema/mvc/spring-mvc.xsd/schema/context/schema/context/spring-context.xsd"><mvc:annotation-driven/><mvc:default-servlet-handler/><context:component-scan base-package="com.shu.controller"/><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp/"/><property name="suffix" value=".jsp"/></bean></beans>
4、Spring配置整合文件
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd"><import resource="classpath:spring-dao.xml"/><import resource="classpath:spring-service.xml"/><import resource="classpath:spring-mvc.xml"/></beans>
5、web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="/xml/ns/javaee"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/javaee /xml/ns/javaee/web-app_4_0.xsd"version="4.0"><servlet><servlet-name>springmvc</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>springmvc</servlet-name><url-pattern>/</url-pattern></servlet-mapping><filter><filter-name>encodingFilter</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><init-param><param-name>encoding</param-name><param-value>utf-8</param-value></init-param></filter><filter-mapping><filter-name>encodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><session-config><session-timeout>15</session-timeout></session-config></web-app>
Spring层配置文件完成
五、Controller 和 视图层
1、BookController 类编写
package com.shu.controller;import com.shu.pojo.Books;import com.shu.service.BookService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import java.util.ArrayList;import java.util.List;@Controller@RequestMapping("/book")public class BookController {// controller层调service层@Autowired@Qualifier("BookServiceImpl")private BookService bookService;// 查询所有书籍,并返回到一个书籍展示页面@RequestMapping("/allBook") //走book.allBook就能走到这个方法里面public String list(Model model){List<Books> list = bookService.queryAllBook(); //查询书籍model.addAttribute("list",list);//将得到的数据返回到前端展示return "allBook";}// 跳转到添加书籍页面@RequestMapping("/toAddBook")public String toAddPaper(){return "addBook";}// 添加书籍请求@RequestMapping("/addBook")public String addBook(Books books){bookService.addBook(books);return "redirect:/book/allBook"; //重定向到我们的 @RequestMapping("/allBook")}// 跳转到修改页面@RequestMapping("/toUpdateBook")public String toUpdatePaper(int id,Model model){Books books = bookService.queryBookById(id);model.addAttribute("QBooks",books);return "updateBook";}//修改书籍@RequestMapping("/updateBook")public String updateBook(Books books){System.out.println("updateBook=>"+books);bookService.updateBook(books);return "redirect:/book/allBook";}// 删除书籍@RequestMapping("/deleteBook/{bookId}")public String deleteBook(@PathVariable("bookId") int id){bookService.deleteBookById(id);return "redirect:/book/allBook";}// 查询书籍@RequestMapping("/queryBook")public String queryBook(String queryBookName,Model model){Books books = bookService.queryBookByName(queryBookName);List<Books> list=new ArrayList<Books>();list.add(books);if (books==null){list=bookService.queryAllBook();model.addAttribute("error","未查到");}model.addAttribute("list",list);return "allBook";}}
2、创建web
在项目文件处右击鼠标,点击Add Framework Supprot…
勾选Web Application,点击OK按键
web文件显示有蓝点说明操作成功
在web.WEB-INF文件夹中创建jsp文件夹,用于编写前端页面
3、编写首页
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>首页</title><style>a{text-decoration: none;color: white;font-size: 40px;}body{background-color: darkcyan;}h3{width: 180px;height: 180px;margin: 280px auto;text-align: center;line-height: 180px;background: darkgray;border-radius: 50px;box-shadow: 10px 10px #696969;border: 1px ;}</style></head><body><h3><a href="${pageContext.request.contextPath}/book/allBook">书籍页面</a></h3></body></html>
4、书籍列表页面
allbook.jsp
<%@ taglib prefix="c" uri="/jsp/jstl/core" %><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>书籍展示</title><link href="/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head><body><div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>书籍列表----显示所有数据</small></h1></div></div><div class="row"><div class="col-md-4 column"><form class="form-inline" action="${pageContext.request.contextPath}/book/queryBook" method="post"><span style="color: red;font-weight: bold;">${error}</span><input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称"><input type="submit" value="查询" class="btn btn-primary"></form></div><div class="form-inline"><%--pageContext.request.contextPath}是JSP取得绝对路径的方法--%><a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook" style="float:right">新增书籍</a></div></div></div><div class="row clearfix"><div class="col-md-12 column"><table class="table table-hover table-striped"><thead><tr><th>书籍名称</th><th>书籍数量</th><th>书籍详情 </th><th>操作</th></tr></thead><tbody><c:forEach var="book" items="${list}"><tr><td>${book.bookName}</td><td>${book.bookCounts}</td><td>${book.detail}</td><td><a href="${pageContext.request.contextPath}/book/toUpdateBook?id=${book.bookID}">修改</a> | <a href="${pageContext.request.contextPath}/book/deleteBook/${book.bookID}">删除</a></td></tr></c:forEach></tbody></table></div></div></div></body></html>
5、添加书籍页面
addBook.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>Title</title><link href="/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head><body><div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>新增书籍</small></h1></div></div></div><form action="${pageContext.request.contextPath}/book/addBook" method="post"><div class="form-group"><label>书籍名称</label><input type="text" name="bookName" class="form-control" required></div><div class="form-group"><label>书籍数量</label><input type="text" name="bookCounts" class="form-control" required></div><div class="form-group"><label>书籍详情</label><input type="text" name="detail" class="form-control" required></div><div class="form-group"><input type="submit" class="btn btn-primary" value="添加"></div></form></div></body></html>
6、修改书籍页面
updateBook.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>Title</title><link href="/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head><body><div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>修改书籍</small></h1></div></div></div><form action="${pageContext.request.contextPath}/book/updateBook" method="post"><input type="hidden" name="bookID" value="${QBooks.bookID}"><div class="form-group"><label>书籍名称</label><input type="text" name="bookName" class="form-control" value="${QBooks.bookName}" required></div><div class="form-group"><label>书籍数量</label><input type="text" name="bookCounts" class="form-control" value="${QBooks.bookCounts}" required></div><div class="form-group"><label>书籍详情</label><input type="text" name="detail" class="form-control" value="${QBooks.detail}" required></div><div class="form-group"><input type="submit" class="form-control" value="修改"></div></form></div></body></html>
7、删除书籍功能
写Dao层接口
BookMapper.java
//删除一本书int deleteBookById(@Param("bookId") int id);
写出查询数据的sql语句
通过mapper namespace="com.shu.dao.BookMapper"绑定到BookMapper接口
BookMapper.xml
<delete id="deleteBookById" parameterType="int">delete from books where bookID=#{bookId}</delete>
写Service层接口
BookService.java
//删除一本书int deleteBookById( int id);
写实现类
BookServiceImpl
public int deleteBookById(int id) {return bookMapper.deleteBookById(id);}
在BookController中写实现方法
BookController.java
通过controller层调service层
// controller层调service层@Autowired@Qualifier("BookServiceImpl")private BookService bookService;
删除书籍方法
// 删除书籍@RequestMapping("/deleteBook/{bookId}")public String deleteBook(@PathVariable("bookId") int id){bookService.deleteBookById(id); return "redirect:/book/allBook"; //完成删除之后返回到book下的allBook页面}
在前端定义删除按钮并实现功能
allBook.jsp
<a href="${pageContext.request.contextPath}/book/deleteBook/${book.bookID}">删除</a>
${pageContext.request.contextPath}是jsp中定义绝对路径的方法
${book.bookID}为点击删除之后向后台传回的bookID数据,从而可以删除指定书籍的功能
为什么要介绍删除书籍功能?
其实这是介绍了新增一个功能所有的流程,在框架搭建好之后,完成某个功能就变得异常简单,只需要在不同的模块增添新的代码即可。
六、配置Tomcat,进行运行
如果觉得《SSM框架整合超详细(狂神)》对你有帮助,请点赞、收藏,并留下你的观点哦!