mybatis-spring-ext

技术讨论 QQ: 381607502

mybatis-spring-ext扩展了mybatis-spring, 简化了mybatis的使用.

一、扩展功能

• 基本CRUD自动mapper
• 方法名按规则自动mapper

二、配置使用

• 引入maven仓库

<repository>
	<id>lm</id>
	<name>lm</name>
	<layout>default</layout>
	<url>http://115.29.4.168:8082/nexus/content/repositories/thirdparty/</url>
</repository>

• 引入maven依赖(注意:请删除项目中mybatis, mybatis-spring依赖, 防止版本冲突)

<dependency>
    <groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring-ext</artifactId>
	<version>1.0.0</version>
</dependency>

• 配置spring

<bean id="sqlSessionFactory" class="org.mybatis.spring.ext.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource" />
	<!-- 支持通配 如:org.mybatis.spring.ext.**.entity -->
	<property name="typeAliasesPackage" value="org.mybatis.spring.ext.model.entity" />
	<property name="configLocation" value="classpath:mybatis/mybatis-config.xml"></property>
	<property name="mapperLocations" value="classpath:mybatis/mapper/**/*.xml" />
	<property name="mapperGenerators">
		<list>
			<!-- 自动mapper -->
			<bean class="org.mybatis.spring.ext.mapper.mysql.CrudMapperGenerator" />
			<bean class="org.mybatis.spring.ext.mapper.mysql.MethodMapperGenerator" />
		</list>
	</property>
</bean>
<!-- 扫描basePackage下所有以@MyBatisDao注解的接口 -->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
	<!-- 支持通配 如:org.mybatis.spring.ext.**.mapper -->
	<property name="basePackage" value="org.mybatis.spring.ext.model.mapper" />
	<property name="annotationClass" value="org.apache.ibatis.annotations.Mapper" />
</bean>

• 配置mybatis

<settings>
	<!-- 全局启用或禁用延迟加载。当禁用时，所有关联对象都会即时加载。 -->
	<setting name="lazyLoadingEnabled" value="true" />
	<!-- 当启用时，有延迟加载属性的对象在被调用时将会完全加载任意属性。否则，每种属性将会按需要加载。 -->
	<setting name="aggressiveLazyLoading" value="true" />
</settings>
<typeAliases>
	<typeAlias alias="Page" type="org.mybatis.spring.ext.Page" />
</typeAliases>

三、开发实例

• 根据业务创建实体表

• 通过eclipse生成实体类

@Entity
@Table(name = "user")
public class User implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private Long id;
	@Column(name = "birth_day")
	private Date birthDay;
	private String name;
	private boolean show;

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public Date getBirthDay() {
		return birthDay;
	}

	public void setBirthDay(Date birthDay) {
		this.birthDay = birthDay;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}
}

• 创建Mapper

package org.mybatis.spring.ext.model.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.mybatis.spring.ext.Page;
import org.mybatis.spring.ext.Pageable;
import org.mybatis.spring.ext.mapper.CrudMapper;
import org.mybatis.spring.ext.mapper.MethodMapper;
import org.mybatis.spring.ext.model.entity.User;

@Mapper
public interface UserMapper extends CrudMapper<User, Long>, MethodMapper<User> {

	/**
	 * 查询 id = #{id} and name = #{name}的用户
	 */
	User getByIdANDName(@Param("id") Long id, @Param("name") String name);

	/**
	 * 查询所有用户
	 */
	List<User> lstBy();

	/**
	 * 查询 name = #{name}的用户的用户数
	 */
	int cntByName(String name);

	/**
	 * 查询 name = #{name}的用户的用户数, name为空时, 查询总用户数
	 */
	int cntBiName(@Param("name") String name);

	/**
	 * 查询 name = #{name}的用户
	 */
	List<User> lstByName(String name);

	/**
	 * 查询 name like #{name}% 的用户
	 */
	List<User> lstByNameStartsWith(Pageable pageable);

	/**
	 * 分页查询:id between #{maxid} and #{minid} and name like %#{name}% order by id desc, birth_day asc limit #{offset}, #{pageSize}
	 */
	Page<User> qryByIdBetweenANDNameContainsOBIdDESCBirthDayASC(Pageable pageable);

	/**
	 * 删除id = #{id}的用户
	 */
	int delById(Long id);
}

无须在通过mapper文件, 或注解编写查询statement, 即可直接使用mapper进行查询.

四、开源项目地址

• oschina 地址 : https://git.oschina.net/netlomin/mybatis-spring-ext

转载于:https://my.oschina.net/u/444897/blog/861047