MyBatis - 1.3

public void update(Village village)
   {
	   SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
	   session.update("com.rlab.mappers.VillageMapper.updatevillage",village);
	   session.commit();
	   session.close();
   }

<mapper namespace = "com.rlab.mappers.VillageMapper">
     
     <update id="updatevillage" parameterType = "Village">
           UPDATE village SET name=#{name},district=#{district}WHERE id= #{id}
     </update>
     
</mapper>

public interface PersonMapper {

	Person insertPerson(Person person);
	Person findPersonById(Integer id);
	List<Person> findAllPersons();
	Person updatePerson(Person person);
	void removePerson(Integer idPerson);

}

<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="br.com.erudio.mappers.PersonMapper">

    <update id="updatePerson" parameterType="Person">
      update person set
      firstName = #{firstName}
      ,lastName = #{lastName}
      ,address = #{address}
      where id = #{idPerson}
    </update>
    
</mapper>

public interface UserAnnotationMapper {
	
	@Insert("insert into users(name,email) values(#{name},#{email})")
	@SelectKey(statement = "call identity()", keyProperty = "id", before = false, resultType = Integer.class)
	void insertUser(User user);

	@Select("select id, name, email from users WHERE id=#{id}")
	User findUserById(Integer id);

	@Select("select id, name, email from users")
	List<User> findAllUsers();

}

public interface AddressMapper {
	
	@InsertProvider(type = AddressServiceImpl.class, method = "dynamicSQL")
	int insertProvider(String record_);
}

import com.yzx.shop.user.entity.User;
import tk.mybatis.mapper.common.Mapper;

public interface UserMapper extends Mapper<User> {
}

import javax.persistence.Table;

@Table(name = "tb_user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
}

@Service
public class UserServiceImpl implements UserService {

    @Resource
    private UserMapper userMapper;

    @Override
    public Boolean checkUserData(String data, Integer type) {
        User record=new User();
        if(type==1){
            record.setUsername(data);
        }else if(type==2){
            record.setPhone(data);
        }else {
            return null;
        }
        return userMapper.selectCount(record)==0;
    }

}

import com.yzx.shop.item.entity.Stock;
import tk.mybatis.mapper.common.Mapper;

public interface StockMapper extends Mapper<Stock> {
}

import javax.persistence.Table;

@Table(name = "tb_stock")
public class Stock {
    @Id
    private Long skuId;

    public Long getSkuId() {
        return skuId;
    }
}

@Service
public class GoodsServiceImpl implements GoodsService {

    @Resource
    private StockMapper stockMapper;

    @Override
    @Transactional
    public void updateGoods(SpuBo spuBo) {
        Sku record=new Sku();
        record.setSpuId(spuBo.getId());
        List<Sku> skuList=skuMapper.select(record);

        skuList.forEach(s->{
            stockMapper.deleteByPrimaryKey(s.getId());
            skuMapper.deleteByPrimaryKey(s.getId());
        });

        spuBo.setLastUpdateTime(new Date());
        spuMapper.updateByPrimaryKeySelective(spuBo);
        spuDetailMapper.updateByPrimaryKey(spuBo.getSpuDetail());

        insertSkusBySpuBo(spuBo);
        sendMsg(MSG_UPDATA,spuBo.getId());
    }
}

import tk.mybatis.mapper.common.Mapper;

public abstract class BaseService<T> implements IService<T> {

	protected final Logger logger = LoggerFactory.getLogger(this.getClass());

	@Autowired
	protected Mapper<T> mapper;

	public Mapper<T> getMapper() {
		return mapper;
	}

    @Override
	public int batchSave(List<T> list) {
		int result = 0;
		for (T record : list) {
			int count = mapper.insertSelective(record);
			result += count;
		}
		return result;
	}

public static string FindDepartment(int deptId){

        ISqlMapper mapper = EntityMapper;
        string str = mapper.QueryForObject<string>("FindDepartment", deptId);
        return str;


        }

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="MyBatisApp" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  
  <statements>
    <statement id="FindDepartment" parameterClass="System.Int32" resultClass="System.String" >
      SELECT Name
      FROM Department
      WHERE Id =  #value#
    </statement>

</sqlMap>