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 );