• Mybatis Mapper.xml 需要查询返回List<String>


    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.xinwei.process.dao.RoleServiceTypeMapper" >
      <resultMap id="BaseResultMap" type="com.xinwei.process.entity.RoleServiceType" >
        <id column="id" property="id" jdbcType="BIGINT" />
        <result column="role_id" property="roleId" jdbcType="INTEGER" />
        <result column="service_type" property="serviceType" jdbcType="VARCHAR" />
      </resultMap>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >
        delete from tb_role_service_type
        where id = #{id,jdbcType=BIGINT}
      </delete>
      <insert id="insert" parameterType="com.xinwei.process.entity.RoleServiceType" >
        insert into tb_role_service_type (id, role_id, service_type
          )
        values (#{id,jdbcType=BIGINT}, #{roleId,jdbcType=INTEGER}, #{serviceType,jdbcType=VARCHAR}
          )
      </insert>
      <update id="updateByPrimaryKey" parameterType="com.xinwei.process.entity.RoleServiceType" >
        update tb_role_service_type
        set role_id = #{roleId,jdbcType=INTEGER},
          service_type = #{serviceType,jdbcType=VARCHAR}
        where id = #{id,jdbcType=BIGINT}
      </update>
      <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
        select id, role_id, service_type
        from tb_role_service_type
        where id = #{id,jdbcType=BIGINT}
      </select>
      <select id="selectAll" resultMap="BaseResultMap" >
        select id, role_id, service_type
        from tb_role_service_type
      </select>


     <select id="selectServiceTypeListByRole"  resultType="java.lang.String">
        select service_type
        from tb_role_service_type
        where role_id = #{roleId,jdbcType=INTEGER}
      </select>

     

    </mapper>


  • 相关阅读:
    Oracle EBS AR 收款调整取值
    Oracle EBS GL 创建会计科目
    Oracle EBS 应收事务处理取值
    Oracle EBS 应收发票取值
    Oracle EBS AR 收款核销行关联到事务处理
    art-template渲染真实数据--后台接口(难度:3颗星)
    art-template渲染简单数据(难度:1颗星)
    art-template渲染数据示例(难度:2颗星)
    使用jQuery渲染一般数据
    如何使用git,github?
  • 原文地址:https://www.cnblogs.com/alamps/p/6442493.html
Copyright © 2020-2023  润新知