2020.04.26 三层架构练习1

UserdaoImpl：

package com.aojie.dao.impl;

import com.aojie.dao.UserDao;
import com.aojie.domain.User;
import com.aojie.util.JDBCUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

/**
 * @author aojie
 * @fuction
 * @create 2020-04-26 20:56
 */
public class UserDaoImpl implements UserDao {
    private JdbcTemplate jdbcTemplate=new JdbcTemplate(JDBCUtils.getDatasouce());
    @Override
    public List<User> findAll() {
        //使用JDBC操作数据库
        try {
            String sql="select * from day17.user";
            List<User> user = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
            return user;
        } catch (DataAccessException e) {
            return null;
        }
    }

    @Override
    public boolean deleteUser(User user) {
        String sql="delete from day17.user where id=?";
        int update = jdbcTemplate.update(sql, new BeanPropertyRowMapper<User>(User.class), user.getId());
        if (update == 1) {
            return true;
        }else {
            return false;
        }
    }
}
UserLIstServlet：

package com.aojie.web.Servlet;

import com.aojie.domain.User;
import com.aojie.service.UserService;
import com.aojie.service.impl.UserServiceImpl;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @author aojie
 * @fuction
 * @create 2020-04-26 20:51
 */
@WebServlet("/UserListServlet")
public class UserListServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.调用UserService完成查询
        UserService service=new UserServiceImpl();
        List<User> userList = service.findAll();
        request.setAttribute("userList",userList);
        request.getRequestDispatcher("/list.jsp").forward(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}