SpringMVC :视图层,界面层,负责接受请求,显示处理结果的
Spring : 业务层,管理service,dao,工具类对象的
MyBatis:持久层,访问数据库的
用户发起请求 --- springMVC接受-- Spring中的Service对象--MyBatis处理数据
-
第一个容器SpringMVC容器,管理Controller控制器对象
-
第二个容器Spring容器,管理Service,dao,工具类对象,我们要把使用的对象交给合适的容器创建,管理。把controller还有还有web开发的相关对象交给Springmvc容器,这些web用的对象写在springmvc配置文件中
-
service,dao对象定义在spring的配置文件中,让spring管理这些对象
-
springmvc和spring是有关系的,springmvc是spring的子容器,类似于java中的继承。子可以访问父的内容,在自容器中的Controller可以访问父容器中的service对象,就可以实现Controller使用service对象
实现步骤
-
创建数据库
-
新建maven web项目
-
加入依赖
springmvc,spring,mybatis,三个框架的依赖,jackson,mysql,druid,jsp,servlet依赖
-
创建包,Controller包,service, dao, 实体类包
-
写springmvc,spring,mybatis的配置文件
-
springmvc配置文件
-
spring配置文件
-
mybatis配置文件
-
数据库属性配置文件
-
-
写web.xml
-
注册DispatcherServlet, 目的:(1)创建springmvc容器对象,才能创建Controller类对象。(2)创建的是servlet,才能接受用户请求
-
注册spring的监听器:ContextLoaderListener,目的:创建spring的容器对象,才能创建service, dao等对象
-
注册字符集过滤器,解决post请求乱码问题
-
-
写代码,dao接口,mapper文件,service和实现类,Controller,实体类
-
写jsp
整合代码
-
创建数据库
create table `books`( `bookid` int(10) not null primary key AUTO_INCREMENT, `bookname` varchar(100) not null, `bookCount` int(20) not null, `details` varchar(200) not null ) engine=innodb default charset=utf8; insert into books(`bookid`,`bookname`,`bookCount`,`details`) values (1,"Java",1,"从入门到放弃"), (2,"MySQL",10,"从删库到跑路"), (3,"Linux",5,"从进门到进牢");
-
新建maven web项目
-
新建maven web项目加入依赖
<dependencies> <!--单元测试依赖--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> </dependency> <!--mysql数据库驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.21</version> </dependency> <!--jstl依赖--> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.1.2</version> </dependency> <!--c3p0数据库连接池--> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <!--德鲁伊数据库连接池依赖--> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.1.10</version> </dependency> <!--servlet依赖--> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>4.0.1</version> <scope>provided</scope> </dependency> <!-- jsp依赖--> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> <scope>provided</scope> </dependency> <!-- mybatis 依赖--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.3</version> </dependency> <!-- mybatis与spring集成依赖--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.6</version> </dependency> <!-- springmvc依赖--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.3.9</version> </dependency> <!--事务依赖:--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>5.3.8</version> </dependency> <!--spring-jdbc--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.3.9</version> </dependency> </dependencies> <!--静态资源导出--> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build>
-
建包。pojo(实体类),dao,service,controller
-
写配置文件
mybatis层
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>
<!-- 数据源配置交给spring去做-->
<!-- 为实体类设置别名-->
<typeAliases>
<package name="com.example.pojo"/>
</typeAliases>
<!-- 绑定mapper-->
<mappers>
<package name="com.example.dao"/>
</mappers>
</configuration>
database.properties
jdbc.driver=com.mysql.jdbc.Driver
#mysql 8.0以上需要加入设置时区 &serverTimezone=Asia/Shanghai
jdbc.url=jdbc:mysql://localhost:3306/springdb?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=root
spring层
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"/>
<!-- 数据库连接池-->
<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="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 绑定数据源-->
<property name="dataSource" ref="dataSource"/>
<!-- 绑定mybatis配置文件-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!-- 配置dao层接口扫描包-->
<bean id="configurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 扫描dao包-->
<property name="basePackage" value="com.example.dao"/>
<!-- 注入sessionFactory-->
<property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
</bean>
</beans>
spring-service.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">
<!--spring配置文件中有关service层的配置-->
<!-- 1.扫描service下的包-->
<context:component-scan base-package="com.example.service"/>
<!-- 2.将所有service的类注入到spring中,可以使用xml,也可以有注解 , 通过注解:@service @resource-->
<!--<bean id="bookServiceImpl" class="com.example.service.bookServiceImpl">
<property name="bookMapper" ref="bookMapper"/>
</bean>-->
<!-- 3.声明式事务配置-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 4.aop事务支持-->
</beans>
springMVC层
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">
<!-- 1.注解驱动-->
<mvc:annotation-driven/>
<!-- 2.扫描包-->
<context:component-scan base-package="com.example.controller"/>
<!-- 3.静态资源过滤-->
<mvc:default-servlet-handler/>
<!-- 4.视图解析器-->
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
整合所有
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="classpath:spring-service.xml"/>
<import resource="classpath:spring-dao.xml"/>
<import resource="classpath:spring-mvc.xml"/>
</beans>
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.DispatchServlet-->
<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-->
<session-config>
<session-timeout>30</session-timeout>
</session-config>
</web-app>
实现包,类,接口
先写pojo中实体类,注意实体类的属性名应与数据库中字段名一致
Books.java
package com.example.pojo;
public class Books {
private Integer bookid;
private String bookname;
private Integer bookCount;
private String details;
public Books() {
}
public Books(Integer bookid, String bookname, Integer bookCount, String details) {
this.bookid = bookid;
this.bookname = bookname;
this.bookCount = bookCount;
this.details = details;
}
@Override
public String toString() {
return "Books{" +
"bookid=" + bookid +
", bookname='" + bookname + '\'' +
", bookCount=" + bookCount +
", details='" + details + '\'' +
'}';
}
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 getBookCount() {
return bookCount;
}
public void setBookCount(Integer bookCount) {
this.bookCount = bookCount;
}
public String getDetails() {
return details;
}
public void setDetails(String details) {
this.details = details;
}
}
写操作数据库的dao层接口和相应的mapper
bookMapper.java
package com.example.dao;
import com.example.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface bookMapper {
//查找一本书
Books queryBookById(@Param("bookId") Integer id);
//增加一本书
int addBook(Books book);
//删除一本书
int deleteBookById(@Param("bookId") Integer id);
//更新一本书
int updateBook(Books book);
//查找所有书
List<Books> queryAllBooks();
}
bookMapper.xml
<?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.example.dao.bookMapper">
<insert id="addBook" parameterType="Books">
insert into springdb.books (bookname,bookCount,details)
values (#{bookname},#{bookCount},#{details})
</insert>
<delete id="deleteBookById" parameterType="int">
delete from springdb.books where bookid = #{bookId}
</delete>
<update id="updateBook" parameterType="Books">
update springdb.books
set bookname=#{bookname} ,bookCount=#{bookCount},details=#{details}
where bookid = #{bookid}
</update>
<select id="queryBookById" parameterType="int" resultType="Books">
select bookid,bookname,bookCount,details from springdb.books
where bookid=#{bookId}
</select>
<select id="queryAllBooks" resultType="Books" >
select * from springdb.books
</select>
</mapper>
"springdb" 数据库名称 ;”books“ 表名 (IDEA 关联数据库的写法,如果IDEA没直接连接数据库,可以直接写表名即,insert into springdb.books ====>insert into books
如上图所示为IDEA连接了数据库。没有连接也没有问题
IDEA关联数据库
写service层业务接口及其实现类
bookService.java
package com.example.service;
import com.example.pojo.Books;
import java.util.List;
public interface bookService {
//查找一本书
Books queryBookById( Integer id);
//增加一本书
int addBook(Books book);
//删除一本书
int deleteBookById(Integer id);
//更新一本书
int updateBook(Books book);
//查找所有书
List<Books> queryAllBooks();
}
bookServiceImpl.java
package com.example.service;
import com.example.dao.bookMapper;
import com.example.pojo.Books;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class bookServiceImpl implements bookService{
// 业务层调dao层
@Resource
private bookMapper bookMapper;
public void setBookMapper(com.example.dao.bookMapper bookMapper) {
this.bookMapper = bookMapper;
}
@Override
public Books queryBookById(Integer id) {
return bookMapper.queryBookById(id);
}
@Override
public int addBook(Books book) {
return bookMapper.addBook(book);
}
@Override
public int deleteBookById(Integer id) {
return bookMapper.deleteBookById(id);
}
@Override
public int updateBook(Books book) {
return bookMapper.updateBook(book);
}
@Override
public List<Books> queryAllBooks() {
return bookMapper.queryAllBooks();
}
}
写controller层
bookController.java
package com.example.controller;
import com.example.pojo.Books;
import com.example.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.RequestMapping;
import java.util.List;
@Controller
@RequestMapping("/book")
public class BookController {
// Controller层调Service层
@Autowired
private bookService bookService;
//查询所有书籍
@RequestMapping("/allBook")
public String BookList(Model model){
List<Books> books = bookService.queryAllBooks();
model.addAttribute("books",books);
return "allBook";
}
}
/WEB-INF/jsp/allBook.jsp
allBook.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>书籍展示</title>
</head>
<body>
</body>
</html>
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>主页</title>
</head>
<body>
<a href="${pageContext.request.contextPath}/book/allBook">跳转到书籍展示页面</a>
</body>
</html>