通用Mapper配置

1.Maven的Pom.xml文件配置：

<!-- 通用Mapper -->

<dependency>

<groupId>com.github.abel533</groupId>

<artifactId>mapper</artifactId>

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

</dependency>

2.SqlMapConfig.xml文件配置

通用Mapper配置：

<plugins>

         <!--使用通用Mapper -->

         <plugin interceptor= "com.github.abel533.mapperhelper.MapperInterceptor" >

             <!--主键自增回写方法,默认值MYSQL,详细说明请看文档 -->

             <property name= "IDENTITY" value= "MYSQL" />

             <!--通用Mapper接口，多个通用接口用逗号隔开 -->

             <property name= "mappers" value= "com.github.abel533.mapper.Mapper" />

         </plugin>

</plugins>

3.修改POJO

修改pojo，增加JPA注解

作用是把类名和表名进行映射

类中的属性名和表中的列名映射

4.接下来就可以使用UserMapper了。

private NewUserMapper newUserMapper;

this.newUserMapper.insert(user);

this.newUserMapper.selectOne(param);

List<User>list = this.newUserMapper.select(param);

int count = this.newUserMapper.selectCount(null);

User user = this.newUserMapper.selectByPrimaryKey(1l);

this.newUserMapper.insertSelective(user);

this.newUserMapper.delete(param);

this.newUserMapper.updateByPrimaryKey(user);

this.newUserMapper.updateByPrimaryKeySelective(user);

this.newUserMapper.delete(param);