SpringMVC + Mybatis整合Mapper方式

Mybatis MapperScannerConfigurer 自动扫描将Mapper接口生成代理注入到Spring　http://www.cnblogs.com/daxin/p/3545040.html

spring与mybatis三种整合方法 http://panyongzheng.iteye.com/blog/2102910
Mybatis整合Spring
http://haohaoxuexi.iteye.com/blog/1843309
选择: 简单的应用选择Mapper映射方式, 复杂的框架, 可以使用spring与mybatis三种整合方法的后两种.MyBatis3 的Mapper XML 文件详解http://mybatis.org/mybatis-3/zh/sqlmap-xml.html注意: 以上描述的三种分方式之外, 还有一种就是使用Mapper.xml和Mapper.java两个文件对应的方式, 其中Mapper.java类就相当于了原生的DAO接口和实现类, 如果还需要做额外的处理, 就增加实际的DAO, 然后调用Mapper.java文件. 本文是后者.

参考:
mybatis学习笔记 http://legend2011.blog.51cto.com/3018495/888848
mybatis初步—-查询之resultMap和resultType http://my.oschina.net/mutianya/blog/168268
mybatis自增主键配置 http://leeyee.github.io/blog/2013/08/22/mybatis-auto-increment-primary-key/
Spring声明式事务管理示例——MyBatis http://legend2011.blog.51cto.com/3018495/1239139
数据库逆向框架代码生成工具：MyBatis Generator的使用 http://my.oschina.net/lujianing/blog/200135

web.xml

Xml代码

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"

version="3.0">

<display-name>Archetype Created Web Application</display-name>

<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>

</listener>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath*:applicationContext*.xml</param-value>

</context-param>

<servlet-name>springmvc</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>springmvc</servlet-name>

<url-pattern>*.do</url-pattern>

</servlet-mapping>

</web-app>

servlet.xml

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.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd">

<context:component-scan base-package="com">

<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>

<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Repository"/>

</context:component-scan>

<mvc:annotation-driven/>

<mvc:resources location="/resources/" mapping="/resources/**"/>

</bean>

</beans>

jdbc.properties
jdbc.dataSource=com.alibaba.druid.pool.DruidDataSource
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/smartsangbag?useUnicode=true&characterEncoding=utf8
jdbc.username=xxxxxxx
jdbc.password=******

applicationContext.xml

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-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

<context:component-scan base-package="com.pandy"/>

<context:property-placeholder location="classpath:/jdbc.properties"/>

<!-- <property name="alias" value="${proxool.alias}" />

</bean>

</beans>

applicationContext-spring.xml

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:tx="http://www.springframework.org/schema/tx"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:util="http://www.springframework.org/schema/util"

xmlns:p="http://www.springframework.org/schema/p"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop.xsd

http://www.springframework.org/schema/util

http://www.springframework.org/schema/util/spring-util.xsd">

</bean>

</bean>

<bean id="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

</bean>

<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>

</beans>

定义mybatis的映射文件 src/main/resources/com/pandy/mapper/SentEmailQueueMapper.xml

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">

</resultMap>

SELECT data_id as dataId, from_email as fromEmail, to_email as toEmail, to_user_id as toUserId, send_date_time as sendDateTime, invalid_date_time as invalidDateTime, email_type as emailType, email_data_id as emailDataId,

subject as subject, template_name as templateName, content_params as contentParams, sent_status as sentStatus,

actual_sent_date_time as actualSentDateTime,

CREATED_TIME as createdTime,

MODIFIED_TIME as modifiedTime,

LAST_UPDATED_STAMP as lastUpdatedStamp,

LAST_UPDATED_TX_STAMP as lastUpdatedTxStamp,

CREATED_STAMP as createdStamp,

CREATED_TX_STAMP as createdTxStamp

FROM send_email_queue1 where data_id = #{data_id}

</select>

SELECT data_id, from_email, to_email, to_user_id, send_date_time, invalid_date_time, email_type, email_data_id, subject, template_name, content_params, sent_status, actual_sent_date_time, CREATED_TIME, MODIFIED_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM send_email_queue1

</select>

INSERT INTO send_email_queue1 (from_email, to_email)

VALUES (#{toEmail}, #{toEmail})

</insert>

UPDATE send_email_queue1 SET from_email = #{toEmail}, to_email = #{toEmail}

WHERE data_id = #{dataId}

</update>

delete from send_email_queue1 where data_id = #{dataId}

</delete>

</mapper>

映射文件对应的接口

Java代码

package com.pandy.dao.mapper;

import com.pandy.model.SentEmailQueue;

import java.util.List;

/**

* 只定义跟xml文件的sql对应就好，不用实现这个接口，这个接口mybatis自己实现。

public interface SentEmailQueueMapper {

public SentEmailQueue get(Integer id);

public List<SentEmailQueue> getAll();

public void insert(SentEmailQueue queue);

public void update(SentEmailQueue queue);

public void delete(Integer dataId);

}

映射文件对应的model

Java代码

package com.pandy.model;

import java.util.Date;

public class SentEmailQueue {

private Integer dataId;

private String fromEmail;

private String toEmail;

private String toUserId;

private Date sendDateTime;

private Date invalidDateTime;

private String emailType;

private String emailDataId;

private String subject;

private String templateName;

private String contentParams;

private String sentStatus;

private String actualSentDateTime;

private Date createdTime;

private Date modifiedTime;

private Date lastUpdatedStamp;

private Date lastUpdatedTxStamp;

private Date createdStamp;

private Date createdTxStamp;

......

@Override

public String toString() {

return "SentEmailQueue{" +

"dataId='" + dataId + '\'' +

", fromEmail='" + fromEmail + '\'' +

", toEmail='" + toEmail + '\'' +

", toUserId='" + toUserId + '\'' +

", sendDateTime=" + sendDateTime +

", invalidDateTime=" + invalidDateTime +

", emailType='" + emailType + '\'' +

", emailDataId='" + emailDataId + '\'' +

", subject='" + subject + '\'' +

", templateName='" + templateName + '\'' +

", contentParams='" + contentParams + '\'' +

", sentStatus='" + sentStatus + '\'' +

", actualSentDateTime='" + actualSentDateTime + '\'' +

", createdTime=" + createdTime +

", modifiedTime=" + modifiedTime +

", lastUpdatedStamp=" + lastUpdatedStamp +

", lastUpdatedTxStamp=" + lastUpdatedTxStamp +

", createdStamp=" + createdStamp +

", createdTxStamp=" + createdTxStamp +

'}';

}

DAO:

Java代码

package com.pandy.dao;

import com.pandy.model.SentEmailQueue;

import java.util.List;

/**

* Created by pandy on 14-8-13.

public interface SentEmailQueueDao {

public SentEmailQueue get(Integer dataId);

public List<SentEmailQueue> getAll();

public void insert(SentEmailQueue queue);

public void update(SentEmailQueue queue);

public void delete(Integer dataId);

}

Java代码

package com.pandy.dao.impl;

import com.pandy.dao.SentEmailQueueDao;

import com.pandy.dao.mapper.SentEmailQueueMapper;

import com.pandy.model.SentEmailQueue;

import org.springframework.stereotype.Repository;

import javax.annotation.Resource;

import java.util.List;

/**

* Created by pandy on 14-8-13.

@Repository("sentEmailQueueDao")

public class SentEmailQueueDaoImpl implements SentEmailQueueDao {

@Resource

private SentEmailQueueMapper sentEmailQueueMapper;

@Override

public SentEmailQueue get(Integer dataId) {

return sentEmailQueueMapper.get(dataId);

}

@Override

public List<SentEmailQueue> getAll() {

return sentEmailQueueMapper.getAll();

}

@Override

public void insert(SentEmailQueue queue) {

sentEmailQueueMapper.insert(queue);

}

@Override

public void update(SentEmailQueue queue) {

sentEmailQueueMapper.update(queue);

}

@Override

public void delete(Integer dataId) {

sentEmailQueueMapper.delete(dataId);

}

Service

Java代码

package com.pandy.service;

/**

* Created by pandy on 14-8-13.

public interface SentEmailQueueService {

public void test(boolean isRollback);

}

Java代码

package com.pandy.service.impl;

import com.pandy.dao.SentEmailQueueDao;

import com.pandy.model.SentEmailQueue;

import com.pandy.service.SentEmailQueueService;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Propagation;

import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.List;

@Service("sentEmailQueueService")

@Transactional

public class SentEmailQueueServiceImpl implements SentEmailQueueService {

@Resource(name = "sentEmailQueueDao")

private SentEmailQueueDao sentEmailQueueDao;

@Override

@Transactional(propagation = Propagation.REQUIRED, readOnly = false, rollbackFor = RuntimeException.class)

public void test(boolean isRollback) {

Date date = new Date();

SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd_HHmmss");

SentEmailQueue queue = new SentEmailQueue();

queue.setToEmail(format.format(date) + "@pandy8.com");

sentEmailQueueDao.insert(queue);

List<SentEmailQueue> list = sentEmailQueueDao.getAll();

int update_id = 0;

for (SentEmailQueue row : list) {

queue = sentEmailQueueDao.get(row.getDataId());

System.out.println(queue.toString());

update_id = row.getDataId();

}

date = new Date();

format = new SimpleDateFormat("yyyyMMdd_HHmmss");

queue = new SentEmailQueue();

queue.setDataId(update_id);

queue.setToEmail("update_" + format.format(date) + "@pandy8.com");

sentEmailQueueDao.update(queue);

System.out.println("将被删除的id=" + (update_id - 1));

sentEmailQueueDao.delete(update_id - 1);

if(isRollback) {

throw new RuntimeException("事务测试: 故意抛出异常，使得对数据库的操作失败");

}

Controller

Java代码

package com.pandy.controller;

import com.pandy.service.SentEmailQueueService;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;

/**

* Created by pandy on 14-8-13.

@Controller

@RequestMapping("/myController")

public class MyController {

@Resource(name="sentEmailQueueService")

private SentEmailQueueService sentEmailQueueService;

@RequestMapping("/test")

public ModelAndView test(@RequestParam("isRollback") boolean isRollback){

System.out.println("==================>isRollback="+isRollback);

sentEmailQueueService.test(isRollback);

return new ModelAndView("index");

}

访问:
正常事务:http://localhost:8080/SpringMybatis/myController/test.do?isRollback=false
回滚事务:http://localhost:8080/SpringMybatis/myController/test.do?isRollback=true

附加pom.xml

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

Xml代码

<?xml version="1.0" encoding="UTF-8"?>

<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/xsd/maven-4.0.0.xsd">

<groupId>com.pandy</groupId>

<artifactId>spmybatis</artifactId>

<version>1.0-SNAPSHOT</version>

<java.version>1.7</java.version>

<mybatis.version>3.2.7</mybatis.version>

<mybatis.spring.version>1.2.2</mybatis.spring.version>

<mysql.version>5.1.30</mysql.version>

<spring.version>4.0.5.RELEASE</spring.version>

<spring.security.version>3.2.4.RELEASE</spring.security.version>

<spring.asm.version>3.1.4.RELEASE</spring.asm.version>

<aspectj.version>1.6.2</aspectj.version>

<mysql.version>5.1.30</mysql.version>

<jdbc.groupId>com.alibaba</jdbc.groupId>

<jdbc.artifactId>druid</jdbc.artifactId>

<jdbc.version>1.0.4</jdbc.version>

</properties>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>${mybatis.version}</version>

</dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

<version>${mybatis.spring.version}</version>

</dependency>