cherry_xiu的博客

查询语句 <!--返回Map--> <resultMap id="BaseResultMap" type="com.rongdu.cashloan.rule.domain.RuleInfo"> <id column="id" property="id" jdbcType="BIGINT&quot

1.将参数封装到map集合中（用param.） service层 String tableName = "userData"; Map<String,Object> params = new HashMap<>(); params.put("userId", userId); params.put("name", name); List<UserData&gt..

第一种 <update id="updateByPrimaryKey" parameterType="com.jxl.manado.model.MaUser"> update ma_user set name = #{name,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR} w...

前提：查询的时间范围为传入的参数 原sql语句传参date(a.send_time) >= :startDate AND date(a.send_time) <= :endDate private static String smsSql = "SELECT count(1) FROM (SELECT a.phone FROM cl_sms a LEFT JOIN cl_...