1.导入pom依赖(静态资源导出问题)
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>cn.qqa</groupId>
<artifactId>ssmbuild1</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<!--1.spring-->
<!--aop织入-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.4</version>
</dependency>
<!--2.mybatis-->
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!--mysql数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<!--spring-jdbc-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.6.RELEASE</version>
</dependency>
<!--mybatis-spring-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.6</version>
</dependency>
<!--*******************************日志:导入logbackjar包-->
<!-- https://mvnrepository.com/artifact/ch.qos.logback/logback-classic -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.30</version>
</dependency>
<!--*******************************单元测试:junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--分页插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.2.0</version>
</dependency>
<!--3.springmvc-->
<!--spring-mvc-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.6.RELEASE</version>
</dependency>
<!--json,jackson-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.11.0</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.11.0</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.11.0</version>
</dependency>
<!--数据验证-->
<dependency>
<groupId>org.hibernate.validator</groupId>
<artifactId>hibernate-validator</artifactId>
<version>6.1.5.Final</version>
</dependency>
<!--*******************jstl-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
</dependencies>
<!--解决静态资源导出问题-->
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
</project>
2.设置为web项目
3.配置tomcat(将jar包导入tomcat,每次加入新的依赖都要导入)
4.编写配置文件
(1)web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!--1.servlet-->
<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>
<!--tomcat启动时加载,而不是每次请求加载(重量级)-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--中文乱码过滤器-->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<!--编码格式为utf-8-->
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
<!--返回response也过滤-->
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
(2)applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<import resource="classpath:spring-dao.xml"/>
<import resource="classpath:spring-mvc.xml"/>
<import resource="classpath:spring-service.xml"/>
<!--扫描包,注入注解-->
<context:component-scan base-package="cn.qqa"/>
</beans>
(3)db.properties
# 不加引号
jdbc.Driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?serverTimezone=UTC
jdbc.username=root
jdbc.password=521.james
(4)mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--********************************mybatis配置文件,表明使用了mybatis-->
<!--********************************日志配置-->
<!-- <settings>
<setting name="logImpl" value="log4j"/>
</settings>-->
<!--配置蛇形命名(hello_world)到驼峰命名(helloWorld)的映射-->
<settings>
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<!--别名-->
<typeAliases>
<package name="cn.qqa.pojo"/>
</typeAliases>
<!--映射器-->
<mappers>
<package name="cn.qqa.mapper"/>
</mappers>
</configuration>
(5)spring-dao.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!--数据库属性文件位置-->
<context:property-placeholder location="classpath:db.properties"/>
<!--数据源-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.Driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--sqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="classpath:mybatis-config.xml"/>
<!-- <property name="mapperLocations" value="classpath:cn/qqa/mapper/*.xml"/>-->
</bean>
<!--注册xxxMapper实现类-->
<bean id="booksMapper" class="cn.qqa.mapper.BooksMapperImpl">
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
</beans>
(6)spring-service.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!--**********扫描service下的包-->
<context:component-scan base-package="cn.qqa.service"/>
<!--配置事务管理类-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--事务-->
<tx:advice id="txAdvie" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice>
<!--事务织入-->
<aop:config>
<aop:pointcut id="pointCut" expression="execution(* cn.qqa.mapper.*.*(..))"/>
<aop:advisor advice-ref="txAdvie" pointcut-ref="pointCut"/>
</aop:config>
<!--****************将所有的业务类,注入到spring,可以通过配置或者注解实现-->
<bean id="bookServie" class="cn.qqa.service.BookServiceImpl">
</bean>
</beans>
(7)spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="cn.qqa.controller"/>
<!--注解驱动,json中文乱码-->
<mvc:annotation-driven>
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<constructor-arg value="utf-8"/>
</bean>
<bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="objectMapper">
<bean class="org.springframework.http.converter.json.Jackson2ObjectMapperFactoryBean">
<property name="failOnEmptyBeans" value="false"/>
</bean>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!--2.静态资源过滤,视图控制器,直接访问-->
<mvc:default-servlet-handler />
<!--
<mvc:view-controller path="/*.jsp" view-name=""/>
-->
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
错误:
(1)db.properties:不用加引号
(2)pointcut:execution(* cn.qqa.mapper.*.*(..)),结尾有两个括号
(3)使用slf4j时不用配置logImpl
(4)xxxMapper.xml放在了resource文件夹
(5)mapperLocations:<property name="mapperLocations" value="classpath:cn/qqa/mapper/*.xml"/>
与mybtis-config.xml:<mappers> <package name="cn.qqa.mapper"/> </mappers>重复
(6)applicationContext.xml:<import resource="classpath:spring-mvc.xml"/>
5.编写pojo层
(1)Books
package cn.qqa.pojo;
import java.io.Serializable;
public class Books implements Serializable {
//图书编号
private Integer bookId;
//图书名字
private String bookName;
//图书数量
private Integer bookCounts;
//图书描述
private String detail;
public Books() {
}
public Books(Integer bookId, String bookName, Integer bookCounts, String detail) {
this.bookId = bookId;
this.bookName = bookName;
this.bookCounts = bookCounts;
this.detail = detail;
}
public Integer getBookId() {
return bookId;
}
public void setBookId(Integer bookId) {
this.bookId = bookId;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public Integer getBookCounts() {
return bookCounts;
}
public void setBookCounts(Integer bookCounts) {
this.bookCounts = bookCounts;
}
public String getDetail() {
return detail;
}
public void setDetail(String detail) {
this.detail = detail;
}
@Override
public String toString() {
return "Books{" +
"bookId=" + bookId +
", bookName='" + bookName + '\'' +
", bookCounts=" + bookCounts +
", detail='" + detail + '\'' +
'}';
}
}
6.编写Mapper(Dao)层
(1)BooksMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.qqa.mapper.BooksMapper">
<!--增-->
<insert id="addBook" parameterType="Books">
insert into books(book_name, book_counts, detail)
values(#{bookName},#{bookCounts},#{detail})
</insert>
<!--删-->
<delete id="deleteBookById" parameterType="int">
delete from books
where book_id = #{bookId}
</delete>
<!--改-->
<update id="updateBook" parameterType="Books">
update books
set book_name = #{bookName},book_counts = #{bookCounts},detail = #{detail}
where book_id = #{bookId}
</update>
<!--查-->
<select id="selectBookById" resultType="Books">
select * from books
where book_id = #{bookId}
</select>
<!--查全部-->
<select id="selectAllBook" resultType="Books">
select * from books
</select>
</mapper>
(2)BooksMapper.java
package cn.qqa.mapper;
import cn.qqa.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BooksMapper {
//添加图书
public Integer addBook(Books books);
//删除图书
public Integer deleteBookById(@Param("bookId") Integer bookId);
//修改图书
public Integer updateBook(Books books);
//通过id查询图书
public Books selectBookById(@Param("bookId") Integer bookId);
//查询全部图书
public List<Books> selectAllBook();
}
(3)BooksMapperImpl.java
package cn.qqa.mapper;
import cn.qqa.pojo.Books;
import org.apache.ibatis.logging.LogFactory;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.util.List;
public class BooksMapperImpl extends SqlSessionDaoSupport implements BooksMapper {
Logger logger = LoggerFactory.getLogger(this.getClass());
public Integer addBook(Books books) {
return getSqlSession().getMapper(BooksMapper.class).addBook(books);
}
public Integer deleteBookById(Integer bookId) {
return getSqlSession().getMapper(BooksMapper.class).deleteBookById(bookId);
}
public Integer updateBook(Books books) {
return getSqlSession().getMapper(BooksMapper.class).updateBook(books);
}
public Books selectBookById(Integer bookId) {
return getSqlSession().getMapper(BooksMapper.class).selectBookById(bookId);
}
public List<Books> selectAllBook() {
return getSqlSession().getMapper(BooksMapper.class).selectAllBook();
}
}
7.编写Service层
(1)BookService.java
package cn.qqa.service;
import cn.qqa.pojo.Books;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public interface BookService {
//添加图书
public Integer addBook(Books books);
//删除图书
public Integer deleteBookById( Integer bookId);
//修改图书
public Integer updateBook(Books books);
//通过id查询图书
public Books selectBookById(Integer bookId);
//查询全部图书
public List<Books> selectAllBook();
}
(2)BookServiceImpl.java
package cn.qqa.service;
import cn.qqa.mapper.BooksMapper;
import cn.qqa.pojo.Books;
import org.springframework.beans.factory.annotation.Autowired;
import java.util.List;
public class BookServiceImpl implements BookService {
//service层调dao层
@Autowired
private BooksMapper booksMapper;
public Integer addBook(Books books) {
return booksMapper.addBook(books);
}
public Integer deleteBookById(Integer bookId) {
return booksMapper.deleteBookById(bookId);
}
public Integer updateBook(Books books) {
return booksMapper.updateBook(books);
}
public Books selectBookById(Integer bookId) {
return booksMapper.selectBookById(bookId);
}
public List<Books> selectAllBook() {
return booksMapper.selectAllBook();
}
}
8.编写Controller层与前端页面
(1)show.jsp
删除本来想用ajax,但是还是得发一次请求,难道在回调函数中再写一个ajax还是不行,放弃。
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%--
Created by IntelliJ IDEA.
User: lenovo
Date: 2021/3/29
Time: 10:48
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>展示图书界面</title>
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
<%--<script src="${pageContext.request.contextPath}/static/js/jquery-3.6.0.js"></script>--%>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script>
function del(){
var id = document.getElementById("idtd").value;
console.log(id);
var toUrl = "${pageContext.request.contextPath}/deleteBookByAjax/"+id;
alert(toUrl);
$.post({
url:toUrl,
data:{'msg':'hello'},
success:function (data) {
alert(data);
}
});
};
function del1(){
var id = document.getElementById("idtd").value;
console.log(id);
var toUrl = "${pageContext.request.contextPath}/deleteBookByAjax/"+id;
alert(toUrl);
$.post({
url:toUrl,
data:{'msg':'hello'},
success:function (data) {
//alert(data);
$.post({
url:"${pageContext.request.contextPath}/toShow",
success:function () {
}
});
}
});
}
</script>
</head>
<body>
<a class="button" href="${pageContext.request.contextPath}/addBook">添加图书</a>
<br>
<table >
<thead>
<tr>
<td>书名</td>
<td>存量</td>
<td>描述</td>
<td>操作</td>
</tr>
</thead>
<tbody>
<c:forEach items="${list}" var="item">
<tr>
<form><input id="idtd" type="hidden" value="${item.bookId}"/></form>
<td>${item.bookName}</td>
<td>${item.bookCounts}</td>
<td>${item.detail}</td>
<td>
<a href="${pageContext.request.contextPath}/updateBook?id=${item.bookId}" >修改</a>
<span><a style="margin-left: 20px;" href="${pageContext.request.contextPath}/deleteBook/${item.bookId}" >删除</a></span>
<button onclick="del()">删除ajax</button>
<button onclick="del1()">删除ajax1</button>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
(2)BookController.java
delete使用了REST风格
package cn.qqa.controller;
import cn.qqa.pojo.Books;
import cn.qqa.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
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 javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
@Controller
public class BookController {
//controller层调用service层
@Autowired
private BookService bookService;
@RequestMapping("/toShow")
public String toShow(Model model){
List<Books> books = bookService.selectAllBook();
//System.out.println(books);
model.addAttribute("list",books);
return "show";
}
@RequestMapping("/addBook")
public String addBook(Model model){
return "addBook";
}
@RequestMapping("/runAddBook")
public String runAddBook(Books books){
bookService.addBook(books);
return "redirect:/toShow";
}
@RequestMapping("/updateBook")
public String updateBook(Integer id,Model model){
Books books = bookService.selectBookById(id);
model.addAttribute("obj",books);
return "updateBook";
}
@RequestMapping("/runUpdateBook")
public String runUpdateBook(Books books){
bookService.updateBook(books);
return "redirect:/toShow";
}
@RequestMapping("/deleteBook/{id}")
public String deleteBook(@PathVariable("id") Integer id){
bookService.deleteBookById(id);
return "redirect:/toShow.action";
}
@RequestMapping("/deleteBookByAjax/{id}")
public void deleteBookByAjax(@PathVariable("id") Integer id,String msg, HttpServletResponse response) throws IOException {
System.out.println(msg);
Integer integer = bookService.deleteBookById(id);
if(integer>0){
response.getWriter().print("删除成功!");
}else {
response.getWriter().print("删除失败!");
}
}
}
(3)addBook.jsp
<%--
Created by IntelliJ IDEA.
User: lenovo
Date: 2021/3/29
Time: 14:45
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>添加图书</title>
</head>
<body>
<form action="${pageContext.request.contextPath}/runAddBook" method="post">
<p>
书名:<input type="text" name="bookName" placeholder="请输入书名" required/>
</p>
<p>
存量:<input type="text" name="bookCounts" placeholder="请输入存量" required/>
</p>
<p>
描述:<input type="text" name="detail" placeholder="请输入描述"/>
</p>
<p>
<input type="submit" value="添加"/>
</p>
</form>
</body>
</html>
(4)updateBook.jsp
<%--
Created by IntelliJ IDEA.
User: lenovo
Date: 2021/3/29
Time: 14:45
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>添加图书</title>
</head>
<body>
<form action="${pageContext.request.contextPath}/runUpdateBook" method="post">
<input type="hidden" name="bookId" value="${obj.bookId}"/>
<p>
书名:<input type="text" name="bookName" value="${obj.bookName}"/>
</p>
<p>
存量:<input type="text" name="bookCounts" value="${obj.bookCounts}" />
</p>
<p>
描述:<input type="text" name="detail" value="${obj.detail}"/>
</p>
<p>
<input type="submit" value="修改"/>
</p>
</form>
</body>
</html>
5.ajax易犯错误
一定注意不要把js写成EL表达式,不要把$()写成${}!!!!