Spring 和 MyBatis 环境整合

create database springmybatis;
use springmybatis ;
create table t_product (
p_id int(11) primary key auto_increment ,
p_title varchar(100) ,
p_price double(11,2) ,
p_store int(11) ,
p_img varchar(200)
) ; insert into t_product(
p_title , p_price , p_store , p_img
) values (
'香甜可口的大柚子快来买吧过了这村没这个店' ,
10.00,
500,
'p-big-123.jpg'
) ;

package com.springmybatis.entity;import java.io.Serializable;public class Product implements Serializable{ private static final long serialVersionUID = -6233090527088205803L; private int p_id;//商品编号
private String p_title;//商品标题
private double p_price;//商品价格
private int p_store;//商品库存
private String p_img;//商品图片
public Product() {
}
public Product(int p_id, String p_title, double p_price, int p_store, String p_img) {
this.p_id = p_id;
this.p_title = p_title;
this.p_price = p_price;
this.p_store = p_store;
this.p_img = p_img;
}
public int getP_id() {
return p_id;
}
public void setP_id(int p_id) {
this.p_id = p_id;
} public String getP_title() {
return p_title;
} public void setP_title(String p_title) {
this.p_title = p_title;
}
public double getP_price() {
return p_price;
}
public void setP_price(double p_price) {
this.p_price = p_price;
}
public int getP_store() {
return p_store;
}
public void setP_store(int p_store) {
this.p_store = p_store;
}
public String getP_img() {
return p_img;
}
public void setP_img(String p_img) {
this.p_img = p_img;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
@Override
public String toString() {
return "Product [p_id=" + p_id + ", p_title=" + p_title + ", p_price=" + p_price + ", p_store=" + p_store + ", p_img=" + p_img + "]";
}
}

package com.springmybatis.annotation;//自定义注解
public @interface SpringMybatisAnnotation { String value() default "";}

package com.springmybatis.mapper;import java.util.List;import org.springframework.stereotype.Component;import com.springmybatis.annotation.SpringMybatisAnnotation;
import com.springmybatis.entity.Product;@SpringMybatisAnnotation
//@Component 也可使用Spring自己的注解
public interface ProductMapper { List<Product> findAll(); void update(Product product);}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.springmybatis.mapper.ProductMapper"> <select id="findAll" resultType="com.springmybatis.entity.Product">
select * from t_product
</select> <update id="update" parameterType="com.springmybatis.entity.Product">
update t_product set p_title=#{p_title}, p_price=#{p_price}, p_store=#{p_store},
p_img=#{p_img} where p_id=#{p_id}
</update></mapper>

package com.springmybatis.dao;import java.util.List;import com.springmybatis.entity.Product;public interface ProductDAO { List<Product> findAll(); void update(Product product);}

package com.springmybatis.dao;import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Repository;import com.springmybatis.entity.Product;
import com.springmybatis.mapper.ProductMapper;@Repository("productDAO")
public class ProductDAOImpl implements ProductDAO {
@Resource
private ProductMapper productMapper;
@Override
public List<Product> findAll() {
return productMapper.findAll();
}
@Override
public void update(Product product) {
productMapper.update(product);
}
}

package com.springmybatis.service;import java.util.List;import com.springmybatis.entity.Product;public interface ProductService { List<Product> findAll(); void update(Product product);}

package com.springmybatis.service;import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Service;import com.springmybatis.dao.ProductDAO;
import com.springmybatis.entity.Product;
@Service("productService")
public class ProductServiceImpl implements ProductService { @Resource
private ProductDAO productDAO; @Override
public List<Product> findAll() { return productDAO.findAll();
} @Override
public void update(Product product) {
productDAO.update(product); }}

package com.springmybatis.controller;import java.io.File;
import java.io.IOException;
import java.util.List;import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;import org.apache.commons.io.FileUtils;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;import com.springmybatis.entity.Product;
import com.springmybatis.service.ProductService;@Controller
@RequestMapping("/product")
public class ProductController { @Resource
private ProductService productService; @RequestMapping("/list")
public String findAll(Model model){
List<Product> products = productService.findAll();
model.addAttribute("products",products);
return "product/list";
} @RequestMapping("/load")
public String load(HttpServletRequest request, Model model){
int p_id = Integer.valueOf(request.getParameter("p_id").toString());
model.addAttribute("p_id",p_id);
return "product/load";
} //文件上传
@RequestMapping("/submitload")
public String submitLoad(@RequestParam("product_img") MultipartFile product_img, Product product, HttpServletRequest request) throws IOException{
String realPath = request.getSession().getServletContext().getRealPath("/img");
product.setP_img(product_img.getOriginalFilename());
//System.out.println(realPath);
FileUtils.copyInputStreamToFile(product_img.getInputStream(),new File(realPath, product_img.getOriginalFilename()));
//System.out.println(product);
productService.update(product);
return "redirect:/product/list";
}
}

<?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.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd"> <!-- 开启Spring注解 -->
<context:component-scan base-package="com.springmybatis.controller"></context:component-scan>
<context:component-scan base-package="com.springmybatis.service"></context:component-scan>
<context:component-scan base-package="com.springmybatis.dao"></context:component-scan> <!-- 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>
<property name="prefix" value="/WEB-INF/"></property>
<property name="suffix" value=".jsp"></property>
</bean> <!-- 加载数据库连接参数配置文件 -->
<context:property-placeholder location="classpath:jdbc.properties"/> <!-- 配置dataSource -->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean> <!-- 配置 sqlSessionFactory -->
<!--
SqlSessionFactoryBean
为整合应用提供SqlSession对象资源
在单独使用Mybatis时，所有操作都时围绕SqlSession展开，SqlSession是通过SqlSessionFactory获取的，
SqlSessionFactory又是通过SqlSessionFactoryBuilder创建生成的。
在Spring和Mybatis整合应用时，同样需要SqlSession，mybatis-spring-1.2.1.jar提供了一个SqlSessionFactoryBean 。
这个组件作用就是通过SqlSessionFactoryBuilder生成SqlSessionFactory对象，为整合应用提供SqlSession对象。
必须为其注入：DataSource 和 映射文件位置
属性介绍：
dataSource
用于连接数据库的数据源（required）
mapperLocations
用于指定Mapper文件存放的位置
configLocation
用于指定mybatis的配置文件位置，如果制定了该属性，那么会以该配置文件的内容作为配置信息构建对应的SqlSessionFactoryBuiler，
但是后续属性指定的内容会被覆盖
typeAliasesPackage
它一般对应我们的实体类所在的包，它会自动取对应的包中不包括包名的简单类名作为包括包名的类别名，
多个package之间可以用逗号或者分号分隔
typeAliases
它是数组类型，用来指定别名的，指定这个属性后，mybatis会把这个类型的短名称作为这个类型的别名 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="mapperLocations" value="classpath:com/springmybatis/mapperxml/*.xml"></property>
<!-- <property name="configLocation" value="classpath:SqlMapConfig.xml"></property> -->
</bean> <!-- 配置映射扫描范围 -->
<!--
MapperScannerConfigurer
根据指定包批量扫描Mapper接口并生成实例
在定义这个bean时，只需要指定一个basePackage即可，
basePackage
用于指定Mapper接口所在的包，在这个包及其所有子包下面的Mapper接口都将被搜索到，
并把他们注册为一个一个映射工厂bean
多个包之间而已使用逗号或者分号进行分隔。
SqlSessionFactory
该属性可以不用指定，会以Autowired方式自动注入 如果指定的某个包下并不完全是我们定义的Mapper接口，此时使用MapperScannerConfigurer的另外两个属性可以缩小搜索和注册的范围，
annotationClass :
用于指定一个注解标记，当指定了该属性时，MapperScannerConfigurer将只注册使用了annotationClass注解标记的接口
markerInterface :
用于指定一个接口，当指定了该属性，MapperScannerConfigurer将只注册标记了该注解的接口
如果以上两者都配置了，去并集 而不是交集
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.springmybatis.mapper"></property>
<!-- <property name="annotationClass" value="com.springmybatis.annotation.SpringMybatisAnnotation"></property> -->
</bean> <!--
spring mvc对文件上传的支持工具 建立在导入的两个jar包之上
commons-fileupload.jar
commons-io.jar
-->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="defaultEncoding" value="UTF-8"></property>
<property name="maxUploadSize" value="1024000"></property>
</bean></beans>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
<!--
该条配置也可以在applicationContext.xml中的sqlSessionFactory的locations属性上定义
本例就是在applicationContext.xml里配置的
<mappers>
<mapper resource="classpath:com/springmybatis/mapperxml/*.xml"/>
</mappers>
-->
</configuration>

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
<display-name>Mybatis_day02</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list> <servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!--
若不配置该初始化参数 spring会自动去找"/WEB-INF/<servlet-name>-servlet.xml"
若配置了如下的初始化参数,Spring MVC框架将加载"classpath:applicationContext.xml"来进行初始化上下文
而不是"/WEB-INF/<servlet-name>-servlet.xml"
-->
<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>springDispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping> <!-- 解决中文乱码问题 -->
<filter>
<filter-name>spring-filter</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>spring-filter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> <!-- 放行静态资源 -->
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping></web-app>

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<base href="<%=basePath%>">
<title>Insert title here</title>
</head>
<body>
<a href="<%=basePath%>product/list">查看所有产品信息</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<base href="<%=basePath%>">
<title>Insert title here</title>
</head>
<body>
<h1>商品信息</h1>
<table>
<thead>
<tr>
<th>No.</th>
<th>ID</th>
<th>TITLE</th>
<th>PRICE</th>
<th>STORE</th>
<th>IMG</th>
<th>OPERATION</th>
</tr>
</thead>
<tbody>
<c:forEach items="${products }" var="product" varStatus="stat">
<tr>
<td>${stat.count }</td>
<td>${product.p_id}</td>
<td>${product.p_title}</td>
<td>${product.p_price}</td>
<td>${product.p_store}</td>
<td>
<img alt="" src="<%=basePath%>img/${product.p_img}" width="40">
</td>
<td>
<a href="<%=basePath%>product/load?p_id=${product.p_id}">修改</a>
<a href="<%=basePath%>product/delete?p_id=${product.p_id}">删除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table></body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<base href="<%=basePath%>">
<title>Insert title here</title>
</head>
<body>
<form action="product/submitload?p_id=${p_id }" method="post" enctype="multipart/form-data">
标题: <input type="text" name="p_title"><br><br>
价格: <input type="text" name="p_price"><br><br>
库存: <input type="text" name="p_store"><br><br>
文件: <input type="file" name="product_img"><br><br>
<input type="submit" value="提交">
</form>
</body>
</html>