基于spring+mybatis框架的管理系统：简单实现增、删、改、查。(一)

最新推荐文章于 2021-08-31 10:55:59 发布

weixin_45622439

最新推荐文章于 2021-08-31 10:55:59 发布

阅读量809

点赞数 1

本文链接：https://blog.csdn.net/weixin_45622439/article/details/102551041

版权

一、

1.New Project,选择Maven——>勾选Creat…复选框，如下图所示：
在这里插入图片描述

点击加号

2.创建下图所示空包

在这里插入图片描述
3.在bean包内创建User.java

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 + '\'' +
                '}';
    }
}

4.在dao包内创建IUserDao接口

package com.zhongruan.dao;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserDao {
    List<User> findAll();
     User selectByUserName(String name);
    void deleteById(int id);
    void updateById(User user);
    void insert(User user);
}

5.在service包内创建IUserService接口

package com.zhongruan.service;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserService {
    List<User> findAll();
    Boolean login(String username,String password);
    void deleteById(int id);
    void updateById(User user);
    void insert(User user);
}

6.在service包内创建impl包，在这个包内新建UserService.java

package com.zhongruan.service.impl;

import com.zhongruan.dao.IUserDao;
import com.zhongruan.bean.User;
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 List<User> findAll() {
        return userDao.findAll();
    }


  @Override
  public Boolean login(String username, String password) {
   User user=userDao.selectByUserName(username);

   if (user!=null && password.equals(user.getPassword())){
     return true;
   }
    return false;
  }

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

    @Override
    public void updateById(User user) {
         userDao.updateById(user);
    }

    @Override
    public void insert(User user) {
        userDao.insert(user);
    }
}

7.UserMapper.xml放在resources的mapper包下

<?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="findAll" resultType="com.zhongruan.bean.User">
        select * from tb_user
    </select>

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

    <delete id="deleteById" parameterType="int">
        delete from tb_user where id=#{id}
    </delete>

    <update id="updateById" parameterType="com.zhongruan.bean.User">
        update tb_user set username=#{username},password=#{password} where id=#{id}
    </update>

    <insert id="insert" parameterType="com.zhongruan.bean.User">
        insert  into tb_user(username,password) value (#{username},#{password})
    </insert>
</mapper>

二、前端页面

在这里插入图片描述
1.web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">

  <display-name>Archetype Created Web Application</display-name>

  <!-- 配置加载类路径的配置文件 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath*:applicationContext.xml</param-value>
  </context-param>

  <!-- 配置监听器 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
  </listener>

  <!-- 前端控制器（加载classpath:spring-mvc.xml 服务器启动创建servlet） -->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 配置初始化参数，创建完DispatcherServlet对象，加载springmvc.xml配置文件 -->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-mvc.xml</param-value>
    </init-param>
    <!-- 服务器启动的时候，让DispatcherServlet对象创建 -->
    <load-on-startup>1</load-on-startup>
  </servlet>

  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>


</web-app>

2.index.jsp（登入页面）

<%--
  Created by IntelliJ IDEA.
  User: MyPC
  Date: 2019/9/26
  Time: 15:59
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>小笼包</title>

    <link rel="stylesheet" href="css/font-awesome.min.css"/>
    <link rel="stylesheet" href="css/loginMy.css"/>

    <style>
        html,body{width:100%;}
    </style>

</head>
<body>

<div class="main">

    <div class="center">
        <form action="/login.do" id="formOne" method="post"onsubmit="return submitB()" >
            <i class="fa fa-user Cone">  | </i>
            <input type="text" name="username" id="user" placeholder="用户名"onblur="checkUser()"/>
            <span id="user_pass"></span>
            <br/>
            <i class="fa fa-key Cone">  | </i>
            <input type="password" name="password" id="pwd" placeholder="密码"onblur="checkUser1()"/>
            <span id="pwd_pass"></span>
            <br/>
                    <input type="submit" value="登录" id="submit" name="submit">
            <br/>
        </form>
    </div>

</div>
</body>
</html>

3.allUsre.jsp(列表页面)

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<html>
<head>
    <title>列表</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- 引入 Bootstrap -->
    <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body style="background-image:url(image/sa.jpg);background-size:100% ">
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1 style="color: white">
                    基于spring+mybatis框架的管理系统：简单实现增、删、改、查。
                </h1>
            </div>
        </div>
    </div>

    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1>
                    <small style="color: #9AFFFB">用户列表 —— 显示所有用户</small>
                </h1>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-4 column">
            <a class="btn btn-primary" href="addUser.jsp">新增用户</a>
        </div>
        <form action="/findByPage" method="post">
            <input name="searchname" type="text"/>
            <input type="submit" value="搜索"/>
        </form>
    </div>
   <br/>
    <div class="row clearfix">
        <div class="col-md-12 column">
            <table class="table table-hover table-striped">
                <thead>
                <tr>
                    <th style="color: #9AFFFB">id</th>
                    <th style="color: #9AFFFB">用户名</th>
                    <th style="color: #9AFFFB">密码</th>
                    <th style="color: #9AFFFB">操作</th>
                </tr>
                </thead>
                <tbody>
                <c:forEach var="user" items="${users}">
                    <tr>
                        <td style="color: cornflowerblue ">${user.id}</td>
                        <td>${user.username}</td>
                        <td>${user.password}</td>
                        <td>
                            <a href="/delete.do?id=${user.id}">删除</a>|
                            <a href="/update.do?id=${user.id}">修改</a>
                        </td>
                    </tr>
                </c:forEach>

                </tbody>
            </table>
        </div>
    </div>
    <div>
        <a href="/findByPage?currentPage=1&size=5">首页</a>


        <c:if test="${pageInfo.currentPage==1}">
            <a href="/findByPage?currentPage=1&size=5">上一页</a>
        </c:if>
        <c:if test="${pageInfo.currentPage>1}">
            <a href="/findByPage?currentPage=${pageInfo.currentPage-1}&size=5">上一页</a>
        </c:if>


        <c:forEach begin="1" end="${pageInfo. totalPage}" var="i">
            <a href="/findByPage?currentPage=${i}&size=5">${i}</a>
        </c:forEach>


        <c:if test="${pageInfo.currentPage==pageInfo.totalPage}">
            <a href="/findByPage?currentPage=${pageInfo.totalPage}&size=5">下一页</a>
        </c:if>
        <c:if test="${pageInfo.currentPage<pageInfo.totalPage}">
            <a href="/findByPage?currentPage=${pageInfo.currentPage+1}&size=5">下一页</a>
        </c:if>


        <a href="/findByPage?currentPage=${pageInfo.totalPage}&size=5">尾页</a>
    </div>
</div>

4.addUser.jsp(新增页面)

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<html>
<head>
    <title>新增用户</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- 引入 Bootstrap -->
    <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body style="background-image:url(image/zhsy.jpg);background-size: 100% ;color: white">
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1>
                    基于spring+mybatis框架的管理系统：简单实现增、删、改、查。
                </h1>
            </div>
        </div>
    </div>

    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1 style="color: white">
                    <small style="color: white">新增用户</small>
                </h1>
            </div>
        </div>
    </div>
    <form action="/insert.do" method="post">
        <%--用&nbsp;&nbsp;户&nbsp;&nbsp;id：<input type="text" name="id"><br><br><br>--%>
        用户姓名：<input type="text" name="username" style="color: black"><br><br><br>
        用户密码：<input type="text" name="password" style="color: black"><br><br><br>
        <input type="submit" value="添加" style="color: black">
    </form>

</div>

5.updateUser.jsp(修改页面)

<%--
  Created by IntelliJ IDEA.
  User: MyPC
  Date: 2019/9/29
  Time: 14:45
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- 引入 Bootstrap -->
    <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body style="background-image:url(image/sa.jpg);background-size: 100%">

<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1>
                    基于spring+mybatis框架的管理系统：简单实现增、删、改、查。
                </h1>
            </div>
        </div>
    </div>

    <div class="row clearfix">
        <div class="col-md-12 column">
            <div class="page-header">
                <h1>
                    <small>修改用户</small>
                </h1>
            </div>
        </div>
    </div>
    <form action="/update.do" method="post">
        <input type="hidden" name="id" value="${user.id}"><br><br><br>
        用户姓名：<input type="text" name="username" value="${user.username}"><br><br><br>
        用户密码：<input type="text" name="password" value="${user.password}"><br><br><br>
        <input type="submit" value="更改" >
    </form>
</div>
</body>
</html>

6.failure.jsp（登入失败跳转页面）

<%--
  Created by IntelliJ IDEA.
  User: MyPC
  Date: 2019/9/25
  Time: 11:05
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
登入失败
</body>
</html>