# datasource spring.datasource.url=jdbc:mysql://abc.com:3306/data-collector-dev?useUnicode=true spring.datasource.username=dataservice spring.datasource.password=Data12345 spring.datasource.driver-class-name=com.mysql.jdbc.Driver # mybatis mybatis.config-location=classpath:/mybatis/mybatis-config.xml mybatis.typeAliasesPackage=com.du.test.dal.domain spring.mybatis.config=classpath:/sqlmap-config.xml spring.mybatis.scan-base-package=com.du.test.dal.dao

 

sqlmap-config.xml ：

 

 

mybatis-config.xml

 

TaskMapper.xml

     
         
      
               select        id,        data_schemaId as dataSchemaId,        data_source_id as dataSourceId,        data_target_id as dataTargetId,        type as type,        trans_mode as transMode,        status as status,        gmt_create as gmtCreate,        gmt_modified as gmtModified    
          
          
                      from task WHERE id = #{id} and status in (0,1)        
          
      
               insert into task (data_schemaId, data_source_id, data_target_id, type, trans_mode, status, gmt_create, gmt_modified)        values        (#{dataSchemaId}, #{dataSourceId}, #{dataTargetId}, #{type}, #{transMode}, #{status}, 1, now(), now())        
       
                    select LAST_INSERT_ID();        
           
          
          
      
               update task        set        gmt_modified = now()        
       
                    ,type = #{type}        
               
       
                    ,trans_mode = #{transMode}        
               
       
                    ,data_schema_id = #{dataSchemaId}        
               
       
                    ,data_target_id = #{dataTargetId}        
               
       
                    ,data_source_id = #{dataSourceId}        
               
       
                    ,status = #{status}        
               WHERE        id = #{id}    
          
          
      
               update task        set        gmt_modified = now()        ,status = -1        WHERE        id = #{id}    
      
     

 

TaskMapper

package com.du.test.dal.dao;import com.aliyun.alios.datacollector.dal.domain.TaskDO;import org.apache.ibatis.annotations.Mapper;@Mapperpublic interface TaskMapper {    /**     * insert     * @param taskDO     * @return     */    Long insert(TaskDO taskDO);    /**     * insert     * @param taskDO     * @return     */    Long update(TaskDO taskDO);    /**     * delete     * @param id     */    Long delete(Long id);    /**     * getById     * @param id     */    TaskDO getById(Long id);}

 

 

mybatis.typeAliasesPackage=com.du.test.dal.domain 指定了mapper.xml中类型的前缀，如下图中的resultType=“TaskDO”，就没有指定类名称的全路径。