mybatis 传参数处置保存数据

mybatis 传参数处理保存数据

1.dao xml配置

    <select id="menuList" resultType="com.zjy.cms.pojo.Menu" >
        select 
            menu_id as menuId,
	        menu_name as menuName,
	        menu_url as menuUrl,
	        menu_order as menuOrder,
	        date_format(menu_cretime,'%Y-%m-%d-%T') as menuCreTime,
	        menu_status  as menuStatus
        from menu
        where 1=1
        <if test="menuName!=null and menuName!=''" >
          and menu_name=#{menuName}
        </if>
    </select>
    
    <insert id="addMenuObj" useGeneratedKeys="true" keyProperty="menuId" parameterType="com.zjy.cms.pojo.Menu">
     insert into menu 
     (menu_name,menu_url,menu_order,menu_cretime,menu_status)
	 values(#{menuName},#{menuUrl},#{menuOrder},SYSDATE(),#{menuStatus})
    </insert>
    
    <insert id="addMenuParam" >
     insert into menu 
     (menu_name,menu_url,menu_order,menu_cretime,menu_status)
	 values(#{menuName},#{menuUrl},#{menuOrder},SYSDATE(),#{menuStatus})
    </insert>

2.dao 接口

   public List<Menu> menuList(@Param("menuName")String menuName);
   public void addMenuObj(Menu menu);
   
   public void addMenuParam(
		   @Param("menuName")String menuName,
		   @Param("menuUrl") String menuUrl,
		   @Param("menuOrder") String menuOrder,
		   @Param("menuStatus") String menuStatus
		   );