• 日期数据类型为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>
  • 相关阅读:
    python微信公众号开发学习记录
    python 机器学习中模型评估和调参
    python 机器学习中的数据处理学习记录
    python中selenium操作下拉滚动条方法汇总
    解决jenkins下使用HTML Publisher插件后查看html报告显示不正常
    python nose测试框架全面介绍四
    python nose测试框架全面介绍三
    python nose测试框架全面介绍二
    python nose测试框架全面介绍一
    jmeter BeanShell实例-----两个变量之间的断言对比
  • 原文地址:https://www.cnblogs.com/NCL--/p/9273960.html
Copyright © 2020-2023  润新知