日期数据类型为Date ,前台传递喂String的后台处理

方法一:

在实体类里面将set方法里面将数据类型转为Date

 public void setBirth(String birth) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        try {
            this.birth = sdf.parse(birth);
        } catch (ParseException e) {
            e.printStackTrace();
        }
    }

这样就可以了

注意在修改是判断是否为空的时候不能写birth!=“”,否则报java.util.Date and java.lang.String 的错

<if test="birth!= null">
                birth = #{birth},
            </if>

 

方法二:

实体类改为String类型,在xml里面改数据类型

<insert id="insert" parameterType="实体类">
        INSERT INTO
        table(id,idtype,idno,name,sex,phone,birth,nation,degree,native_type,native_place,address,first_job_year,emp_type,emp_form,start_date)
            VALUES(#{id},#{idtype},#{idno},#{name},#{sex},#{phone},DATE_FORMAT(#{birth},'%Y-%m-%d'),#{nation},#{degree},#{nativeType},#{nativePlace},#{address},#{firstJobYear},#{empType},#{empForm},DATE_FORMAT(#{startDate},'%Y-%m-%d'))
    </insert>-->
<update id="update" parameterType="实体类">
        update table
        <trim prefix="SET" suffixOverrides="," suffix="WHERE id = #{id}" >
        <if test="idtype!= null and idtype != ''">
                idtype = #{idtype},
            </if>
            <if test="idno!= null and idno != ''">
                idno = #{idno},
            </if>
            <if test="name!= null and name != ''">
                name = #{name},
            </if>
            <if test="sex!= null and sex != ''">
                sex = #{sex},
            </if>
            <if test="phone!= null and phone != ''">
                phone = #{phone},
            </if>
            <if test="birth!= null and birth != ''">
                birth = DATE_FORMAT(#{birth},'%Y-%m-%d'),
            </if>
            <if test="nation != null and nation != ''">
                nation = #{nation},
            </if>
            <if test="degree!= null and degree != ''">
                degree = #{degree},
            </if>
            <if test="nativeType!= null and nativeType != ''">
                native_type = #{nativeType},
            </if>
            <if test="nativePlace!= null and nativePlace != ''">
                native_place = #{nativePlace},
            </if>
            <if test="address!= null and address != ''">
                address = #{address},
            </if>
            <if test="firstJobYear!= null and firstJobYear != ''">
                first_job_year = #{firstJobYear},
            </if>
            <if test="empType!= null and empType != ''">
                emp_type = #{empType},
            </if>
            <if test="empForm!= null and empForm != ''">
                emp_form = #{empForm},
            </if>
            <if test="startDate!= null and startDate != ''">
                start_date = DATE_FORMAT(#{startDate},'%Y-%m-%d'),
            </if>
        </trim>
    </update>

 

posted @ 2018-07-06 15:45  *眉间缘*  阅读(1840)  评论(0编辑  收藏  举报