栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

完整的SSM用户管理系统

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

完整的SSM用户管理系统

目录

前言

一、整体结构

二、项目框架

1.pom.xml

2.数据库

3.注解config配置

三、起始页面功能

一、登入功能

二、注册功能

 二、修改密码功能

四、登入成功后用户的管理功能

一、增加用户

 二、查询用户

 三、修改用户信息

 四、删除用户

五、分页插件

总结


前言

带 “User” 的代码页名称是属于登入页面login.jsp中所有属性

带 “Users” 的代码页名称是属于登入成功后进入用户管理页面中的所有属性

项目完整代码百度云链接:https://pan.baidu.com/s/1B2QiNTEzTDMcXTM4sH4qsw 
提取码:wasd


提示:以下是本篇文章正文内容,下面案例可供参考

一、整体结构

二、项目框架

1.pom.xml

代码如下(示例):



    4.0.0

    org.example
    javaee_project
    1.0-SNAPSHOT
    war
    
    
        8
        8
    

    
    
        org.springframework
        spring-context
        5.3.19
    

    
    
        org.springframework
        spring-tx
        5.2.8.RELEASE
    

    
    
        org.springframework
        spring-jdbc
        5.2.8.RELEASE
    

    
    
        org.springframework
        spring-webmvc
        5.3.19
    

    
    
        org.mybatis
        mybatis
        3.5.9
    

    
    
        org.mybatis
        mybatis-spring
        2.0.7
    

    
    
        com.github.pagehelper
        pagehelper
        5.1.10
    

    
    
        mysql
        mysql-connector-java
        8.0.16
    

    
    
        com.alibaba
        druid
        1.1.20
    

    
    
        javax.servlet
        javax.servlet-api
        3.1.0
        provided
    

    
    
        javax.servlet.jsp
        jsp-api
        2.2
        provided
    

    

    
        jstl
        jstl
        1.2
    

    
        taglibs
        standard
        1.1.2
    

    
        com.fasterxml.jackson.core
        jackson-core
        2.13.2
    

    
        com.fasterxml.jackson.core
        jackson-databind
        2.13.2.2
    

    
        com.fasterxml.jackson.core
        jackson-annotations
        2.13.2
    
    

2.数据库

3.注解config配置

1.EncodingFilter页面,用于解决代码乱码

package com.config;

import javax.servlet.*;
import javax.servlet.annotation.WebFilter;
import java.io.IOException;

@WebFilter(filterName = "encodingFilter",urlPatterns = "
        @Value("${jdbc.driverClassName}")
        private String driver;
        @Value("${jdbc.url}")
        private String url;
        @Value("${mysql.username}")
        private String username;
        @Value("${jdbc.password}")
        private String password;

        @Bean("dataSource")
        public  DataSource getDataSource() {
            DruidDataSource ds = new DruidDataSource();
            ds.setDriverClassName(driver);
            ds.setUrl(url);
            ds.setUsername(username);
            ds.setPassword(password);
            return ds;
        }
    }


3.MyBatisConfig页面,用于配置Mybatis相关

package com.config;

import com.github.pagehelper.PageInterceptor;
import org.apache.ibatis.plugin.Interceptor;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;

import javax.sql.DataSource;
import java.util.Properties;

public class MyBatisConfig {
    
    @Bean
    public PageInterceptor getPageInterceptor() {
        PageInterceptor pageInterceptor = new PageInterceptor();
        Properties properties = new Properties();
        properties.setProperty("value","true");
        pageInterceptor.setProperties(properties);
        return pageInterceptor;
    }
    
    @Bean
    public SqlSessionFactoryBean getSqlSessionFactoryBean(
            @Autowired DataSource dataSource,
            @Autowired PageInterceptor pageInterceptor) {
        SqlSessionFactoryBean ssfb =new SqlSessionFactoryBean();
        ssfb.setDataSource(dataSource);
        Interceptor [] plugins =  {pageInterceptor};
        ssfb.setPlugins(plugins);
        return ssfb;
    }
    
    @Bean
    public MapperScannerConfigurer getMapperScannerConfigurer() {
        MapperScannerConfigurer msc = new MapperScannerConfigurer();
        msc.setBasePackage("com.mapper");
        return msc;
    }
}

 4.ServletContainersInitConfig页面,用于配置Servlet服务层

package com.config;

import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;

public class ServletContainersInitConfig extends
        AbstractAnnotationConfigDispatcherServletInitializer {
    
    protected Class[] getRootConfigClasses() {
        return new Class[]{com.config.SpringConfig.class};
    }
    
        protected Class[] getServletConfigClasses () {
            return new Class[]{com.config.SpringMvcConfig.class};
        }
        
            protected String[] getServletMappings () {
                return new String[]{"/"};
            }
        }

5.SpringConfig页面,

package com.config;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.sql.DataSource;

@Configuration

@Import({com.config.MyBatisConfig.class,JdbcConfig.class})

@ComponentScan("com.service")
@EnableTransactionManagement
public class SpringConfig {
    @Bean("transactionManager")
    public DataSourceTransactionManager getDataSourceTxManager(@Autowired DataSource dataSource){
        DataSourceTransactionManager dtm =new DataSourceTransactionManager();
        dtm.setDataSource(dataSource);
        return dtm;
    }
}

 6.SpringMvcConfig页面,用于开启静态资源

package com.config;

import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.*;


@Configuration
@ComponentScan({"com.controller"})
@EnableWebMvc
public class SpringMvcConfig implements WebMvcConfigurer {
    
    @Override
    public void configureDefaultServletHandling(
            DefaultServletHandlerConfigurer configurer) {
        configurer.enable();
    }

    @Override
    public void configureViewResolvers(ViewResolverRegistry registry) {
        registry.jsp("/admin/", ".jsp");
    }
}

三、起始页面功能

一、登入功能

1.类

package com.pojo;

public class User {
    private String id;
    private String name;
    private String password;

    public String getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

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

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

 2.controller层

 //登入
    @RequestMapping("/login")
    public String login(User user,HttpServletRequest request) {
        try{
            User u = userService.login(user);
            if(u !=null){
                return "redirect:/users/selectUsers";
            }
            request.setAttribute("msg","用户名或密码错误");
            return "forward:/admin/login.jsp";
        } catch (Exception e) {
            e.printStackTrace();
            request.setAttribute("msg","系统错误");
            return "forward:/admin/login.jsp";
        }
    }

3.serlver层

public interface UserService {
    //登入
    User login(User user);

    //注册
    Boolean register(String name, String password);

    //修改密码
    Boolean register1(String name,String pass);
}
public User login(User user){
        return userMapper.login(user);
    }

4.Mapper层

public interface UserMapper {
    //登入
    @Select("select * from  user where realName=#{name} "+
            "and password=#{password}  ")
    User login(User user);

    //注册
    @Insert("insert into user(id,realName,password) values (#{id},#{name},#{password})")
    Boolean addUser(User user);

    //修改密码
    @Update("update user set password=#{password} where realName=#{name}")
    Boolean reChange(User user);
}

二、注册功能

1.类

package com.pojo;

public class User {
    private String id;
    private String name;
    private String password;

    public String getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

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

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

 2.controller层

 //注册
    @RequestMapping("/register")
    public String register(HttpServletRequest request){
        try{
            String name =request.getParameter("name");
            String password =request.getParameter("password");
            if("".equals(name)||"".equals(password)){
                request.setAttribute("msg","信息不能为空");
                return "forward:/admin/register.jsp";
            }
            Boolean register = userService.register(name, password);
            if (register) {
                request.setAttribute("msg","注册成功");
                return "forward:/admin/login.jsp";
            }else {
                request.setAttribute("msg","注册失败");
                return "forward:/admin/register.jsp";
            }

        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

3.serlver层

public interface UserService {
    //登入
    User login(User user);

    //注册
    Boolean register(String name, String password);

    //修改密码
    Boolean register1(String name,String pass);
}
@Override
    public Boolean register(String name, String password) {
        User user = new User();
        String replace = UUID.randomUUID().toString().replace("-", "");
        user.setId(replace);
        user.setName(name);
        user.setPassword(password);
        Boolean aBoolean = userMapper.addUser(user);
        return aBoolean;
    }

4.Mapper层

public interface UserMapper {
    //登入
    @Select("select * from  user where realName=#{name} "+
            "and password=#{password}  ")
    User login(User user);

    //注册
    @Insert("insert into user(id,realName,password) values (#{id},#{name},#{password})")
    Boolean addUser(User user);

    //修改密码
    @Update("update user set password=#{password} where realName=#{name}")
    Boolean reChange(User user);
}

 二、修改密码功能

1.类

package com.pojo;

public class User {
    private String id;
    private String name;
    private String password;

    public String getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

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

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

 2.controller层

//修改密码
    @RequestMapping("/changeMima")
    public ModelAndView changMima(User user,String newPassword, HttpServletRequest request){
        ModelAndView modelAndView = new ModelAndView();
        String name = user.getName();
        String password=user.getPassword();
        try {
            User u = userService.login(user);
            if(u!=null){
                if("".equals(name)||"".equals(password)){
                    request.setAttribute("msg","信息不能为空");
                    modelAndView.setViewName("redirect:/admin/change.jsp");
                }
                Boolean re = userService.register1(name, newPassword);
                if(re){
                    request.setAttribute("msg","修改成功");
                    modelAndView.setViewName("forward:/admin/login.jsp");
                }else {
                    request.setAttribute("msg","修改失败");
                    modelAndView.setViewName("forward:/admin/login.jsp");
                }

            }

        }catch (Exception e) {
            throw new RuntimeException(e);
        }
        return modelAndView;
    }

3.serlver层

public interface UserService {
    //登入
    User login(User user);

    //注册
    Boolean register(String name, String password);

    //修改密码
    Boolean register1(String name,String pass);
}

4.Mapper层

public interface UserMapper {
    //登入
    @Select("select * from  user where realName=#{name} "+
            "and password=#{password}  ")
    User login(User user);

    //注册
    @Insert("insert into user(id,realName,password) values (#{id},#{name},#{password})")
    Boolean addUser(User user);

    //修改密码
    @Update("update user set password=#{password} where realName=#{name}")
    Boolean reChange(User user);
}

四、登入成功后用户的管理功能

一、增加用户

1.类

package com.pojo;

import java.util.List;

public class Users {

        private Integer id;
        private String name;
        private String sex;
        private String gender;
        private String age;
        private String qq;
        private String email;
        private List rows;

        public List getRows() {
                return rows;
        }

        public void setRows(List rows) {
                this.rows = rows;
        }

        public Integer getId() {
                return id;
        }

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

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public String getSex() {
                return sex;
        }

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

        public String getGender() {
                return gender;
        }

        public void setGender(String gender) {
                this.gender = gender;
        }

        public String getAge() {
                return age;
        }

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

        public String getQq() {
                return qq;
        }

        public void setQq(String qq) {
                this.qq = qq;
        }

        public String getEmail() {
                return email;
        }

        public void setEmail(String email) {
                this.email = email;
        }

        @Override
        public String toString() {
                return "Users{" +
                        "id=" + id +
                        ", name='" + name + ''' +
                        ", sex='" + sex + ''' +
                        ", gender='" + gender + ''' +
                        ", age='" + age + ''' +
                        ", qq='" + qq + ''' +
                        ", email='" + email + ''' +
                        '}';
        }
}

 2.controller层

  //添加
    @RequestMapping("/addUsers")
    public String addNewUsers(Users users){
        Integer count = usersService.addUsers(users);
        return "redirect:/users/selectUsers";
    }

3.serlver层

package com.service;
import com.entity.PageResult;
import com.pojo.Users;
public interface UsersService {

    PageResult findAllUsers(Integer PageNumber, Integer PageSize);

    //根据用户名和邮箱查询人物信息
    PageResult findUsers(Users users,Integer pageNumber,Integer pageSize);

    //新增用户信息
    Integer addUsers(Users users);

    //修改用户信息
    Integer editUsers(Users users);

    //删除用户信息
    Integer deleteUsers(Integer id);



}


4.Mapper层

package com.service.impl;
import com.entity.PageResult;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.mapper.UsersMapper;
import com.pojo.Users;
import com.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;

    //页面用户显示
    @Override
    public PageResult findAllUsers(Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findAllUsers();
        return new PageResult(page.getTotal(), page.getResult());
    }

    //查询用户
    @Override
    public PageResult findUsers(Users users,Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findUsers(users);
        return new PageResult(page.getTotal(), page.getResult());
    }

    //添加新用户
    @Override
    public Integer addUsers(Users users) {
        return usersMapper.addUsers(users);
    }

    //修改用户信息
    @Override
    public Integer editUsers(Users users){
        return usersMapper.editUsers(users);
    }

    //删除用户信息
    @Override
    public Integer deleteUsers(Integer id) {
        return usersMapper.deleteUsers(id);
    }
}

 二、查询用户

1.类

package com.pojo;

import java.util.List;

public class Users {

        private Integer id;
        private String name;
        private String sex;
        private String gender;
        private String age;
        private String qq;
        private String email;
        private List rows;

        public List getRows() {
                return rows;
        }

        public void setRows(List rows) {
                this.rows = rows;
        }

        public Integer getId() {
                return id;
        }

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

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public String getSex() {
                return sex;
        }

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

        public String getGender() {
                return gender;
        }

        public void setGender(String gender) {
                this.gender = gender;
        }

        public String getAge() {
                return age;
        }

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

        public String getQq() {
                return qq;
        }

        public void setQq(String qq) {
                this.qq = qq;
        }

        public String getEmail() {
                return email;
        }

        public void setEmail(String email) {
                this.email = email;
        }

        @Override
        public String toString() {
                return "Users{" +
                        "id=" + id +
                        ", name='" + name + ''' +
                        ", sex='" + sex + ''' +
                        ", gender='" + gender + ''' +
                        ", age='" + age + ''' +
                        ", qq='" + qq + ''' +
                        ", email='" + email + ''' +
                        '}';
        }
}

 2.controller层

 //查询
    @RequestMapping("/findUsers")
    public ModelAndView findSqlUsers(Users users){
        Integer pageNum = 1;
        Integer pageSize = 5;
        Users pageResult = usersService.findUsers(users,pageNum,pageSize);
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.setViewName("success");
        modelAndView.addObject("users",pageResult);
        return modelAndView;

    }

3.serlver层

package com.service;
import com.entity.PageResult;
import com.pojo.Users;
public interface UsersService {

    PageResult findAllUsers(Integer PageNumber, Integer PageSize);

    //根据用户名和邮箱查询人物信息
    PageResult findUsers(Users users,Integer pageNumber,Integer pageSize);

    //新增用户信息
    Integer addUsers(Users users);

    //修改用户信息
    Integer editUsers(Users users);

    //删除用户信息
    Integer deleteUsers(Integer id);



}


4.Mapper层

package com.service.impl;
import com.entity.PageResult;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.mapper.UsersMapper;
import com.pojo.Users;
import com.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;

    //页面用户显示
    @Override
    public PageResult findAllUsers(Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findAllUsers();
        return new PageResult(page.getTotal(), page.getResult());
    }

    //查询用户
    @Override
    public PageResult findUsers(Users users,Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findUsers(users);
        return new PageResult(page.getTotal(), page.getResult());
    }

    //添加新用户
    @Override
    public Integer addUsers(Users users) {
        return usersMapper.addUsers(users);
    }

    //修改用户信息
    @Override
    public Integer editUsers(Users users){
        return usersMapper.editUsers(users);
    }

    //删除用户信息
    @Override
    public Integer deleteUsers(Integer id) {
        return usersMapper.deleteUsers(id);
    }
}

 三、修改用户信息

1.类

package com.pojo;

import java.util.List;

public class Users {

        private Integer id;
        private String name;
        private String sex;
        private String gender;
        private String age;
        private String qq;
        private String email;
        private List rows;

        public List getRows() {
                return rows;
        }

        public void setRows(List rows) {
                this.rows = rows;
        }

        public Integer getId() {
                return id;
        }

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

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public String getSex() {
                return sex;
        }

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

        public String getGender() {
                return gender;
        }

        public void setGender(String gender) {
                this.gender = gender;
        }

        public String getAge() {
                return age;
        }

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

        public String getQq() {
                return qq;
        }

        public void setQq(String qq) {
                this.qq = qq;
        }

        public String getEmail() {
                return email;
        }

        public void setEmail(String email) {
                this.email = email;
        }

        @Override
        public String toString() {
                return "Users{" +
                        "id=" + id +
                        ", name='" + name + ''' +
                        ", sex='" + sex + ''' +
                        ", gender='" + gender + ''' +
                        ", age='" + age + ''' +
                        ", qq='" + qq + ''' +
                        ", email='" + email + ''' +
                        '}';
        }
}

 2.controller层

//修改
    @RequestMapping("/editUsers")
    public ModelAndView editUsers(Users users) {
        ModelAndView modelAndView = new ModelAndView();
        Integer integer = usersService.editUsers(users);
        if (integer==0) {
            modelAndView.setViewName("editUsers");
            modelAndView.addObject("msg","修改失败");
            return modelAndView;
        }
        ModelAndView modelAndView1 = selectUsers();
        modelAndView.addObject("msg","修改成功");
        return modelAndView1;
    }

3.serlver层

package com.service;
import com.entity.PageResult;
import com.pojo.Users;
public interface UsersService {

    PageResult findAllUsers(Integer PageNumber, Integer PageSize);

    //根据用户名和邮箱查询人物信息
    PageResult findUsers(Users users,Integer pageNumber,Integer pageSize);

    //新增用户信息
    Integer addUsers(Users users);

    //修改用户信息
    Integer editUsers(Users users);

    //删除用户信息
    Integer deleteUsers(Integer id);



}


4.Mapper层

package com.service.impl;
import com.entity.PageResult;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.mapper.UsersMapper;
import com.pojo.Users;
import com.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;

    //页面用户显示
    @Override
    public PageResult findAllUsers(Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findAllUsers();
        return new PageResult(page.getTotal(), page.getResult());
    }

    //查询用户
    @Override
    public PageResult findUsers(Users users,Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findUsers(users);
        return new PageResult(page.getTotal(), page.getResult());
    }

    //添加新用户
    @Override
    public Integer addUsers(Users users) {
        return usersMapper.addUsers(users);
    }

    //修改用户信息
    @Override
    public Integer editUsers(Users users){
        return usersMapper.editUsers(users);
    }

    //删除用户信息
    @Override
    public Integer deleteUsers(Integer id) {
        return usersMapper.deleteUsers(id);
    }
}

 四、删除用户

1.类

package com.pojo;

import java.util.List;

public class Users {

        private Integer id;
        private String name;
        private String sex;
        private String gender;
        private String age;
        private String qq;
        private String email;
        private List rows;

        public List getRows() {
                return rows;
        }

        public void setRows(List rows) {
                this.rows = rows;
        }

        public Integer getId() {
                return id;
        }

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

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public String getSex() {
                return sex;
        }

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

        public String getGender() {
                return gender;
        }

        public void setGender(String gender) {
                this.gender = gender;
        }

        public String getAge() {
                return age;
        }

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

        public String getQq() {
                return qq;
        }

        public void setQq(String qq) {
                this.qq = qq;
        }

        public String getEmail() {
                return email;
        }

        public void setEmail(String email) {
                this.email = email;
        }

        @Override
        public String toString() {
                return "Users{" +
                        "id=" + id +
                        ", name='" + name + ''' +
                        ", sex='" + sex + ''' +
                        ", gender='" + gender + ''' +
                        ", age='" + age + ''' +
                        ", qq='" + qq + ''' +
                        ", email='" + email + ''' +
                        '}';
        }
}

 2.controller层

//删除
    @RequestMapping("/deleteUsers/{id}")
    public String deleteUsers(@PathVariable("id") Integer id){
        System.out.println(id);
        Integer count = usersService.deleteUsers(id);
        if (count == 0) {
            System.out.println("失败");
        } else {
            System.out.println("成功");
        }
        return "redirect:/users/selectUsers";
    }

3.serlver层

package com.service;
import com.entity.PageResult;
import com.pojo.Users;
public interface UsersService {

    PageResult findAllUsers(Integer PageNumber, Integer PageSize);

    //根据用户名和邮箱查询人物信息
    PageResult findUsers(Users users,Integer pageNumber,Integer pageSize);

    //新增用户信息
    Integer addUsers(Users users);

    //修改用户信息
    Integer editUsers(Users users);

    //删除用户信息
    Integer deleteUsers(Integer id);



}


4.Mapper层

package com.service.impl;
import com.entity.PageResult;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.mapper.UsersMapper;
import com.pojo.Users;
import com.service.UsersService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service
public class UsersServiceImpl implements UsersService {
    @Autowired
    private UsersMapper usersMapper;

    //页面用户显示
    @Override
    public PageResult findAllUsers(Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findAllUsers();
        return new PageResult(page.getTotal(), page.getResult());
    }

    //查询用户
    @Override
    public PageResult findUsers(Users users,Integer pageNumber,Integer pageSize) {
        PageHelper.startPage(pageNumber, pageSize);
        Page page = usersMapper.findUsers(users);
        return new PageResult(page.getTotal(), page.getResult());
    }

    //添加新用户
    @Override
    public Integer addUsers(Users users) {
        return usersMapper.addUsers(users);
    }

    //修改用户信息
    @Override
    public Integer editUsers(Users users){
        return usersMapper.editUsers(users);
    }

    //删除用户信息
    @Override
    public Integer deleteUsers(Integer id) {
        return usersMapper.deleteUsers(id);
    }
}

五、分页插件

这个分页插件很重要,没有的话就无法在用户管理页面看到从数据库传输上来的用户信息

1.类

package com.pojo;


import java.util.List;

public class PageBean {
        private int totalCount;   //总记录数
        private int totalPage; //总页码
        private List list;  //每页中的数据
        private int currentPage;  //当前页码
        private int rows;   //每页的记录数

        public int getTotalCount() {return totalCount;}

        public void setTotalCount(int totalCount) {this.totalCount = totalCount;}

        public int getTotalPage() {return totalPage;}

        public void setTotalPage(int totalPage) {this.totalPage = totalPage;}

        public List getList() {return list;}

        public void setList(List list) {this.list = list;}

        public int getCurrentPage() {return currentPage;}

        public void setCurrentPage(int currentPage) {this.currentPage = currentPage;}

        public int getRows() {return rows;}

        public void setRows(int rows) {this.rows = rows;}
    }


2.方法控制层

package com.controller;

import com.pojo.User;
import com.pojo.Users;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpSession;

@Controller
public class pageController {
    @RequestMapping("/addView")
    public String addView(){
        return "addView";
    }

    @RequestMapping("/editUsers")
    public ModelAndView editUsers(Users users){
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.setViewName("editUsers");
        modelAndView.addObject("users",users);
        return modelAndView;
    }

    //注销
    @RequestMapping("/logout")
    public String logout(HttpSession session) {
        session.invalidate();
        return "login";
    }
}

总结

以上就是这个用户管理系统的全部内容,前端页面简陋请多包涵。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/952738.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号