phoenix的增删改查
1、定义返回数据类型
1 <resultMap id="collectMap" type="com.example.back.entity.Collect"> 2 <id column="id" property="id"></id> 3 <result column="xin_xaing" property="xin_xaing"></result> 4 <result column="fa_ren" property="fa_ren"></result> 5 <result column="you_bian" property="you_bian"></result> 6 <result column="dian_hua" property="dian_hua"></result> 7 8 </resultMap>
2、增
1 <update id="addCollect" parameterType="com.example.back.entity.Collect"> UPSERT INTO information_collect VALUES (NEXT VALUE FOR seq_1,#{ji_guo_name}) </update>
3、删
1 <delete id="deleteCollect" parameterType="com.example.back.entity.Collect"> DELETE FROM information_collect WHERE id=#{id} </delete>
4、改
1 <update id="updateCollect" parameterType="com.example.back.entity.Collect"> UPSERT INTO information_collect VALUES (#{id}, #{ji_guo_name}) </update>
5、查
1 <select id="getAllCollect" resultMap="collectMap"> 2 SELECT * FROM information_collect 3 </select>
6、模糊查询
1 <select id="getOneCollect" resultMap="collectMap"> 2 SELECT * FROM information_collect WHERE 3 (#{ji_guo_name} IS NULL OR ji_guo_name LIKE '%' || #{ji_guo_name} || '%') AND 4 (#{di_yu} IS NULL OR di_yu LIKE '%' || #{di_yu} || '%') AND 5 (#{ji_shu_name} IS NULL OR ji_shu_name LIKE '%' || #{ji_shu_name} || '%') AND 6 (#{guan_jian_zi} IS NULL OR guan_jian_zi LIKE '%' || #{guan_jian_zi} || '%') 7 8 </select>
