ssm查询删除

文件夹设置

User代码

package com.zhongruan.bean;

public class User {

    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

UserController代码

package com.zhongruan.controller;

import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
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;

@Controller
public class UserController {
    @Autowired
    private IUserService userService;



    @RequestMapping("/findAll.do")
    public ModelAndView findAll(){
        List<User> users = userService.findAll();
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.setViewName("allUser.jsp");
        modelAndView.addObject("users",users);
        return modelAndView;

    }}

IUserDao代码

package com.zhongruan.dao;

import com.zhongruan.bean.User;


import java.util.List;

public interface IUserDao {
    List<User>findAll();
    User selectByUserName(String username);
    //User selectById(int id);
    void deleteById(int id);
    void add(User user);
    void update(User user);

}

UserService代码

package com.zhongruan.service.impl;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService implements IUserService {

    @Autowired
    private IUserDao userDao;



    @Override
    public Boolean login(String username,String password) {
        User user=userDao.selectByUserName(username);
        if(null!=user && password.equals(user.getPassword())){
            return true;
        }else {
            return false;
        }
    }






/*   @Override
    public User selectById(int id) {
        return userDao.selectById(id);
    }*/




    @Override
    public List<User> findAll() {
        return userDao.findAll();
    }

    @Override
    public void deleteById(int id) {
        userDao.deleteById(id);

    }}

IUserService代码

package com.zhongruan.service;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserService {
    Boolean  login(String username,String password);
    //User selectById(int id);



    List<User> findAll();


    void deleteById(int id);}

UserMapper.xml代码

<?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.zhongruan.dao.IUserDao">

    <select id=" selectById" parameterType="int" resultType="com.zhongruan.bean.User">
        select * from tb_user where id=#{id}
    </select>


    <select id="findAll" resultType="com.zhongruan.bean.User">
        select * from tb_user
    </select>
    <delete id="deleteById" parameterType="int">
        delete from tb_user where id=#{id}
    </delete>
    <update id="update" parameterType="com.zhongruan.bean.User">
       update tb_user set username=#{username},password=#{password} where id=#{id}
    </update>
    <update id="add" parameterType="com.zhongruan.bean.User">
        insert into tb_user(username,password)values(#{username},#{password})
    </update>
    <select id="selectByUserName" parameterType="String" resultType="com.zhongruan.bean.User">
        select * from tb_user where username=#{username}
    </select>




</mapper>

结果