09springmvc_mybatis框架整合

springmvc 4.3.9 + Mybatis 整合

Spring容器 就是SpringFramework 框架 工厂框架

IoC
AOP

ssm

springframework struts hibernate

1、mysql数据库准备
root
root
db
localhost
3306
utf8

CREATE TABLE `book` (
`book_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`book_name` varchar(20) DEFAULT NULL,
`book_price` decimal(8,2) DEFAULT NULL,
PRIMARY KEY (`book_id`)
ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8

mysql> select * from book;
+---------+----------------------------+------------+
| book_id | book_name | book_price |
+---------+----------------------------+------------+
| 2 | 《java入门与精通》 | 355.00 |
| 3 | 《MySQL入门与精通》 | 105.00 |
| 6 | 《综合项目》 | 105.00 |
| 8 | 《MySQL入门与精通》 | 105.00 |
| 9 | 《Html5入门与精通》 | 105.00 |
| 10 | 《css入门与精通》 | 205.00 |
| 11 | 《综合项目》 | 105.00 |
| 12 | 《java开发》 | 105.00 |
+---------+----------------------------+------------+

2、建立maven web项目
pom.xml
<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.fz</groupId>
<artifactId>smvcm</artifactId>
<packaging>war</packaging>
<version>1.0</version>
<name>smvcm Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<!-- 单元测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.16</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>
</dependency>

<!-- logback -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
<version>1.2.3</version>
</dependency>
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.25</version>
</dependency>

<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.9.RELEASE</version>
</dependency>
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.2</version>
</dependency>
</dependencies>
<build>
<finalName>${project.artifactId}</finalName>
<testSourceDirectory>src/test/java</testSourceDirectory>
<sourceDirectory>src/main/java</sourceDirectory>
<!-- 处理无法加载资源配置文件 -->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
</resource>
</resources>
</build>
</project>

resources/db.properteis
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db?useSSL=true&useUnicode=true&characterEncoding=UTF8
jdbc.username=root
jdbc.password=root

resources/logback.xml
<?xml version="1.0"?>
<configuration>
<!-- ch.qos.logback.core.ConsoleAppender 控制台输出 -->
<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>[%-5level] %d{HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n</pattern>
</encoder>
</appender>
<!-- 日志级别 -->
<root>
<level value="error" />
<appender-ref ref="console" />
</root>
<logger name="dao" level="DEBUG"/>
</configuration>

resources/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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

<!-- 配置自动扫描的包 -->
<context:component-scan base-package="com.fz.controller" />

<!-- 在没有配置mvc:resources的时候没有问题，一旦配置了mvc:resources，注解方式的url就没有加载 -->
<mvc:annotation-driven>
<!-- 消息转换器 -->
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<property name="supportedMediaTypes" value="text/html;charset=UTF-8"/>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>

<mvc:resources mapping="/imgs/**" location="/imgs/"/>
<mvc:resources mapping="/css/**" location="/css/"/>
<mvc:resources mapping="/js/**" location="/js/"/>

<!-- 配置视图解析器 如何把handler 方法返回值解析为实际的物理视图 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/template/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
</beans>

resources/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>
<!-- 加载JDBC配置信息 resources目录下db.properties文件 -->
<properties resource="db.properties"/>
<!-- logback 显示SQL语句 -->
<settings>
<setting name="logPrefix" value="dao."/>
</settings>
<!-- 别名 -->
<typeAliases>
<package name="com.fz.entity"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.fz.mapper"/>
</mappers>
</configuration>

src/main/webapp/WEB-INF/web.xml 文件内容如下
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
id="WebApp_ID" version="3.1">
<display-name>smvcm</display-name>

<!-- web项目支持spring mvc 4.3.3 -->
<servlet>
<servlet-name>mvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<!-- spring mvc 在启动时主动查找加载 src目录下也就是WEB-INF/classes 目录下mvc.xml -->
<param-value>classpath:mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>mvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>

<!-- spring 编码过滤器，解决中文乱码 -->
<filter>
<filter-name>characterEncodingFilter</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>
<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>

<welcome-file-list>
<welcome-file>index</welcome-file>
<welcome-file>index.html</welcome-file>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>

3、实体类
package com.fz.entity;
import lombok.Data;
/**
* Created by webrx on 2017-06-30.
*/
@Data
public class Book {
private int id;
private String name;
private double price;
}

4、mapper接口与配置xml文件
BookMapper.java 接口
package com.fz.mapper;
import com.fz.entity.Book;
import java.util.List;
/**
* Created by webrx on 2017-06-30.
*/
public interface BookMapper {
public List<Book> queryAll();
public int deleteById(int id);
public int add(Book book);
}

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.fz.mapper.BookMapper">
<resultMap id="bookmap" type="book">
<id column="book_id" property="id"/>
<result property="name" column="book_name"/>
<result property="price" column="book_price"/>
</resultMap>

<select id="queryAll" resultMap="bookmap">
select * from book order by book_id desc
</select>

<delete id="deleteById" parameterType="int">
delete from book where book_id=#{id}
</delete>
<insert id="add" parameterType="book">
insert into book values(null,#{name},#{price})
</insert>
</mapper>

5、mybatis工具类
package com.fz.com.fz.util;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
/**
* Created by webrx on 2017-06-30.
*/
public class MybatisUtil {
private SqlSessionFactory sf;
private SqlSession ss;
public MybatisUtil(){
InputStream is = null;
try {
is = Resources.getResourceAsStream("mybatis-config.xml");
} catch (IOException e) {
e.printStackTrace();
}
this.sf = new SqlSessionFactoryBuilder().build(is);
this.ss = this.sf.openSession();
}
public SqlSession getSession(){
return this.ss;
}
}

6、业务操作接口与实现类
package com.fz.com.fz.service;
import com.fz.mapper.BookMapper;

/**
* Created by webrx on 2017-06-30.
*/
public interface BookService extends BookMapper {
}

package com.fz.com.fz.service;
import com.fz.com.fz.util.MybatisUtil;
import com.fz.entity.Book;
import com.fz.mapper.BookMapper;
import org.apache.ibatis.session.SqlSession;
import java.util.List;
/**
* Created by webrx on 2017-06-30.
*/
public class BookServiceImpl implements BookService {
private BookMapper bookdao;
private SqlSession session;

public BookServiceImpl(){
this.session = new MybatisUtil().getSession();
this.bookdao = this.session.getMapper(BookMapper.class);
}

@Override
public List<Book> queryAll() {
List<Book> bk = this.bookdao.queryAll();
this.session.commit();
return bk;
}

@Override
public int deleteById(int id) {
int n = this.bookdao.deleteById(id);
this.session.commit();
return n;
}

@Override
public int add(Book book) {
int n = this.bookdao.add(book);
this.session.commit();
return n;
}
}

7、样式文件编写
/css/index.css
.tt{
80%;
border-collapse: collapse;
margin:20px auto;
}
.tt caption{
font-weight: bold;
letter-spacing:5px;
font:25px/55px "微软雅黑";
}
.tt tr td,.tt tr th{
border: 1px solid #d9d9d9;
padding: 8px;
text-align: center;
font:14px/28px "微软雅黑";
}

.tt tr:hover{
background-color: #f4ffcb;
}

8、视图层/WEB-INF/template/
index.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="utf-8">
<title>图书管理</title>
<link rel="stylesheet" href="css/index.css">
</head>
<body>

<table class="tt">
<caption>图书信息</caption>
<tr>
<th>名称</th>
<th>价格</th>
<th>基本操作</th>
</tr>
<c:forEach items="${books}" var="book">
<tr>
<td>${book.name}</td>
<td>${book.price}</td>
<td><a href="?id=${book.id}">删除</a></td>
</tr>
</c:forEach>
<tr>
<td colspan="100">
<a href="add">添加新图书</a>
</td>
</tr>
<tr>
<td colspan="100">
分页信息
</td>
</tr>
</table>
</body>
</html>

add.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="utf-8">
<title>添加新图书</title>
</head>
<body>
<h3>图书信息</h3>
<form action="save" method="post">
图书名称：<input type="text" name="name"><br>
图书价格：<input type="text" name="price"><br>
<input type="submit" value="添加新书">
</form>

</body>
</html>