JavaWeb小项目练习(基于三层架构实现登录，对表增，删，改，查的操作)

已于 2024-01-02 13:11:36 修改
阅读量509 收藏 9
点赞数 9
文章标签： java 前端 开发语言
于 2024-01-02 12:59:30 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_74007708/article/details/135275340
版权

 一 创建项目并修改项目结构

File->New->Project新建一个名为javaweb01的工程

1

2

javaweb01->New->Module新建一个名为MyManage的模块

1

2

将MyManage模块设置为支持web项目

1

2

将web项目重命名并移动到main路径下

配置pom文件(文件依赖,打包方式,以及支持加载的文件)

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>com.by</groupId>
        <artifactId>javaweb</artifactId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <artifactId>MyManage</artifactId>
<!--    项目打包方式-->
    <packaging>war</packaging>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
<!--        依赖Servlet-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>

<!--        依赖Mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
<!--        依赖mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
<!--        依赖log4j-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
<!--        依赖jsp-api-->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
        </dependency>
<!--       依赖jstl-->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    </dependencies>
    <build>
        <!-- 如果不添加此节点src/main/java目录下的所有配置文件都会被漏掉。 -->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <!--让idea识别resources目录-->
            <resource>
                <directory>src/main/resources</directory>
            </resource>
        </resources>
    </build>

</project>

二 使用三层架构和配置文件以及Tomcat服务器

创建三层架构的包(表现层)servlet,(业务逻辑层)service serviceimpl,(数据访问层)mapper

加载配置文件(数据库配置文件,日志文件,MyBatis配置文件)

数据库配置文件db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3305/servlet?characterEncoding=UTF-8
jdbc.username=root
jdbc.password=

日志文件log4j.properties

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

MyBatis配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="db.properties"></properties>
    <typeAliases>
        <package name="com.by.pojo"/>
    </typeAliases>
    <!-- 数据库连接信息 -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 扫描映射文件 -->
    <mappers>
<!--        <mapper resource="com/by/dao/UserDao.xml"/>-->
        <package name="com.by.mapper"/>
    </mappers>
</configuration>

项目结构

Tomcat服务器

1

2

3

4

5

6

7

8

9

三 监听和过滤

监听器

SqlSession回话实例从始至终都使用,所以在将SqlSession装在ServletContext里边

新建com->by->listener->MyServletContxtListenerlei

public class MyServletContxtListener implements ServletContextListener {

    @Override
    public void contextInitialized(ServletContextEvent servletContextEvent) {
        try {
            //加载配置文件
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);

            //创建SessionFactory
            SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

            //使用数据的会话实例
            SqlSession sqlSession = sessionFactory.openSession();
            //把sqlSession对象撞到servletContext中
            ServletContext servletContext = servletContextEvent.getServletContext();
            servletContext.setAttribute("sqlSession", sqlSession);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @Override
    public void contextDestroyed(ServletContextEvent servletContextEvent) {

    }
}

web.xml

<!--配置监听器-->
    <listener>
        <listener-class>com.by.listener.MyServletContxtListener</listener-class>
    </listener>

过滤器

因为文件请求和响应需要防止字符编码格式不一样而导致乱码,所以我们采用过滤器技术过滤每一个servlet文件

新建com->by->filter->CharacterEncodingFilter

public class CharacterEncodingFilter implements Filter {

    @Override
    public void init(FilterConfig filterConfig) throws ServletException {

    }
    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        //请求中文乱码
        servletRequest.setCharacterEncoding("utf-8");
        //响应中文乱码
        servletResponse.setContentType("text/html;charset=utf-8");
        //放行filter
        filterChain.doFilter(servletRequest, servletResponse);
    }

    @Override
    public void destroy() {

    }
}

pojo包下新建User类

package com.by.pojo;

public class User {
    private Integer id;
    private String username;
    private String password;
    private String sex;
    private String address;
    private Integer age;

    public User(Integer id, String username, String password, String sex, Integer age, String address) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.sex = sex;
        this.address = address;
        this.age = age;
    }

    public User(String username, String password, String sex, Integer age, String address) {
        this.username = username;
        this.password = password;
        this.sex = sex;
        this.address = address;
        this.age = age;
    }

    public User() {
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer 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;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

web.xml

<!--    过滤器-->
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>com.by.filter.CharacterEncodingFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <!--*代表任意请求-->
        <url-pattern>/*</url-pattern>
    </filter-mapping>

三 登录验证并查询数据表内容

login.jsp

<%--
  Created by IntelliJ IDEA.
  User: 21309
  Date: 2023-12-27
  Time: 16: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>
  <h1>用户管理系统</h1>
  <form action="login" method="post">
    账号：<input type="text" name="username"><br>
    密码：<input type="text" name="password"><br>
    <input type="submit" value="登录">
  </form>
  </body>
</html>

web.xml

<!--设置欢迎页为Login.jsp-->
    <welcome-file-list>
        <welcome-file>login.jsp</welcome-file>
    </welcome-file-list>

在servlet包下新建LoginServlet

//表现层
public class LoginServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //根据input标签的name属性获取前端提交的参数
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        //调用service
        UserService userService = new UserServiceImpl(this);
        //将获得的username，password传递给User
        User user=userService.login(username,password);
        //登录判断
        if (user!=null){
        //如果登录成功，则跳转到select_user.jsp
        resp.sendRedirect("selectUserServlet");
        }else {
        //如果登录失败，则跳转到login.jsp
        req.getRequestDispatcher("login.jsp").forward(req,resp);
        }
    }
}

web.xml

<!--login页-->
    <servlet>
        <servlet-name>login</servlet-name>
        <servlet-class>com.by.servlet.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>login</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {
    User login(String username, String password);
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }
@Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
     User login(@Param("username") String username, @Param("password") String password);
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
</mapper>

登陆页面要要跳到select_user.jsp页面

在servlet包下新建SelectUserServlet

public class SelectUserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //调用UserService查询List<User>
        UserService userService = new UserServiceImpl(this);
        List<User> userList = userService.selectUser();

        //把List<User>送到select_user.jsp
        req.setAttribute("userList", userList);
        req.getRequestDispatcher("select_user.jsp").forward(req, resp);
    }
}

web.xml

<!--    selectUserServlet-->
    <servlet>
        <servlet-name>selectUserServlet</servlet-name>
        <servlet-class>com.by.servlet.SelectUserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>selectUserServlet</servlet-name>
        <url-pattern>/selectUserServlet</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {

    User login(String username, String password);

    List<User> selectUser();
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }

    @Override
    public List<User> selectUser() {
        return userMapper.selectUser();
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
    User login(@Param("username") String username, @Param("password") String password);

    List<User> selectUser();
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
</mapper>

测试结果

1

2

四 新增数据

在select_user.jsp添加新增链接

新建add_user.jsp

<%--
  Created by IntelliJ IDEA.
  User: Hero
  Date: 2023/12/29
  Time: 11:01
  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>
<h1>新增</h1>
<form action="addUser" method="post">
    账号：<input type="text" name="username"><br>
    密码：<input type="text" name="password"><br>
    性别：<input type="text" name="sex"><br>
    年龄：<input type="text" name="age"><br>
    地址：<input type="text" name="address"><br>
    <input type="submit" value=" 新  增 ">
</form>
</body>
</html>

在servlet包下新建addUser

public class addUser extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1、接收参数
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        String sex = req.getParameter("sex");
        Integer age = Integer.valueOf(req.getParameter("age"));
        String address = req.getParameter("address");
        User user = new User(username, password, sex, age, address);

        //2、调用service，把user保存到数据库
        UserService userService = new UserServiceImpl(this);
        userService.addUser(user);

        //3、重定向到SelectUserServlet
        resp.sendRedirect("selectUserServlet");
    }
}

web.xml

<!--    addUser-->
    <servlet>
        <servlet-name>addUser</servlet-name>
        <servlet-class>com.by.servlet.addUser</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>addUser</servlet-name>
        <url-pattern>/addUser</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {

    User login(String username, String password);

    List<User> selectUser();

    void addUser(User user);
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }

    @Override
    public List<User> selectUser() {
        return userMapper.selectUser();
    }

    @Override
    public void addUser(User user) {
        userMapper.addUser(user);
        sqlSession.commit();
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
    User login(@Param("username") String username, @Param("password") String password);

    List<User> selectUser();

    void addUser(User user);
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
<!--   insert-->
    <insert id="addUser" parameterType="com.by.pojo.User">
        INSERT INTO user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                username,
            </if>
            <if test="password!=null and password!=''">
                password,
            </if>
            <if test="sex!=null and sex!=''">
                sex,
            </if>
            <if test="age!=null">
                age,
            </if>
            <if test="address!=null and address!=''">
                address,
            </if>
        </trim>
        VALUES
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                #{username},
            </if>
            <if test="password!=null and password!=''">
                #{password},
            </if>
            <if test="sex!=null and sex!=''">
                #{sex},
            </if>
            <if test="age!=null">
                #{age},
            </if>
            <if test="address!=null and address!=''">
                #{address},
            </if>
        </trim>
    </insert>
</mapper>

测试结果

1

2

五 删除数据

在select_user.jsp添加删除链接

在servlet包下新建DeleteUserServlet

public class UpdateUserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1、接收参数
        Integer id = Integer.valueOf(req.getParameter("id"));
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        String sex = req.getParameter("sex");
        Integer age = Integer.valueOf(req.getParameter("age"));
        String address = req.getParameter("address");
        User user = new User(id, username, password, sex, age, address);

        //2、调用service，修改user
        UserService userService = new UserServiceImpl(this);
        userService.updateUserById(user);

        //3、重定向到SelectUserServlet
        resp.sendRedirect("selectUserServlet");
    }
}

web.xml

 <!--    delete-->
    <servlet>
        <servlet-name>deleteUser</servlet-name>
        <servlet-class>com.by.servlet.DeleteUserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>deleteUser</servlet-name>
        <url-pattern>/deleteUser</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {

    User login(String username, String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }

    @Override
    public List<User> selectUser() {
        return userMapper.selectUser();
    }

    @Override
    public void addUser(User user) {
        userMapper.addUser(user);
        sqlSession.commit();
    }

    @Override
    public void deleteUser(Integer id) {
        userMapper.deleteUser(id);
        sqlSession.commit();
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
    User login(@Param("username") String username, @Param("password") String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
<!--   insert-->
    <insert id="addUser" parameterType="com.by.pojo.User">
        INSERT INTO user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                username,
            </if>
            <if test="password!=null and password!=''">
                password,
            </if>
            <if test="sex!=null and sex!=''">
                sex,
            </if>
            <if test="age!=null">
                age,
            </if>
            <if test="address!=null and address!=''">
                address,
            </if>
        </trim>
        VALUES
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                #{username},
            </if>
            <if test="password!=null and password!=''">
                #{password},
            </if>
            <if test="sex!=null and sex!=''">
                #{sex},
            </if>
            <if test="age!=null">
                #{age},
            </if>
            <if test="address!=null and address!=''">
                #{address},
            </if>
        </trim>
    </insert>
<!--    delete-->
    <delete id="deleteUser" parameterType="int">
        DELETE FROM user WHERE id=#{id}
    </delete>
</mapper>

测试结果

六 更新数据

在select_user.jsp增加修改链接

修改数据首先要获取被修改的数据

获取被修改的数据

在servlet包下新建GetUserServlet

public class GetUserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1、接收参数
        Integer id = Integer.valueOf(req.getParameter("id"));
        //2、调用service，根据id查询user
        UserService userService = new UserServiceImpl(this);
        User user = userService.getUserById(id);

        //3、user送到update_user.jsp
        req.setAttribute("user", user);
        req.getRequestDispatcher("update_user.jsp").forward(req, resp);
    }
}

web.xml

 <!--    GetUserServlet-->
    <servlet>
        <servlet-name>getUserServlet</servlet-name>
        <servlet-class>com.by.servlet.GetUserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>getUserServlet</servlet-name>
        <url-pattern>/getUserById</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {

    User login(String username, String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);

    User getUserById(Integer id);
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }

    @Override
    public List<User> selectUser() {
        return userMapper.selectUser();
    }

    @Override
    public void addUser(User user) {
        userMapper.addUser(user);
        sqlSession.commit();
    }

    @Override
    public void deleteUser(Integer id) {
        userMapper.deleteUser(id);
        sqlSession.commit();
    }

    @Override
    public User getUserById(Integer id) {
        return userMapper.getUserById(id);
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
    User login(@Param("username") String username, @Param("password") String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);

    User getUserById(Integer id);
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
<!--   insert-->
    <insert id="addUser" parameterType="com.by.pojo.User">
        INSERT INTO user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                username,
            </if>
            <if test="password!=null and password!=''">
                password,
            </if>
            <if test="sex!=null and sex!=''">
                sex,
            </if>
            <if test="age!=null">
                age,
            </if>
            <if test="address!=null and address!=''">
                address,
            </if>
        </trim>
        VALUES
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                #{username},
            </if>
            <if test="password!=null and password!=''">
                #{password},
            </if>
            <if test="sex!=null and sex!=''">
                #{sex},
            </if>
            <if test="age!=null">
                #{age},
            </if>
            <if test="address!=null and address!=''">
                #{address},
            </if>
        </trim>
    </insert>
<!--    delete-->
    <delete id="deleteUser" parameterType="int">
        DELETE FROM user WHERE id=#{id}
    </delete>
<!--getdata-->
    <select id="getUserById" parameterType="int" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE id=#{id}
    </select>
</mapper>

测试结果

修改数据

在servlet包下新建UpdateUserServlet

public class UpdateUserServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1、接收参数
        Integer id = Integer.valueOf(req.getParameter("id"));
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        String sex = req.getParameter("sex");
        Integer age = Integer.valueOf(req.getParameter("age"));
        String address = req.getParameter("address");
        User user = new User(id, username, password, sex, age, address);

        //2、调用service，修改user
        UserService userService = new UserServiceImpl(this);
        userService.updateUserById(user);

        //3、重定向到SelectUserServlet
        resp.sendRedirect("selectUserServlet");
    }
}

web.xml

<!--    UpdateUserServlet-->
    <servlet>
        <servlet-name>updateUserById</servlet-name>
        <servlet-class>com.by.servlet.UpdateUserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>updateUserById</servlet-name>
        <url-pattern>/updateUserById</url-pattern>
    </servlet-mapping>

以下内容可在servlet类中Alt+Enter快捷键出来(先把Servlet类写完整)

在service包下的UserService接口

public interface UserService {

    User login(String username, String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);

    User getUserById(Integer id);

    void updateUserById(User user);
}

UserServiceImpl类

public class UserServiceImpl implements UserService {
    private SqlSession sqlSession;
    private UserMapper userMapper;
    //加载UserMapper类
    public UserServiceImpl(HttpServlet httpServlet) {
        ServletContext servletContext = httpServlet.getServletContext();
        sqlSession = (SqlSession) servletContext.getAttribute("sqlSession");
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Override
    public User login(String username, String password) {
        //调用dao
        return userMapper.login(username,password);
    }

    @Override
    public List<User> selectUser() {
        return userMapper.selectUser();
    }

    @Override
    public void addUser(User user) {
        userMapper.addUser(user);
        sqlSession.commit();
    }

    @Override
    public void deleteUser(Integer id) {
        userMapper.deleteUser(id);
        sqlSession.commit();
    }

    @Override
    public User getUserById(Integer id) {
        return userMapper.getUserById(id);
    }

    @Override
    public void updateUserById(User user) {
        userMapper.updateUserById(user);
        sqlSession.commit();
    }
}

mapper包下的UserMapper接口

public interface UserMapper {
    User login(@Param("username") String username, @Param("password") String password);

    List<User> selectUser();

    void addUser(User user);

    void deleteUser(Integer id);

    User getUserById(Integer id);

    void updateUserById(User user);
}

mapper包下的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.by.mapper.UserMapper">
    <select id="login" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE username=#{username} AND password=#{password}
    </select>
    <select id="selectUser" resultType="com.by.pojo.User">
        SELECT * FROM user
    </select>
<!--   insert-->
    <insert id="addUser" parameterType="com.by.pojo.User">
        INSERT INTO user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                username,
            </if>
            <if test="password!=null and password!=''">
                password,
            </if>
            <if test="sex!=null and sex!=''">
                sex,
            </if>
            <if test="age!=null">
                age,
            </if>
            <if test="address!=null and address!=''">
                address,
            </if>
        </trim>
        VALUES
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="username!=null and username!=''">
                #{username},
            </if>
            <if test="password!=null and password!=''">
                #{password},
            </if>
            <if test="sex!=null and sex!=''">
                #{sex},
            </if>
            <if test="age!=null">
                #{age},
            </if>
            <if test="address!=null and address!=''">
                #{address},
            </if>
        </trim>
    </insert>
<!--    delete-->
    <delete id="deleteUser" parameterType="int">
        DELETE FROM user WHERE id=#{id}
    </delete>
<!--getdata-->
    <select id="getUserById" parameterType="int" resultType="com.by.pojo.User">
        SELECT * FROM user WHERE id=#{id}
    </select>
<!--    updata-->
    <update id="updateUserById" parameterType="com.by.pojo.User">
        UPDATE user
        <set>
            <if test="username!=null and username!=''">
                username=#{username},
            </if>
            <if test="password!=null and password!=''">
                password=#{password},
            </if>
            <if test="sex!=null and sex!=''">
                sex=#{sex},
            </if>
            <if test="age!=null">
                age=#{age},
            </if>
            <if test="address!=null and address!=''">
                address=#{address},
            </if>
        </set>
        WHERE id=#{id}
    </update>
</mapper>

测试结果

1

2

七 最终项目结构

1

2

冰冰很社恐
关注
  • 9
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
SMBMS项目(登陆注销)
醉痴糜
09-25 1131
数据库： 项目如何搭建？ 考虑使用不使用Maven？ 依赖，Jar 项目搭建准备工作 搭建一个maven web项目 配置Tomcat 测试项目是否能够跑起来 导入项目中会遇到的jar包； jsp,Servlet,mysql驱动，jstl，stand… 创建项目包结构 编写实体类； ORM映射：表-类映射 编写基础公共类 数据库配置文件 driver=co...
【JavaWeb】Java三层架构写一个登录案例
wang_qiu_hao的博客
10-18 921
Java三层架构
JavaWeb实现登录与注册的功能(三)：使用三层架构
qq_250161537
09-04 1万+
在前面的两篇文章中，完成了基础的登录与注册功能。接下来会介绍如何使用三层架构的方式来完成登录与注册功能的实现。 那么，什么是三层架构？为什么要使用三层架构？ 三层架构：通常意义上的三层架构就是将整个业务应用划分为：界面层（User Interface layer, UIL）、业务逻辑层（Business Logic Layer, BLL）、数据访问层（Data access layer, DAL）...
Java研学-三层架构实现简单登录操作
最新发布
zhlyxx的博客
01-11 1180
将服务器资源给有权限的人访问，只有登录的管理员可以访问员工信息进行 CRUD。
javaweb三层架构实现用户登录实例.rar
11-16
javaweb三层架构实现用户登录实例.rarjavaweb三层架构实现用户登录实例.rarjavaweb三层架构实现用户登录实例.rarjavaweb三层架构实现用户登录实例.rarjavaweb三层架构实现用户登录实例.rar
基于三层框架的JavaWeb项目实现登录验证，并对表数据进行增，删，改，查
01-02
本教程是一个0基础创建一个基于三层架构的JavaWeb项目，从创建项目到实现对数据库表数据进行增删改查操作。本教程侧重于培养编程习惯，详细讲解了三层架构的编写顺序，讲解了如何快速编写一整个，从头至尾的详细...
简单的jsp课程大作业，采用MVC模式，三层架构，实现增删改查等基础操作
01-03
这是一个基于JSP的课程大作业项目，主要采用了MVC（Model-View-Controller）模式，构建了三层架构，即表现层、业务逻辑层和数据访问层，以实现基础的数据库操作，包括添加、删除、修改和查询。这个系统旨在模拟后台...
javaweb极简登录注册增删改查
06-19
在Java Web开发中，"javaweb极简登录注册增删改查"是一个常见的实践项目，它涵盖了Web应用的基本功能，包括用户身份验证（登录、注册）、数据操作（增、删、改、查）。这个项目可能使用了Java Servlet、JSP（Java...
超级简单javaweb项目SSM用户管理登录注册查询添加删除修改操作.rar（含源码）
05-20
整合教材中的例题，形成自己的一个小型的web项目，保证能够实现对指定数据库表的增删改查操作。要求：若增添注册、登录等额外功能（用户要有自己的数据库表users(字段：用户名、密码)，注册即为向users数据库表进行...
javaweb增删改查（含源码）.zip
01-24
本资源"javaweb增删改查（含源码）.zip"提供了从基础到进阶的JavaWeb应用实例，主要涵盖了JSP、Servlet以及MVC设计模式的运用，旨在帮助开发者理解如何在实际项目中实现数据的增删改查操作。 首先，JSP（JavaServer...
（一）JavaWeb实现用户登录注册功能（超详细版）---登录
qq_64995702的博客
12-07 8947
Web层，Service层，Dao层。Web层：负责前端展示和用户请求的处理。Service层：对Dao层的数据操作进行组合和封装，实现更高层次的业务逻辑。验证逻辑：Service层可以对用户输入的用户名和密码进行验证。检查用户名和密码是否为空、是否符合规定的格式要求，以及与数据库中存储的用户信息进行比对验证等。通过Service层的验证逻辑，可以确保用户输入的凭据是有效和正确的。加密和解密：在用户登录中，密码需要进行加密存储提高安全性。
JavaWeb三层架构详解
热门推荐
a549654065的博客
10-15 5万+
什么是三层架构？ 三层架构(3-tier architecture) 通常意义上的三层架构就是将整个业务应用划分为：界面层（User Interface layer）、业务逻辑层（Business Logic Layer）、数据访问层（Data access layer）。区分层次的目的即为了“高内聚低耦合”的思想。在软件体系架构设计中，分层式结构是最常见，也是最重要的一种结构。微软推荐的分...
JavaWeb-对用户登录验证的三层架构分析
迷失的星星的博客
11-21 2056
三层架构的概念: 三层架构(3-tier application) 通常意义上的三层架构就是将整个业务应用划分为：表现层（UI）、业务逻辑层（BLL）、数据访问层（DAL）。区分层次的目的即为了“高内聚，低耦合”的思想. １、表现层（UI）：通俗讲就是展现给用户的界面，即用户在使用一个系统的时候他的所见所得。 ２、业务逻辑层（BLL）：针对具体问题的操作，也可以说是对数据层的操作，对数据业...
JAVA Web MVC及三层架构
qq_41995069的博客
01-06 834
MVC: MVC模式的处理过程：首先由控制器接收用户的请求，并决定应该调用哪个模型来进行处理，然后模型用业务逻辑来处理用户的请求并返回数据，最后控制器用相应的视图返回数据，并通过表示层呈现给用户。 Model 实现问题域 处理所有的业务逻辑 view 可以是许多中的一个 是一个 model的窗口 只...
Javaweb实现用户登录并且在数据库中查找匹配的账号密码
金州饿霸吃不饱的博客
04-10 2万+
1.业务需求： 2 后端代码： 三层架构： （1）Dao层： package cn.dao; import java.util.List; import cn.domain.User; public interface UserDao { List<User> find(); boolean login(String username, String passw...
JAVA WEB从入门到精通day14 JAVA三层架构、登录注册实战演练
春水上行的博客
03-12 4227
MVC模式MVC 是一种使用 MVC（Model View Controller 模型-视图-控制器）设计创建 Web 应用程序的模式-Model（模型）。是应用程序中用于处理应用程序数据逻辑的部分。 -View（视图）。是应用程序中处理数据显示的部分。 -Controller（控制器）是应用程序中处理用户交互的部分。例如： 我们在View输入账号密码，点击登陆，然后触发Controller调用Mo
JavaWeb实现登录与注册的功能(四)：使用三层架构
qq_250161537
09-04 3018
在上一篇文章中使用三层架构完成了登录的功能这篇完成剩下的注册功能。
javaweb三层架构增删改查
11-04
下面是三层架构中增删改查的实现方法： 1. 增加数据：在表示层中，通过表单获取用户输入的数据，然后将数据传递给业务逻辑层。在业务逻辑层中，对数据进行验证和处理，然后将数据传递给数据访问层。在数据访问层中...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

冰冰很社恐

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值