开发环境为:
Eclispe 4.6.3
Windows x64
Tomcat 7.0
2.项目的目录结构
3.使用jar包截图
4.实体bean
package com.cn.bean;
public class Goods {
private Integer id;
private String name;
private String type;
public Goods() {
super();
}
public Goods(String name, String type) {
super();
this.name = name;
this.type = type;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getId() {
return id;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
public void setType(String type) {
this.type = type;
}
public String getType() {
return type;
}
@Override
public String toString() {
return "Goods [id=" + id + ", name=" + name + ", type=" + type + "]";
}
}
5.mapper接口和映射文件
package com.cn.mapper;
import java.util.List;
import com.cn.bean.Goods;
/**
* @ClassName GoodsMapper
* @Description TODO(这里用一句话描述这个类的作用)
* @author hasee
* @Date 2017年12月1日 下午5:46:25
* @version 1.0.0
*/
public interface GoodsMapper {
List<Goods> findAll();
void save(Goods goods);
}
<?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.cn.mapper.GoodsMapper">
<select id="findAll" resultType="goods">
select * from goods
</select>
<insert id="save" parameterType="goods">
insert into goods(name,type) values(#{name},#{type})
</insert>
</mapper>
package com.cn.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.cn.bean.Goods;
import com.cn.mapper.GoodsMapper;
/**
* @ClassName GoodsServiceImpl
* @Description TODO(这里用一句话描述这个类的作用)
* @author hasee
* @Date 2017年12月1日 下午5:50:11
* @version 1.0.0
*/
@Transactional
@Service
public class GoodsServiceImpl implements GoodsService {
@Autowired
private GoodsMapper mapper;
@Override
public List<Goods> queryAll() {
// TODO Auto-generated method stub
return mapper.findAll();
}
@Override
public void add(Goods goods) {
mapper.save(goods);
}
}
7.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>
<!-- 全局设置 -->
<settings>
<setting name="autoMappingBehavior" value="FULL" /> <!-- 开启全部自动映射,包含嵌套查询 -->
<!-- 打开懒加载的开关 -->
<!-- <setting name="lazyLoadingEnabled" value="true" /> -->
</settings>
</configuration>
8.spring整合mybatis的配置文件
<?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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
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">
<!-- 开启组件扫描 -->
<context:component-scan base-package="com.cn.service"></context:component-scan>
<!--配置数据源 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3308/mybatis"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
<!-- <property name="defaultAutoCommit" value="false"></property> -->
<!-- 选配信息 -->
</bean>
<!-- 配置sqlsessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<!--扫描映射文件 -->
<property name="mapperLocations" value="classpath:com/cn/mapper/*.xml"></property>
<!--设置别名 -->
<property name="typeAliasesPackage" value="com.cn.bean"></property>
</bean>
<!--配置扫描Mapper接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
<property name="basePackage" value="com.cn.mapper"></property>
</bean>
<!--配置JDBC事务管理 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--开启注解事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
</beans>
9.注意,因为整合的普通web项目,使用的是servlet,所以在servlet中调用服务层的方法时,service的对象不能够通过注解注入,因为servlet是由tomcat容器管理,会导致spring容器的注解注入失效,所以必须通过下面的applicationContext 工具类来获取 context对象,进而从容器中获取service层的实例对象
package com.cn.service;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Component;
@Component
public class CtxUtil implements ApplicationContextAware {
public static ApplicationContext ctx;
@Override
public void setApplicationContext(ApplicationContext arg0) throws BeansException {
this.ctx = arg0;
}
/**
* 根据类型获得bean
*/
public static <T> T getBean(Class<T> clazz) {
return ctx.getBean(clazz);
}
/**
* 根据名称名称获得bean
*/
public static Object getBean(String name) {
return ctx.getBean(name);
}
}
10.控制器servlet中的代码
package com.cn.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cn.bean.Goods;
import com.cn.service.CtxUtil;
import com.cn.service.GoodsService;
/**
* Servlet implementation class TestServlet
*/
@WebServlet("/test.do")
public class TestServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private GoodsService service;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
service = CtxUtil.getBean(GoodsService.class);
String name = request.getParameter("name");
String type = request.getParameter("type");
Goods goods = new Goods(name, type);
service.add(goods);
response.getWriter().println("add success!");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
11.jsp页面
<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<title>Spring-Mybatis 整合 WEB 项目</title>
</head>
<body>
<form action="test.do">
<p> 商品名称:<input type="text" name="name" /></p>
<p>商品类型:<input type="text" name="type"/></p>
<p> <input type="submit" /></p>
</form>
</body>
</html>
12.最为重要的一步,必须在web.xml 配置文件中,配置spring 配置文件的 监听器和初始化参数
<?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>Spring-Mybatis_Web</display-name>
<!--全局初始化参数 加载配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mybatis.xml</param-value>
</context-param>
<!-- 配置监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>