一 ,UserDao.xml
1.在xml文件新建一个标签<sql id="sqlWhere"></sql> 把先前where标签直接放入这个sql标签
2.在sql标签加入新标签if <if test="id !=null">
and id = #{id}
</if>
<if test="realname !=null and realname !=''">
and realname like concat('%',#(realname),'%')<!-- '%'#(realname)'%' -->
</if>
3.xml文件加入标签insert (增加)
<insert id="create" parameterType="user">
insert into user(username,pwd,realname)
values (#{username},#{pwd},#{realname})
</insert>
4.加入修改标签update
<update id="update" parameterType="user">
update user set
<set>
<if test="username!=null and username!=''">
pwd = #{pwd},
</if>
<if test="username!=null and username!=''">
realname = #{realname},
</if>
</set>
where id = #{id}
<!-- username = #(username),pwd=#{pwd}
where id = #{id}
-->
</update>
5.delete标签
<delete id="delete" parameterType="integer">
delete from user where id = #{id}
</delete>
6.批量操作 利用遍历完成的操作
<update id ="updateBatch" parameterType="list">
update user set pwd = '123' where id in
<foreach item ="item" index ="index" collection ="list" open = "(
separator=","close=")">
#{item}
</foreach>
</update>
二. Dao层的配置
package com.zq.dao;
import java.util.List;
import com.zq.model.User;
public interface UserDao {
public List<User> list(User user);
public void create(User user);
public void update(User user);
public void delete(Integer id);
public void updateBatch(List<Integer> list);
}
三. Service层的配置接口
package com.zq.service;
import java.util.List;
import com.zq.model.User;
public interface UserService {
public List<User> list(User user);
public void create(User user);
public void update(User user);
public void delete(Integer id);
public void updateBatch(List<Integer> list);
}
四.ServiceImpl加入新方法
@Override
public void create(User user){
userDao.create(user);
}
@Override
public void update(User user){
userDao.update(user);
}
@Override
public void delete(Integer id){
userDao.delete(id);
}
@Override
public void updateBatch(List<Integer>list){
userDao.updateBatch(list);
}
五.Controller
@ResponseBody
@RequestMapping("/create.do")
public boolean create(User user){
try{
userService.create(user);
}catch(Exception e){
System.out.println(e.getMessage());
return false;
}
return true;
}
六.src目录下新建file 添加对自己代码的日志打印级别
# Global logging configuration
log4j.rootLogger=ERROR, stdout
# stdout\u4E3A\u8F93\u51FA\u6A21\u5F0F\u7684\u540D\u5B57
# MyBatis logging configuration...
log4j.logger.com.zq=DEBUG
# \u65E5\u5FD7\u6253\u5370\u7684\u4F4D\u7F6E\uFF1A\u63A7\u5236\u53F0
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
# \u6253\u5370\u65E5\u5FD7\u7684\u5F62\u5F0F\u3001\u683C\u5F0F
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n