SSM整合单表的mapper映射文件

Mapper的接口
public interface UserMapper {
public User selectone(String name);
public List<User> selectAll();
public void insert(User user);
public void delete(Integer id);
public void update(User user);
}

<?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.dao.UserMapper">
    <select id="selectone" parameterType="string" resultType="user">
        select * from t_user where username=#{username}
    </select>
    <select id="selectAll" resultType="user">
        select * from t_user
    </select>
    <insert id="insert" parameterType="user">
        insert into t_user(username,password,email)
        value(#{username},#{password},#{email})
    </insert>
    <delete id="delete" parameterType="int">
    delete from t_user where id=#{id}
    </delete>
    <update id="update" parameterType="user">
    update t_user set username=#{username},password=#{password},email=#{email} where id=#{id}</update>

</mapper>

service的接口

public interface UserService {
public void insert(User user);
public void delete(Integer id);
public void update(User user);
public User selectone(String name);
public List<User> selectAll();
}

service的实现类

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.bawei.dao.UserMapper;
import com.bawei.pojo.User;
import com.bawei.service.UserService;
@Service
public class UserServiceImpl implements UserService{
@Autowired
private UserMapper um;
    @Override
    public void insert(User user) {
        
         um.insert(user);
    }

    @Override
    public void delete(Integer id) {
        um.delete(id);
    }

    @Override
    public User selectone(String name) {
        return um.selectone(name);
    }

    @Override
    public List<User> selectAll() {
        return um.selectAll();
    }

    @Override
    public void update(User user) {
        um.update(user);
        
    }

}

ssm的控制层controllrt

import java.lang.ProcessBuilder.Redirect;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.bawei.pojo.User;
import com.bawei.service.UserService;
@Controller
@RequestMapping("user")
public class UserController {
    @Autowired
    private UserService service;
    @RequestMapping("getUserList")
    public String getUserList(Model model){
        System.out.println("nihao");
        List<User> list = service.selectAll();
        model.addAttribute("list", list);
        return "userList";
    }
    @RequestMapping("insert")
    @ResponseBody
    public String insert(User user){
        try {
            service.insert(user);
            return "ok";
        } catch (Exception e) {
            return "error";
        }
        
    }
    @RequestMapping("register")
    @ResponseBody  
    public String register(User user,Model model){
            User user1 = service.selectone(user.getUsername());
            System.out.println("zoudaol");
            if(user1!=null){
                return "ok";
            }else
            return "用户名存在";
        }
    @RequestMapping("delete")
    public String delete(Integer id){
        System.out.println("nihao");
    service.delete(id);
        return "redirect:/user/getUserList.do";
    }
    @RequestMapping("login")
    public String login(User user){
        System.out.println("nihao");
    User user2=service.selectone(user.getUsername());
    if(user2!=null&&user.getPassword().equals(user2.getPassword())){    
        return "redirect:/user/getUserList.do";
    }
    else
    return "erro";    
    
    }
    @RequestMapping("batchDelete")
    public String batchDelete(String[] ids){
        for (String string : ids) {
            service.delete(Integer.parseInt(string));
        }
        return "redirect:/user/getUserList.do";
    }
}