项目运行问题

xibo0925 2017-03-15 02:15:13

...全文

294 6 打赏收藏举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

xibo0925 2017-03-17

打赏
举报

引用 3 楼 u011731233 的回复:

看看是不是验证类型没指定

能具体点吗

xibo0925 2017-03-16

打赏
举报

引用 3 楼 u011731233 的回复:

看看是不是验证类型没指定

具体怎么看验证类型指定没指定

xibo0925 2017-03-16

打赏
举报

引用 2 楼 u011731233 的回复:

toolBy的配置文件

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.thinkgem.jeesite.modules.wm.dao.WmBorrowDao"> <sql id="wmBorrowColumns"> a.id AS "id", a.tool_by AS "toolBy.id", a.out_date AS "outDate", a.return_date AS "returnDate", a.purpose AS "purpose", a.use_address AS "useAddress", a.out_user AS "outUser.id", a.apply_return_user AS "applyReturnUser.id", a.apply_return_time AS "applyReturnTime", a.delay_num AS "delayNum", a.delay_reasion AS "delayReasion", a.alarm_flag AS "alarmFlag", a.confirm_user AS "confirmUser.id", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.confirm_time AS "confirmTime", a.status AS "status", u7.name AS "outUser.name", u8.name AS "applyReturnUser.name", u13.name AS "confirmUser.name", u14.name AS "createBy.name", u16.name AS "updateBy.name", u17.name AS "toolBy.name" </sql> <sql id="wmBorrowJoins"> LEFT JOIN sys_user u7 ON u7.id = a.out_user LEFT JOIN sys_user u8 ON u8.id = a.apply_return_user LEFT JOIN sys_user u13 ON u13.id = a.confirm_user LEFT JOIN sys_user u14 ON u14.id = a.create_by LEFT JOIN sys_user u16 ON u16.id = a.update_by LEFT JOIN wm_tool u17 ON u17.id = a.tool_by </sql> <select id="get" resultType="WmBorrow"> SELECT <include refid="wmBorrowColumns"/> FROM wm_borrow a <include refid="wmBorrowJoins"/> WHERE a.id = #{id} </select> <select id="findList" resultType="WmBorrow"> SELECT <include refid="wmBorrowColumns"/> FROM wm_borrow a <include refid="wmBorrowJoins"/> <where> a.del_flag = #{DEL_FLAG_NORMAL} <if test="toolBy != null and toolBy != ''"> AND a.tool_by LIKE <if test="dbName == 'oracle'">'%'||#{toolBy.id}||'%'</if> <if test="dbName == 'mssql'">'%'+#{toolBy.id}+'%'</if> <if test="dbName == 'mysql'">concat('%',#{toolBy.id},'%')</if> </if> <if test="beginOutDate != null and endOutDate != null and beginOutDate != '' and endOutDate != ''"> AND a.out_date BETWEEN #{beginOutDate} AND #{endOutDate} </if> <if test="outUser != null and outUser.id != null and outUser.id != ''"> AND a.out_user = #{outUser.id} </if> <if test="alarmFlag != null and alarmFlag != ''"> AND a.alarm_flag = #{alarmFlag} </if> </where> <choose> <when test="page !=null and page.orderBy != null and page.orderBy != ''"> ORDER BY ${page.orderBy} </when> <otherwise> ORDER BY a.update_date DESC </otherwise> </choose> </select> <select id="findAllList" resultType="WmBorrow"> SELECT <include refid="wmBorrowColumns"/> FROM wm_borrow a <include refid="wmBorrowJoins"/> <where> a.del_flag = #{DEL_FLAG_NORMAL} </where> <choose> <when test="page !=null and page.orderBy != null and page.orderBy != ''"> ORDER BY ${page.orderBy} </when> <otherwise> ORDER BY a.update_date DESC </otherwise> </choose> </select> <insert id="insert"> INSERT INTO wm_borrow( id, tool_by, out_date, return_date, purpose, use_address, out_user, apply_return_user, apply_return_time, delay_num, delay_reasion, confirm_user, create_by, create_date, update_by, update_date, remarks, del_flag, confirm_time, status ) VALUES ( #{id}, #{toolBy.id}, #{outDate}, #{returnDate}, #{purpose}, #{useAddress}, #{outUser.id}, #{applyReturnUser.id}, #{applyReturnTime}, #{delayNum}, #{delayReasion}, #{confirmUser.id}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{confirmTime}, #{status} ) </insert> <update id="update"> UPDATE wm_borrow SET tool_by = #{toolBy.id}, out_date = #{outDate}, return_date = #{returnDate}, purpose = #{purpose}, use_address = #{useAddress}, out_user = #{outUser.id}, apply_return_user = #{applyReturnUser.id}, apply_return_time = #{applyReturnTime}, delay_num = #{delayNum}, delay_reasion = #{delayReasion}, confirm_user = #{confirmUser.id}, create_by = #{createBy.id}, create_date = #{createDate}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, confirm_time = #{confirmTime}, status = #{status} WHERE id = #{id} </update> <update id="delete"> UPDATE wm_borrow SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} </update> </mapper>