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) <= :endDateprivate static String smsSql = "SELECT count(1) FROM (SELECT a.phone FROM cl_sms a LEFT JOIN cl_...