在上次框架上修改UserMapper.xml,新增代码
<delete id="deleteById" parameterType="Integer">
delete from user where id=#{
id}
</delete>
<insert id="add" parameterType="User">
insert into user(name,password) values(#{
name},#{
password})
</insert>
<select id="findAll" resultType="User">
select * from user
</select>
修改UserDao
public interface UserDao {
User findUserByName(String name);
List<User> findAll();
int deleteById(Integer id);
int add(User user);
}
修改UserService
public interface UserService {
boolean login(String name,String password);
boolean delete(Integer id);
List<User> findAll();
boolean add(String name, String password);
}
修改UserController
package com.zr0707.controller;
import com.zr0707.bean.User;
import com.zr0707.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List