开发环境
- ①数据库:mysql 5.5.56
- ②编译器:idea 2018.3.5
- ③服务器:tomcat 8.0.39
- ④工具包:jdk1.8.0
- ⑤项目管理工具:maven 3.5.0
- ⑥框架:spring 5.2.5.RELEASE、mybatis 3.4.6
- ⑦分页插件:pagehelper 5.1.2
- ⑧脚本:jquery-1.12.4.js
步骤流程
一、MySQL用户表结构及数据
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
`name` varchar(12) DEFAULT NULL COMMENT '用户姓名',
`birthday` date DEFAULT NULL COMMENT '出生日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
insert into `user`(`id`,`name`,`birthday`) values
(1,'赵1','2000-01-01'),
(2,'赵2','2000-01-01'),
(3,'赵3','2000-01-01'),
(4,'赵4','2000-01-01'),
(5,'赵5','2000-01-01'),
(6,'钱1','2000-01-01'),
(7,'钱2','2000-01-01'),
(8,'钱3','2000-01-01'),
(9,'钱4','2000-01-01'),
(10,'钱5','2000-01-01'),
(11,'孙1','2000-01-01'),
(12,'孙2','2000-01-01'),
(13,'孙3','2000-01-01'),
(14,'孙4','2000-01-01'),
(15,'孙5','2000-01-01');
二、新建Maven工程
2.1 创建流程
idea窗口右上角 — File — New — Project
2.2 目录结构
2.3 指定目录类型
Ctrl + Alt +Shift + S 打开项目结构设置
三、编写配置文件
3.1 pom.xml
<!-- 属性 -->
<!-- 如果需要更改框架的版本号,只需要更改<properties>标签中的 "版本变量"即可 -->
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<spring.version>5.2.5.RELEASE</spring.version>
<mybatis.version>3.4.6</mybatis.version>
</properties>
<!-- 锁定版本,spring5.2.5.RELEASE mybatis3.4.6 -->
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
</dependencies>
</dependencyManagement>
<!-- 依赖的jar包 -->
<dependencies>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
</dependency>
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- 单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
<scope>test</scope>
</dependency>
<!-- servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- JSP -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
<!-- jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
<!-- c3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
</dependencies>
3.1 db.properties
路径:src / main / resources / db.properties
# mysql驱动
jdbc.driverClassName=com.mysql.jdbc.Driver
# 数据库地址
jdbc.url=jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT&zeroDateTimeBehavior=convertToNull
# 数据库账号
jdbc.username=root
# 数据库密码
jdbc.password=root
3.3 mybatis.xml
路径:src / main / resources / mybatis.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>
<!-- 打印sql语句 -->
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<!-- pageHelper分页插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="reasonable" value="true"/>
</plugin>
</plugins>
</configuration>
3.4 spring.xml
路径:src / main / resources / spring.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
https://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 扫描com目录下的注解 -->
<context:component-scan base-package="com"/>
<!-- 加载db.properties -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 获取数据源 通过c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driverClassName}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="user" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 数据访问层 sqlSessionFactory -->
<!-- 配置MyBatis工厂 -->
<!-- MyBatis工厂构建的SqlSesstionFactory 的作用:通常在配置时需要提供两个参数,
一个是数据源,一个是MyBatis的配置文件的构建路径。
这样在配置时,Spring的Ioc容器就会在初始化id为sqlSessionFactory的bean时
解析MyBatis的配置文件就会与数据源一同保存在Spring的bean中 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据源 -->
<property name="dataSource" ref="dataSource"/>
<!-- 指定核心配置文件位置 -->
<property name="configLocation" value="classpath:mybatis.xml"/>
<!-- 当mybatis的xml文件和mapper接口不在相同包下时,需要用mapperLocations属性指定xml文件的路径。
*是个通配符,代表所有的文件,**代表所有目录下 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- mapper扫描器:用来产生代理对象,数据访问层接口在容器中生成bean,方便biz调用 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 数据访问层接口的路径(dao路径) -->
<property name="basePackage" value="com.dao"></property>
</bean>
<!-- 配置事务管理,针对biz有效 -->
<!-- 配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 配置事务属性,需要事务管理器 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="find*" read-only="true"/>
<tx:method name="select*" read-only="true"/>
<tx:method name="insert*" propagation="REQUIRED" read-only="false"/>
<tx:method name="delete*" propagation="REQUIRED" read-only="false"/>
<tx:method name="update*" propagation="REQUIRED" read-only="false"/>
</tx:attributes>
</tx:advice>
<!-- 配置事务切点,并把事务和切点(业务逻辑层)关联起来 -->
<aop:config proxy-target-class="true">
<aop:pointcut expression="execution(* com.biz.impl.*.*(..))" id="txPointcut"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
</aop:config>
</beans>
3.5 springMVC.xml
路径:src / main / resources / springMVC.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
https://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 扫描控制器的注解 -->
<context:component-scan base-package="com.controller"/>
<!-- 注解驱动,处理适配器,映射处理器 -->
<!-- 会自动注册RequestMappingHandlerMapping与RequestMappingHandlerAdapter两个Bean,
这是Spring MVC为@Controller分发请求所必需的,并且提供了数据绑定支持 -->
<mvc:annotation-driven/>
<mvc:default-servlet-handler default-servlet-name="default"/>
<!-- 视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
3.6 web.xml
路径:src / main / webapp / WEB-INF / web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!-- spring配置文件的位置 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
<!-- 字符编码过滤器 -->
<filter>
<filter-name>encoding</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- spring上下文监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- springMVC 核心控制器 -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 制定首页 -->
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
四、编写源文件
4.1 用户实体类
路径:src / main / java / com / bean / User.java
package com.bean;
import org.springframework.format.annotation.DateTimeFormat;
import java.io.Serializable;
import java.util.Date;
/**
* @author 北涯
* @date 2020/6/26
* 用户实体类
*/
public class User implements Serializable {
private Integer id; // 用户编号
private String name; // 用户姓名
@DateTimeFormat(pattern = "yyyy-MM-dd") // 页面添加用户需要转换时间格式
private Date birthday; // 出生年月
// 省略get/set方法
// 省略无参/全参构造方法
4.2 用户数据访问层接口
路径:src / main / java / com / dao / UserDao.java
package com.dao;
import com.bean.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
* @author 北涯
* @date 2020/6/26
* 用户数据访问层接口
*/
@Mapper
@Repository
public interface UserDao {
/**
* 查询所有用户
*
* @return 用户集合
*/
List<User> findAllUser();
/**
* 查询一个用户
*
* @param id 用户编号
* @return 用户对象
*/
User findUserById(Integer id);
/**
* 添加用户
*
* @param user 用户对象
* @return 真或假
*/
boolean insertUser(User user);
/**
* 修改用户
*
* @param user 用户对象
* @return 真或假
*/
boolean updateUser(User user);
/**
* 删除用户
*
* @param id 用户编号
* @return 真或假
*/
boolean deleteUser(Integer id);
}
4.3 用户数据访问层接口映射文件
路径:src / main / resources / mapper / UserDao.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.dao.UserDao">
<resultMap id="BaseResultMap" type="com.bean.User">
<id column="id" jdbcType="INTEGER" property="id"/>
<result column="name" jdbcType="VARCHAR" property="name"/>
<result column="birthday" jdbcType="DATE" property="birthday"/>
</resultMap>
<sql id="Base_Column_List">
id, `name`, birthday
</sql>
<!-- 查询所有用户 -->
<select id="findAllUser" resultType="com.bean.User">
select
<include refid="Base_Column_List"/>
from user
</select>
<!-- 查询一个用户 -->
<select id="findUserById" resultType="com.bean.User">
select
<include refid="Base_Column_List"/>
from user
where id=#{id}
</select>
<!-- 添加用户(主键自增) -->
<insert id="insertUser" keyColumn="id" keyProperty="id" parameterType="com.bean.User" useGeneratedKeys="true">
insert into user (name, birthday) values (#{name}, #{birthday})
</insert>
<!-- 修改用户 -->
<update id="updateUser">
update user
<set>
<if test="name!=null and name!=''">
name=#{name},
</if>
<if test="birthday!=null">
birthday=#{birthday}
</if>
</set>
where id=#{id}
</update>
<!-- 删除用户 -->
<delete id="deleteUser">
delete from user where id=#{id}
</delete>
</mapper>
4.4 用户业务逻辑层接口
路径:src / main / java / com / biz / UserBiz.java
package com.biz;
import com.bean.User;
import com.github.pagehelper.PageInfo;
import java.util.List;
/**
* @author 北涯
* @date 2020/6/26
* 用户业务逻辑层接口
*/
public interface UserBiz {
/**
* 分页查询所有用户
*
* @param pageNum 当前页
* @param pageSize 当前页显示数
* @return 分页用户集合
*/
PageInfo<User> findAllUser(Integer pageNum, Integer pageSize);
/**
* 查询一个用户
*
* @param id 用户编号
* @return 用户对象
*/
User findUserById(Integer id);
/**
* 添加用户
*
* @param user 用户对象
* @return 真或假
*/
boolean insertUser(User user);
/**
* 修改用户
*
* @param user
* @return
*/
boolean updateUser(User user);
/**
* 删除用户
*
* @param id 用户编号
* @return 真或假
*/
boolean deleteUser(Integer id);
}
4.5 用户业务逻辑层接口实现类
路径:src / main / java / com / biz / impl / UserBizImpl.java
package com.biz.impl;
import com.bean.User;
import com.biz.UserBiz;
import com.dao.UserDao;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @author 北涯
* @date 2020/6/26
* 用户业务逻辑层接口实现类
*/
@Service
public class UserBizImpl implements UserBiz {
@Autowired
private UserDao userDao;
@Override
public PageInfo<User> findAllUser(Integer pageNum, Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<User> allUser = userDao.findAllUser();
PageInfo<User> userPageInfo = new PageInfo<>(allUser);
return userPageInfo;
}
@Override
public User findUserById(Integer id) {
User userById = userDao.findUserById(id);
return userById;
}
@Override
public boolean insertUser(User user) {
boolean flag = false;
try {
flag = userDao.insertUser(user);
} catch (Exception e) {
flag = false;
e.printStackTrace();
}
return flag;
}
@Override
public boolean updateUser(User user) {
boolean flag = false;
try {
flag = userDao.updateUser(user);
} catch (Exception e) {
flag = false;
e.printStackTrace();
}
return flag;
}
@Override
public boolean deleteUser(Integer id) {
boolean flag = false;
try {
flag = userDao.deleteUser(id);
} catch (Exception e) {
flag = false;
e.printStackTrace();
}
return flag;
}
}
4.6 用户控制器层
路径:src / main / java / com / controller / UserController.java
package com.controller;
import com.bean.User;
import com.biz.UserBiz;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.SessionAttributes;
import javax.servlet.http.HttpSession;
/**
* @author 北涯
* @date 2020/6/26
* 用户控制器层
*/
@Controller
@RequestMapping("/user")
@SessionAttributes({"allUser"}) // 将model存入的值放入session范围
public class UserController {
@Autowired
private UserBiz userBiz;
// 分页查询
@RequestMapping("/page")
public String page(@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum,
@RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize,
Model model) {
PageInfo<User> allUser = userBiz.findAllUser(pageNum, pageSize);
model.addAttribute("allUser", allUser);
return "list";
}
// 用户详情
@RequestMapping("/detail")
public String detail(Integer id, Model model) {
User user = userBiz.findUserById(id);
model.addAttribute("user", user);
return "detail";
}
// 添加页面
@RequestMapping("/goInsert")
public String goInsert() {
return "insert";
}
// 添加用户
@RequestMapping("/doInsert")
public String doInsert(User user, Model model) {
userBiz.insertUser(user);
// 添加成功跳转到最后一页
PageInfo<User> page = (PageInfo<User>) model.getAttribute("allUser");
Integer pageNum = page.getPages();
// 如果总记录条数取模每页显示记录数=0,页数加一
if (page.getTotal() % page.getPageSize() == 0) {
pageNum += 1;
}
return "redirect:page?pageNum=" + pageNum;
}
// 修改页面
@RequestMapping("/goUpdate")
public String goUpdate(Integer id, Model model) {
User byId = userBiz.findUserById(id);
model.addAttribute("byId", byId);
return "update";
}
// 修改用户
@RequestMapping("/doUpdate")
public String doUpdate(User user, Model model) {
userBiz.updateUser(user);
// 在哪页修改回到哪页
PageInfo<User> page = (PageInfo<User>) model.getAttribute("allUser");
Integer pageNum = page.getPageNum();
return "redirect:page?pageNum=" + pageNum;
}
// 删除用户
@RequestMapping("/delete")
public String delete(Integer id, Model model) {
userBiz.deleteUser(id);
PageInfo<User> page = (PageInfo<User>) model.getAttribute("allUser");
Integer pageNum = page.getPageNum();
Integer pages = page.getPages();
// 如果当前页不是最后一页,回到当前页
if (pageNum != pages) {
pageNum = page.getPageNum();
}
// 如果当前页是最后一页,并且总记录条数取模每页显示记录数=0,页数减一
if (pageNum == pages && page.getTotal() % page.getPageSize() == 0) {
pageNum -= 1;
}
return "redirect:page?pageNum=" + pageNum;
}
}
五、编写JSP视图
5.1 页面展示
用户首页—————————————————————————————————————————————————
详情页面—————————————————————————————————————————————————
添加页面—————————————————————————————————————————————————
修改页面—————————————————————————————————————————————————
5.2 index.jsp
路径:src / main / webapp / index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" isELIgnored="false" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ request.getContextPath() + "/";
pageContext.setAttribute("path", path);
%>
<!DOCTYPE html >
<html>
<head>
<base href="<%=path%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<a href="user/page">用户首页</a>
</body>
</html>
5.3 用户首页
路径:src / main / webapp / jsp / list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ request.getContextPath() + "/";
pageContext.setAttribute("path", path);
%>
<!DOCTYPE html >
<html>
<head>
<base href="<%=path%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script type="text/javascript" src="${path}statis/js/jquery-1.12.4.js"></script>
<title>用户首页</title>
<style>
div {
width: 600px;
margin: 50px auto 0px;
text-align: right;
}
table {
width: 600px;
margin: 10px auto 0px;
}
tr {
text-align: center;
}
p {
width: 600px;
margin: 10px auto 0px;
text-align: center;
}
.red {
color: red;
}
</style>
</head>
<body>
<div>
<button onclick="goInsert()">添加用户</button>
</div>
<table cellspacing="1" cellpadding="1" border="1">
<tr>
<th>编号</th>
<th>姓名</th>
<th>生日</th>
<th>操作</th>
</tr>
<c:forEach var="user" items="${allUser.list}">
<tr>
<td>${user.id}</td>
<td>${user.name}</td>
<td><fmt:formatDate value="${user.birthday}" pattern="yyyy-MM-dd"/></td>
<td>
<button onclick="goDetail(${user.id})">详情</button>
<button onclick="goUpdate(${user.id})">修改</button>
<button onclick="doDelete(${user.id})">删除</button>
</td>
</tr>
</c:forEach>
</table>
<p>
<button>共${allUser.total}条数据</button>
<button>当前${allUser.pageNum}/${allUser.pages}页</button>
<button onclick="goPage(1)">首页</button>
<button onclick="goPage(${allUser.pageNum-1})">上一页</button>
<c:forEach var="i" begin="1" end="${allUser.pages}">
<button onclick="goPage(${i})" <c:if test="${i==allUser.pageNum}">class="red"</c:if>>${i}</button>
</c:forEach>
<button onclick="goPage(${allUser.pageNum+1})">下一页</button>
<button onclick="goPage(${allUser.pages})">尾页</button>
</p>
</body>
<script type="text/javascript">
// 分页跳转
function goPage(pageNum) {
location.href = "user/page?pageNum=" + pageNum;
}
// 添加页面
function goInsert() {
location.href = "user/goInsert";
}
// 详情页面
function goDetail(id) {
location.href = "user/detail?id=" + id;
}
// 修改页面
function goUpdate(id) {
location.href = "user/goUpdate?id=" + id;
}
// 确认删除
function doDelete(id) {
if (confirm("确定删除该用户吗?")) {
location.href = "user/delete?id=" + id;
}
}
</script>
</html>
5.4 详情页面
路径:src / main / webapp / jsp / detail.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ request.getContextPath() + "/";
pageContext.setAttribute("path", path);
%>
<!DOCTYPE html >
<html>
<head>
<base href="<%=path%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用户详情</title>
<style>
div{
width: 400px;
margin: 50px auto;
text-align: center;
}
input{
margin: 5px 0px;
}
</style>
</head>
<body>
<div>
<h3>用户详情</h3>
用户编号:<input type="text" readonly name="id" value="${user.id}"><br>
用户姓名:<input type="text" readonly name="name" value="${user.name}"><br>
出生日期:<input type="text" readonly name="birthday" value="<fmt:formatDate value='${user.birthday}' pattern='yyyy-MM-dd'/>"><br>
<button onclick="window.history.go(-1)">返回</button>
</div>
</body>
</html>
5.5 添加页面
路径:src / main / webapp / jsp / insert.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ request.getContextPath() + "/";
pageContext.setAttribute("path", path);
%>
<!DOCTYPE html >
<html>
<head>
<base href="<%=path%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>添加页面</title>
<style>
div {
width: 400px;
margin: 50px auto;
text-align: center;
}
input {
margin: 5px 0px;
}
</style>
</head>
<body>
<div>
<h3>添加用户</h3>
<form method="post" action="user/doInsert">
用户姓名:<input type="text" name="name"><br>
出生日期:<input type="date" name="birthday" style="width: 172px;"><br>
<input type="submit" value="添加"> <button onclick="window.history.go(-1)">返回</button>
</form>
</div>
</body>
</html>
5.6 修改页面
路径:src / main / webapp / jsp / update.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%
String path = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
+ request.getContextPath() + "/";
pageContext.setAttribute("path", path);
%>
<!DOCTYPE html >
<html>
<head>
<base href="<%=path%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>修改页面</title>
<style>
div {
width: 400px;
margin: 50px auto;
text-align: center;
}
input {
margin: 5px 0px;
}
</style>
</head>
<body>
<div>
<h3>用户修改</h3>
<form method="post" action="user/doUpdate">
用户编号:<input type="text" readonly name="id" value="${byId.id}"><br>
用户姓名:<input type="text" name="name" value="${byId.name}"><br>
出生日期:<input type="date" name="birthday" value="<fmt:formatDate value='${byId.birthday}' pattern='yyyy-MM-dd'/>" style="width: 172px;"><br>
<input type="submit" value="修改"> <button onclick="window.history.go(-1)">返回</button>
</form>
</div>
</body>
</html>