背景:
基于mybatis的3.1.1和Spring的3.1.0.RELEASE做集成操作,不采用事务控制。
依赖jar:
<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.1.1</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.25</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>3.1.0.RELEASE</version> </dependency>
web.xml中感知到spring的存在:
<context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring-*.xml</param-value> </context-param>
spring-db.xml:
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:task="http://www.springframework.org/schema/task" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:beans="http://www.springframework.org/schema/beans" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.1.xsd"> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://host:3005/db" /> <property name="username" value="username" /> <property name="password" value="password" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="/WEB-INF/mybatis-config.xml"/> <property name="mapperLocations" value="classpath*:com/xx/dao/*.xml" /> <property name="typeAliasesPackage" value="com.xx.vo" /> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.xx.dao" /> </bean> </beans>
上述指定了dataSource,同时sqlSessionFactory中引入了dataSource,configLocation中的配置如下:
<?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> <typeAlias alias="demo_t" type="com.xx.vo.Demo" /> </typeAliases> </configuration>
mapperLocations(DemoMapper.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.xx.dao.DemoDao"> <cache /> <select id="getDemo" parameterType="string" resultType="Demo" > select id from demo_t where id = #{id} </select> </mapper>
VO和Dao如下:
public class Demo implements Serializable { private static final long serialVersionUID = -7271550743849359837L; private String id; public String getId() { return id; } public void setId(String id) { this.id = id; } }
public interface DemoDao { Demo getDemo(String id); }
此时配置完成只需要调用即可:
this.demoDao.getDemo(id);
相关推荐
SpringMVC+Spring+Mybatis集成开发环境SpringMVC+Spring+Mybatis集成开发环境SpringMVC+Spring+Mybatis集成开发环境SpringMVC+Spring+Mybatis集成开发环境SpringMVC+Spring+Mybatis集成开发环境SpringMVC+Spring+...
SpringMVC+Spring+Mybatis集成开发环境
spring-mybatis集成jar包以及整合文档 mybatis-spring-1.2.0.jar
Spring与MyBatis集成步骤,内含简单的集成步骤及样例,易懂
Spring与Mybatis项目的集成,加上事务的配置。 后面会再上传+SpringMVC和+Shiro后的项目。
主要完成springMVC+Spring+MyBatis集成,前台使用了easyUI技术
Spring集成Mybatis所需jar包
spring整合mybatis时需要用到的配置文件
mybatis-plus学习,spring和mybatis-plus集成配置
spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip spring集成mybatis.zip ...
用IDEA搭建Springboot spring MVC Mybatis集成环境
Spring集成MyBatis简单demo
spring mvc mybatis 整合源码,带数据库脚本,带详细注释,适合初、中、高各级开发人员使用
这是一个web程序的后台代码,整合了spring mvc和mybatis的配置,实现了各地方的电量增删改查,该代码持久层利用mybatis框架,简化了dao层的实现,spring实现了controller层、service层。
struts2,spring,mybatis集成jar包以及相关jar,如何集成可以查看我的另一篇微博
springmvc+spring+mybatis集成框架的环境搭建
springMVC+spring+mybatis集成的框架,只需要在在本地创建ssm数据库。
spring集成mybatis,资源包括: 中文版MyBatis 3 User Guide.pdf mybatis-spring集成指导.pdf Mybatis.pdf mybatis-3.2.8.jar mybatis-spring-1.2.2.jar
springMVC(4.1.2)+spring(4.1.2)+Mybatis+maven整合,项目部署时请配好开发环境!