mapperdb

作用于 mybatis 的 mapper 的单表增删改查（mybatis v3.2.4+,无xml配置配置哦）。

1、entity 配置

package com.demo.domain;



import java.util.Date;



import javax.annotation.Resource;



import org.apache.ibatis.annotations.Result;

import org.apache.ibatis.annotations.SelectKey;

import org.apache.ibatis.type.JdbcType;



@Resource

public class Blog {

	private Integer id;



	private String title;



	private Date publishtime;



	private String content;



	public void setId(Integer id) {

		this.id = id;

	}



	public void setTitle(String title) {

		this.title = title;

	}



	public void setPublishtime(Date publishtime) {

		this.publishtime = publishtime;

	}



	public void setContent(String content) {

		this.content = content;

	}



	// call identity()

	// SELECT LAST_INSERT_ID()

	@Result(id = true)

	@SelectKey(statement = "SELECT LAST_INSERT_ID()", before = false, keyProperty = "id", keyColumn = "id", resultType = Integer.class)

	public Integer getId() {

		return id;

	}



	public String getTitle() {

		return title;

	}



	@Result(jdbcType=JdbcType.TIMESTAMP)

	public Date getPublishTime() {

		return publishtime;

	}



	public String getContent() {

		return content;

	}

}

Result可以配置 TypeHandler

2、mybatis 配置

	public void t() {

		Object b = null;

		// Mapper 添加

		MapperRegistryProxy proxy = MapperRegistryProxy.use(sqlSessionFactory);

		proxy.addMapper(BlogMapper.class);



		SqlSession sqlSession = sqlSessionFactory.openSession(true);

		BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);

	}

MapperRegistryProxy 注册 mapper 模板.

3、spring 整合

	<bean class="com.mapperdb.spring.MapperScannerConfigurerSupprot">

		<property name="basePackage" value="com.demo.mapper" />

		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />

	</bean>

其中 MapperScannerConfigurerSupprot 是 mapper 模板的扫描器 .

4、mapper 使用方式

package com.demo.mapper;



import com.demo.domain.Blog;

import com.mapperdb.mapper.Mapper;



public interface BlogMapper extends Mapper<Blog> {



}

其中 BlogMapper 继承已经定义好的 mapper 模板 . 还可以实现自己的 mapper 模板.

5、注意事项

text 建议和 mapper 模板和 mybatis 的 mapper 不放在同一个包中，方便扫描。