#### 新增一條數據 Mapper接口 ``` //插入數據 - 可修改返回值類型 void insertWell(Map<String,Object> param)throws Exception; ``` Mapper.xml ``` <!--插入數據--> <insert id="insertWell" parameterType="java.util.HashMap"> INSERT INTO RTOC_ARTIFICIAL_MONTH <trim prefix="(" suffix=")" suffixOverrides=","> <if test="ARTIFICIAL_MONTH_ID!=null and ARTIFICIAL_MONTH_ID!=''">ARTIFICIAL_MONTH_ID,</if> <!--oracle日期轉換--> <if test="STARTDRILL_TIME!=null and STARTDRILL_TIME!=''"> STARTDRILL_TIME, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="ARTIFICIAL_MONTH_ID!=null and ARTIFICIAL_MONTH_ID!=''">#{ARTIFICIAL_MONTH_ID},</if> <!--oracle日期轉換--> <if test="STARTDRILL_TIME!=null and STARTDRILL_TIME!=''"> to_date(#{STARTDRILL_TIME} , 'yyyy-mm-dd hh24:mi:ss'), </if> </trim> </insert> ``` #### foreach字段添加 ``` <insert id="insert" parameterType="hashmap"> insert into ${_tableName} ( <foreach collection="data" index="colName" item="colValue" separator=",">${colName}</foreach> ) values ( <foreach collection="data" index="colName" item="colValue" separator=",">#{colValue}</foreach> ) </insert> ``` #### Mybatis批量插入到oracle ``` void insertOracle(List<Map<String,Object>> wellInfos); ``` ``` <insert id="insertOracle" parameterType="java.util.Map" useGeneratedKeys="false"> INSERT ALL <foreach item="item" index="index" collection="list"> INTO RTOC_WELLBOREID_RTDDATA ( ID, WELL_ID, WELLBORE_ID, WELL_DEPTH, TIME, TIMESTAMP, DATA ) VALUES ( #{item.id}, #{item.wellId}, #{item.wellboreId}, #{item.wellDepth}, #{item.time}, #{item.timeStamp}, #{item.data} ) </foreach> SELECT 1 FROM DUAL </insert> ```