MyBatis - 1.3

 package com.alibaba.cobar.client;

import java.sql.SQLException;
import java.util.Collection;

import com.ibatis.sqlmap.client.SqlMapExecutor;


public class CobarSqlMapClientDaoSupport {

public int batchUpdate(final String statementName, final Collection<?> entities)
            throws DataAccessException {
         {
            return (Integer) getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
                public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
                    executor.startBatch();
                    for (Object parameterObject : entities) {
                        executor.update("com.alibaba.cobar.client.entities.Offer.update", parameterObject);
                    }
                    return executor.executeBatch();
                }
            });
        }
    }
}

<sqlMap namespace="com.alibaba.cobar.client.entities.Offer">
     
     <update id="update">
		UPDATE offers SET subject=#subject#, gmtUpdated=#gmtUpdated# WHERE id=#id#
	</update>
     
</sqlMap>

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>

package com.alibaba.doris.admin.dao.impl;

import java.util.HashMap;
import java.util.Map;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.alibaba.doris.admin.dao.ConsistentReportDao;


public class ConsistentReportDaoImpl extends SqlMapClientDaoSupport implements ConsistentReportDao {

    public Integer deleteByGmtCreate(String gmtCreateFrom, String gmtCreateTo) {
        Map<String, String> params = new HashMap<String, String>(2);
        params.put("gmtCreateFrom", gmtCreateFrom);
        params.put("gmtCreateTo", gmtCreateTo);
        return getSqlMapClientTemplate().delete("CONSISTENT_REPORT.deleteByGmtCreate", params);
    }

}

<sqlMap namespace = "CONSISTENT_REPORT">

    <delete id="deleteByGmtCreate" parameterClass="map" >
        DELETE FROM CONSISTENT_REPORT 
        WHERE <![CDATA[ gmt_create >= #gmtCreateFrom:VARCHAR# and gmt_create <= #gmtCreateTo:VARCHAR# ]]>
    </delete>

</sqlMap>

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>