目录
前言
一、整体结构
二、项目框架
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.数据库
代码如下(示例):
4.0.0 org.example javaee_project1.0-SNAPSHOT war 8 8 org.springframework spring-context5.3.19 org.springframework spring-tx5.2.8.RELEASE org.springframework spring-jdbc5.2.8.RELEASE org.springframework spring-webmvc5.3.19 org.mybatis mybatis3.5.9 org.mybatis mybatis-spring2.0.7 com.github.pagehelper pagehelper5.1.10 mysql mysql-connector-java8.0.16 com.alibaba druid1.1.20 javax.servlet javax.servlet-api3.1.0 provided javax.servlet.jsp jsp-api2.2 provided jstl jstl1.2 taglibs standard1.1.2 com.fasterxml.jackson.core jackson-core2.13.2 com.fasterxml.jackson.core jackson-databind2.13.2.2 com.fasterxml.jackson.core jackson-annotations2.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";
}
}
总结
以上就是这个用户管理系统的全部内容,前端页面简陋请多包涵。



