eclipse maven+mybatis+web项目(三)

最新推荐文章于 2024-05-03 14:50:22 发布

丧尸会跳小芭蕾

最新推荐文章于 2024-05-03 14:50:22 发布

阅读量424

点赞数 1

文章标签： mybatis maven eclipse

本文链接：https://blog.csdn.net/qq_26725075/article/details/52456354

版权

实现CRUD

在user.mapper.xml里写SQL语句

<?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="cn.qdsoft.dao.UserDAO">
    <select id="findAll" resultType="User">
        select
        id,name,email,password,birthdate,gender,province from users
    </select>
    <select id="findById" resultType="User">
        select
        id,name,email,password,birthdate,gender,province from users
        where
        id=#{id}
    </select>
    <update id="update">
        update users
        set
            name=#{name},email=#{email},gender=#{gender},
            birthdate=#{birthdate},province=#{province}
        where id=#{id}
    </update>
    <insert id="add" parameterType="User">
        INSERT INTO users (
            name,
            email,
            gender,
            birthdate,
            province
        ) VALUES (
            #{name},
            #{email},
            #{gender},
            #{birthdate},
            #{province}
        )
    </insert>
    <delete id="del" parameterType="Long">
        DELETE FROM users WHERE id = #{id}
    </delete>
</mapper>

编写页面
这里写图片描述

add.jsp

<%@ page pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html >
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
<title>用户列表</title>

<!-- Bootstrap -->
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    <h2>添加用户信息</h2>
    <form class="form-horizontal" method="post" action="add.do">
        <div class="form-group">
            <label for="name" class="col-sm-2 control-label">姓名</label>
            <div class="col-sm-10">
                <input type="text" class="form-control" id="name" name='name'>
            </div>
        </div>
        <div class="form-group">
            <label for="email" class="col-sm-2 control-label">电子邮件</label>
            <div class="col-sm-10">
                <input type="email" class="form-control" id="email" name='email'>
            </div>
        </div>
        <div class="form-group">
            <label for="birthdate" class="col-sm-2 control-label">出生日期</label>
            <div class="col-sm-10">
                <input type="date" class="form-control" id="birthdate"
                    name='birthdate'>
            </div>
        </div>
        <div class="form-group">
            <label class="col-sm-2 control-label">性别</label>
            <div class="col-sm-10">
                <label class="radio-inline"> <input type="radio"
                    name="gender"  value="M" checked>男
                </label> <label class="radio-inline"> <input type="radio"
                    name="gender" value="F">女
                </label>
            </div>
        </div>
        <div class="form-group">
            <label for="province" class="col-sm-2 control-label">省份</label>
            <div class="col-sm-10">
                <select class="form-control" id="province" name='province'>
                    <c:forEach items="${provinces }" var='p'>
                        <option value="${p.id }">${p.name }</option>
                    </c:forEach>
                </select>
            </div>
        </div>
        <div class="form-group">
            <div class="col-sm-offset-2 col-sm-10">
                <button type="submit" class="btn btn-primary">保存用户信息</button>
            </div>
        </div>
    </form>
</body>
</html>

edit.jsp

<%@ page pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
<title>用户列表</title>

<!-- Bootstrap -->
<link href="../bootstrap/css/bootstrap.css" rel="stylesheet">

</head>
<body>
    <form action="edit.do" method="post" class="form-horizontal">
        <input type="hidden" name="id" value="${user.id }">
        <div class="form-group">
            <label for="name" class="col-sm-2 control-label">用户名</label>
            <div class="col-sm-10">
                <input type="text" name="name" class="form-control"
                    value="${user.name }" id="name">
            </div>
        </div>
        <div class="form-group">
            <label for="email" class="col-sm-2 control-label">电子邮件</label>
            <div class="col-sm-10">
                <input type="email" name="email" class='form-control'
                    value="${user.email }" id="email">
            </div>
        </div>
        <div class="form-group">
            <label for="birthdate" class="col-sm-2 control-label">出生日期</label>
            <div class="col-sm-10">
                <input type="date" name="birthdate" class='form-control'
                    value="${user.birthdate }" id="birthdate">
            </div>
        </div>

        <div class="form-group">
            <div class="col-sm-offset-2 col-sm-10">
                <input type="submit" class="btn btn-primary" value="修改">
            </div>
        </div>
    </form>

</body>
</html>

list.jsp

<%@ page pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
<title>用户列表</title>

<!-- Bootstrap -->
<link href="../bootstrap/css/bootstrap.css" rel="stylesheet">

</head>
<body>

    <table class='table  table-bordered table-hover table-striped'>
        <thead>
            <tr>
                <th>姓名</th>
                <th>电子邮件</th>
                <th>出生日期</th>
                <th>性别</th>
                <th>省份</th>
                <th></th>
            </tr>
        </thead>
        <tbody>
            <c:forEach items="${users }" var="p">
                <tr>
                    <td>${p.name }</td>
                    <td>${p.email }</td>
                    <td>${p.birthdate }</td>
                    <td><c:if test="${p.gender eq 'M' }">男</c:if> <c:if
                            test="${p.gender eq 'F' }">女</c:if></td>
                    <!--  el中不会出现空指针异常 -->
                    <td>${ provincesMap[p.province].name }</td>
                    <td><a href="edit.do?id=${p.id}">修改</a></td>
                    <td><a href="del.do?id=${p.id}">删除</a></td>
                </tr>
            </c:forEach>
        </tbody>
    </table>
</body>
</html>

update.jsp

<%@ page pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html >
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
<title>用户列表</title>

<!-- Bootstrap -->
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    <h2>添加用户信息</h2>
    <form class="form-horizontal" method="post" action="update.do">
        <div class="form-group">
            <label for="name" class="col-sm-2 control-label">账号</label>
            <div class="col-sm-10">
                <input type="text" class="form-control" id="name" name='account'>
            </div>
        </div>
        <div class="form-group">
            <label for="email" class="col-sm-2 control-label">密码</label>
            <div class="col-sm-10">
                <input type="email" class="form-control" id="email" name='psw'>
            </div>
        </div>
        <div class="form-group">
            <div class="col-sm-offset-2 col-sm-10">
                <button type="submit" class="btn btn-primary">查询</button>
            </div>
        </div>
    </form>
</body>
</html>

获取页面name参数值

这里写图片描述

WebUtil.java

package cn.qdsoft.util;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Date;

public class WebUtil {
    //  获取页面的name参数
    public static Long getLong(HttpServletRequest req, String name) {
        String str = req.getParameter(name);
        return Long.valueOf(str);
    }

    public static String getString(HttpServletRequest req, String name) {
        return req.getParameter(name);
    }

    public static Date getDate(HttpServletRequest req, String name) {
        String str = req.getParameter(name);
        return Date.valueOf(str);
    }

    public static void redirect(HttpServletRequest req, HttpServletResponse resp, String url) throws IOException {
        String contextPath = req.getContextPath();
        resp.sendRedirect(contextPath + url);

    }

    public static int getInt(HttpServletRequest req, String name) {
        // TODO Auto-generated method stub
        String str = req.getParameter(name);
        return Integer.parseInt(str);
    }
}

编写对应的servlet
这里写图片描述

UserAddServlet.java

package cn.qdsoft.web;

import java.io.IOException;

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 org.apache.ibatis.session.SqlSession;
import cn.qdsoft.dao.ProvinceDAO;
import cn.qdsoft.dao.UserDAO;
import cn.qdsoft.model.User;
import cn.qdsoft.util.WebUtil;
import cn.qdsoft.util.MyBatisUtil;

@WebServlet("/user/add.do")
public class UserAddServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        try (SqlSession ssn = MyBatisUtil.open()) {
            ProvinceDAO provinceDAO = ssn.getMapper(ProvinceDAO.class);
            req.setAttribute("provinces", provinceDAO.findAll());
            req.getRequestDispatcher("add.jsp").forward(req, resp);
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        try (SqlSession ssn = MyBatisUtil.open()) {
            User user = new User();
            user.setName(WebUtil.getString(req, "name"));
            user.setEmail(WebUtil.getString(req, "email"));
            user.setBirthdate(WebUtil.getDate(req, "birthdate"));
            user.setGender(WebUtil.getString(req, "gender"));
            user.setProvince(WebUtil.getLong(req, "province"));
            UserDAO userDao = ssn.getMapper(UserDAO.class);
            userDao.add(user);
            // 删除修改添加
            ssn.commit();
            WebUtil.redirect(req, resp, "/user/list.do");
        }
    }
}

UserEditServlet.java

package cn.qdsoft.web;

import java.io.IOException;
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 org.apache.ibatis.session.SqlSession;
import cn.qdsoft.util.MyBatisUtil;
import cn.qdsoft.util.WebUtil;
import cn.qdsoft.dao.UserDAO;
import cn.qdsoft.model.User;

@WebServlet("/user/edit.do")
public class UserEditServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Long id = WebUtil.getLong(req, "id");
        try (SqlSession session = MyBatisUtil.open()) {
            UserDAO userDAO = session.getMapper(UserDAO.class);
            User user = userDAO.findById(id);
            req.setAttribute("user", user);
            req.getRequestDispatcher("edit.jsp").forward(req, resp);
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Long id = WebUtil.getLong(req, "id");
        try (SqlSession ssn = MyBatisUtil.open()) {
            UserDAO userDAO = ssn.getMapper(UserDAO.class);
            User u = userDAO.findById(id);
            u.setName(WebUtil.getString(req, "name"));
            u.setEmail(WebUtil.getString(req, "email"));
            u.setBirthdate(WebUtil.getDate(req, "birthdate"));
//          u.setGender(WebUtil.getString(req, "gender"));
//          u.setProvince(WebUtil.getLong(req, "province"));
            userDAO.update(u);
            ssn.commit();
            WebUtil.redirect(req, resp, "/user/list.do");
        }
    }
}

UserListServlet.java

package cn.qdsoft.web;

import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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 org.apache.ibatis.session.SqlSession;

import cn.qdsoft.util.MyBatisUtil;
import cn.qdsoft.dao.BookDAO;
import cn.qdsoft.dao.ProvinceDAO;
import cn.qdsoft.dao.UserDAO;
import cn.qdsoft.model.Book;
import cn.qdsoft.model.Province;
import cn.qdsoft.model.User;

@WebServlet("/user/list.do")
public class UserListServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try (SqlSession session = MyBatisUtil.open()) {
            // 从数据库取出所有用户
            UserDAO dao = session.getMapper(UserDAO.class);
            ProvinceDAO provinceDAO = session.getMapper(ProvinceDAO.class);
            List<Province> provinces = provinceDAO.findAll();
            Map<Long, Province> provincesMap = new HashMap<>();

            //省份
            for (Province p : provinces) {
                provincesMap.put(p.getId(), p);  //键值对
            }

            List<User> lists = dao.findAll();
            // 保存到request对象
            req.setAttribute("users", lists);
            req.setAttribute("provincesMap", provincesMap);
        }

        // 转发到 list.jsp
        req.getRequestDispatcher("list.jsp").forward(req, resp);

    }
}

UserUpdateServlet.java

package cn.qdsoft.web;

import java.io.IOException;
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 org.apache.ibatis.session.SqlSession;
import cn.qdsoft.dao.ProvinceDAO;
import cn.qdsoft.dao.UserDAO;
import cn.qdsoft.model.User;
import cn.qdsoft.util.WebUtil;
import cn.qdsoft.util.MyBatisUtil;

@WebServlet("/user/update.do")
public class UserUpdateServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        try (SqlSession ssn = MyBatisUtil.open()) {
            req.getRequestDispatcher("update.jsp").forward(req, resp);
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        try (SqlSession ssn = MyBatisUtil.open()) {
            User user = new User();
            user.setName(WebUtil.getString(req, "account"));
            user.setEmail(WebUtil.getString(req, "psw"));
            UserDAO userDao = ssn.getMapper(UserDAO.class);
            userDao.add(user);
            // 删除修改添加
            ssn.commit();
            WebUtil.redirect(req, resp, "/user/list.do");
        }
    }
}

UserDelServlet.java

package cn.qdsoft.web;

import java.io.IOException;

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 org.apache.ibatis.session.SqlSession;
import cn.qdsoft.dao.UserDAO;
import cn.qdsoft.util.WebUtil;
import cn.qdsoft.util.MyBatisUtil;

@WebServlet("/user/del.do")
public class UserDelServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Long id = WebUtil.getLong(req, "id");
        try (SqlSession ssn = MyBatisUtil.open()) {
            UserDAO userDAO = ssn.getMapper(UserDAO.class);
            userDAO.del(id);
            ssn.commit();
            WebUtil.redirect(req, resp, "/user/list.do");
        }
    }
}

丧尸会跳小芭蕾

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
eclipse maven+mybatis+web项目(三)

实现CRUD在user.mapper.xml里写SQL语句<?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="cn.qd
复制链接

扫一扫