一、工具准备
1.maven 版本maven-3.8.2
2.tomcat 版本tomcat-8.5.65
3.数据库 版本 8.0.24
4.数据库源采用的是c3p0 版本0.9.5.2
二、数据库建表语
注释:可以在小海豚里面顺序执行下面的sql语句。
CREATE DATABASE ssmbuild;
USE ssmbuild;
CREATE TABLE books(
bookId INT(10) PRIMARY KEY NOT NULL AUTO_INCREMENT COMMENT '书ID',
bookName VARCHAR(100) NOT NULL COMMENT '书名',
bookCount INT(11) NOT NULL COMMENT '数量',
detail VARCHAR(100) NOT NULL COMMENT '描述'
)ENGINE=INNODB DEFAULT CHARSET = utf8
INSERT INTO books (bookName,bookCount,detail) VALUES
("JAVA",1,"从入门到放弃"),
("Mysql",10,"从删库到跑路"),
("Linux",5,"从入门到入狱");
三、创建项目
到此maven项目基本上创建成功,下面就是引包,因为我们是通过模板的方式创建的maven工程,里面的webapp-->WEB-INF-->web.xml里面的约束不太好,需要采用4.0版本的,因此需要进行下面的操作(需要将pom里面用不到清理干净):
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>org.example</groupId>
<artifactId>****</artifactId> <!--自己的项目名-->
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
</properties>
<dependencies>
<!--junit测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--数据库连接驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.24</version>
</dependency>
<!--c3p0数据库源-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!--servlet+jsp-->
<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>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!--mybatis整合spring-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.2</version>
</dependency>
<!--spring框架-->
<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.12</version>
</dependency>
</dependencies>
</project>
接下来就是将webapp-->WEB-INF-->web.xml的约束修改操作
如果是下面的路径的地址,直接在上面的对话框中选中ok,然后保存(apply)即可。
点击web.xml出现下面的画面,说明我们更换webxml(即就是上述操作完全正确)
maven的框架大概如下图所示(若缺少main下面的java和resource的话,可以右击main选中new --->directory进行创建):
出现下面的maven框架的话,就说明maven项目已经构建成功。
四、xml文件配置
首先我们要搞清楚 ssm框架有那些,具体是做什么用的,下面我简单说一哈作用:
spring:是mybatis和springmvc的粘合剂,是业务层主要的代码区域
springmvc:主要是视图控制,就是java代码里面的controller
mybatis:是对持久层(dao层/数据库)进行操作的。
搞清楚上述的作用后我们就知道该怎么配合xml的大概思路哦。
(1)web.xml文件配置
这里面主要干了二件事情,第一件事情是对字符进行编码设置,第二件事情是设置中央处理器(并且需要指定项目启动时,必须加载的核心文件<paramvalue>classpath:applicationContext.xml</param-value>)
<?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">
<!--encodingFilter-->
<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>
<!--DispatcherServlet-->
<servlet>
<servlet-name>dispatcherServlet</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>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
(2)spring-dao.xml文件配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
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/context https://www.springframework.org/schema/context/spring-context.xsd">
<!--导入外部的配置文件-->
<context:property-placeholder location="classpath:database.properties"/>
<!--扫描service 的bean-->
<context:component-scan base-package="com.fan">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--配置数据源C3P0-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--配置SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--注入数据库连接池-->
<property name="dataSource" ref="dataSource"/>
<!--配置mybatis 的核心配置文件-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!--配置扫描dao接口的包-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--注入 SqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<property name="basePackage" value="com.fan.dao"/>
</bean>
<!--在service里面注入dao层对象-->
<bean id="bookServiceImpl" class="com.fan.service.BookServiceImpl">
<property name="bookMapper" ref="bookMapper"/>
</bean>
<!--开启事务-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
</beans>
mybatis的配置文件
<?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>
<typeAliases>
<package name="com.fan.entity"/>
</typeAliases>
<mappers>
<mapper resource="com/fan/dao/BookMapper.xml"/>
</mappers>
</configuration>
(3)spring-mvc.xml文件配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
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 https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<!--注解驱动-->
<mvc:annotation-driven/>
<!--静态资源处理-->
<mvc:default-servlet-handler/>
<!--对controller层进行扫描-->
<context:component-scan base-package="com.fan.controller" use-default-filters="false">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
<property name="prefix" value="/WEB-INF/views/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
(4)applicationContext.xml文件配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
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">
<import resource="spring-dao.xml"/>
<import resource="spring-mvc.xml"/>
</beans>
(5)database.properties文件配置(数据库要写自己的)
jdbc.driver = com.mysql.cj.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/ssmbuild?characterEncoding=utf8&useSSL=true
jdbc.username=root
jdbc.password=123456
至此spring的配置完全结束。
接下来就是java代码和前端的书写,我把其中比较重要的步骤写一哈,其他都是粘贴复制即可。整体的项目创建如下所示:
(1)controller层的代码
package com.fan.controller;
import com.fan.entity.Books;
import com.fan.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.List;
@Controller
@RequestMapping("/book")
public class BooksController {
@Autowired
@Qualifier("bookServiceImpl")
private BookService bookService;
@RequestMapping("/allBook")
public String list(Model model){
List<Books> books = bookService.queryAllList();
model.addAttribute("list",books);
return "allBook";
}
// 这个方法的作用就是 跳转页面
@RequestMapping("/toAddPage")
public String toAddPage(){
return "addBook";
}
@RequestMapping("/addBook")
public String addBook(Books books,Model model){
int i = bookService.addBook(books);
if (i>0){
return "redirect:/book/allBook";
}else {
model.addAttribute("mess","添加失败");
return "addBook";
}
}
@RequestMapping("/delete/{bookId}")
public String delete(@PathVariable("bookId") int id){
bookService.deleteBookById(id);
return "redirect:/book/allBook";
}
@RequestMapping("/toUpdatePage")
public String toUpdatePage(Model model,int bookID){
Books books = bookService.queryBookById(bookID);
model.addAttribute("book",books);
return "update";
}
@RequestMapping("/update")
public String update(Books books){
int i = bookService.updateBook(books);
return "redirect:/book/allBook";
}
}
(2)dao层的代码
package com.fan.dao;
import com.fan.entity.Books;
import java.util.List;
public interface BookMapper {
// 增加一个book
int addBook(Books books);
// 根据id删除一个book
int deleteBookById(int id);
// 更新Book
int updateBook(Books books);
// 根据ID 返回一个Book
Books queryBookById(int id);
// 查询所有的Book
List<Books> queryAllList();
}
(3)entity层的代码
package com.fan.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
private int bookID;
private String bookName;
private int bookCount;
private String detail;
}
(4)service层的代码
package com.fan.service;
import com.fan.entity.Books;
import java.util.List;
public interface BookService {
// 增加一个book
int addBook(Books books);
// 根据id删除一个book
int deleteBookById(int id);
// 更新Book
int updateBook(Books books);
// 根据ID 返回一个Book
Books queryBookById(int id);
// 查询所有的Book
List<Books> queryAllList();
}
package com.fan.service;
import com.fan.dao.BookMapper;
import com.fan.entity.Books;
import java.util.List;
public class BookServiceImpl implements BookService {
private BookMapper bookMapper;
// 作用 : 为后面的Spring 在注入 bookMapper 做准备
public void setBookMapper(BookMapper bookMapper) {
this.bookMapper = bookMapper;
}
@Override
public int addBook(Books books) {
return bookMapper.addBook(books);
}
@Override
public int deleteBookById(int id) {
return bookMapper.deleteBookById(id);
}
@Override
public int updateBook(Books books) {
return bookMapper.updateBook(books);
}
@Override
public Books queryBookById(int id) {
return bookMapper.queryBookById(id);
}
@Override
public List<Books> queryAllList() {
return bookMapper.queryAllList();
}
}
比较重要的一步:在resource里面创建(相当于BookMapper的实现)记住是文件的格式(需要有层级)
在文件框里面输入:com/fan/dao/BookMapper.xml(就是要跟dao层的路径格式一样)
在这里面就是mybatis的sql,代码如下(注意点:namespace 要指定自己dao):
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fan.dao.BookMapper">
<!--// 增加一个book-->
<insert id="addBook" parameterType="books">
insert into books(bookname,bookcount,detail)
values (#{bookName},#{bookCount},#{detail})
</insert>
<!-- 根据id删除一个book deleteBookById-->
<delete id="deleteBookById" parameterType="int">
delete from books where bookid = #{bookID}
</delete>
<!-- // 更新Book-->
<update id="updateBook" parameterType="books">
update books set bookname=#{bookName},bookcount=#{bookCount},detail=#{detail}
where bookid = #{bookID}
</update>
<!-- // 根据ID 返回一个Book-->
<select id="queryBookById" resultType="books">
select * from books where bookId = #{bookID}
</select>
<!-- // 根据ID 返回一个Book-->
<select id="queryAllList" resultType="books">
select * from books
</select>
</mapper>
五、测试结果
(1)查询功能
点击如下按钮,应该返回数据库里面所有书籍的信息
结果如下:
(2)添加功能
点击新增按钮,出现以下画面。
成功画面:
(3)删除功能(就删除刚才新添加的书籍)
成功画面(对准上图的点击删除即可):
(4)修改功能
点击修改链接后,应该进入如下画面(我们修改书籍数量):
成功画面,我们看到书籍数量已经成功修改过来了: