添加Spring

https://mvnrepository.com/artifact/org.aspectj/aspectjweaver

--dependencygroupIdorg.aspectj/groupIdartifactIdaspectjweaver/artifactIdversion1.9.7/versionscoperuntime/scope/dependency!--

https://mvnrepository.com/artifact/org.springframework/spring-webmvc

--dependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion5.2.9.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.2.9.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-core/artifactIdversion5.2.9.RELEASE/version/dependency​dependencygroupIdorg.springframework/groupIdartifactIdspring-beans/artifactIdversion5.2.9.RELEASE/version/dependency​

添加mybatis

分页插件--dependencygroupIdcom.github.pagehelper/groupIdartifactIdpagehelper/artifactIdversion5.2.0/version/dependency​​!--mybatis-spring

依赖--!--

https://mvnrepository.com/artifact/org.mybatis/mybatis-spring

--dependencygroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactIdversion2.0.6/version/dependency!--引入mybatis.jar--dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.4.6/version/dependency

添加其他一些依赖

https://mvnrepository.com/artifact/mysql/mysql-connector-java

--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.26/version/dependency​!--log4j--!--

https://mvnrepository.com/artifact/log4j/log4j

--dependencygroupIdlog4j/groupIdartifactIdlog4j/artifactIdversion1.2.17/version/dependency

添加数据源

https://mvnrepository.com/artifact/com.alibaba/druid

--dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.2.5/version/dependency

jsp

https://mvnrepository.com/artifact/jstl/jstl

--dependencygroupIdjstl/groupIdartifactIdjstl/artifactIdversion1.2/version/dependency​

文件上传和下载

https://mvnrepository.com/artifact/commons-io/commons-io

--dependencygroupIdcommons-io/groupIdartifactIdcommons-io/artifactIdversion2.6/version/dependency!--

https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload

--dependencygroupIdcommons-fileupload/groupIdartifactIdcommons-fileupload/artifactIdversion1.4/version/dependency​dependencygroupIdjavax.servlet/groupIdartifactIdservlet-api/artifactIdversion2.5/versionscopeprovided/scope/dependency

为pom.xml

!--资源--buildresources​resource!----directorysrc/main/resources/directory!--包含--includesinclude**.*/include/includes/resource/resources/build

数据库配置文件

配置uname自己mysql的用户名passwordmysql的密码drivercom.mysql.cj.jdbc.Driverurljdbc:mysql://localhost:3306/数据库名称?serverTimezoneGMT

编写日志配置文件

org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.Target

System.outlog4j.appender.stdout.layout

org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern

[%-5p]

xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxmlns:txhttp://www.springframework.org/schema/txxmlns:aophttp://www.springframework.org/schema/aopxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsd!--spring

db.properties

locationclasspath:db.properties/!--

第一步

classcom.alibaba.druid.pool.DruidDataSource

property

classorg.mybatis.spring.SqlSessionFactoryBean!--配置数据源属性--property

namedataSource

valueclasspath:mapper/*.xml/!--配置分页mybati

插件--property

classcom.github.pagehelper.PageInterceptorproperty

nameproperties!--使用下面的方式配置参数一行配置一个

--valuehelperDialectmysqlreasonabletrue/value/property/bean/array/property/bean!--第三步

mapper

classorg.mybatis.spring.mapper.MapperScannerConfigurer!--配置

--property

classorg.springframework.web.multipart.commons.CommonsMultipartResolver!--设置

最大上传

classorg.springframework.jdbc.datasource.DataSourceTransactionManager!--配置数据源--property

namedataSource

transaction-managertransactionManagertx:attributestx:method

nameinsert*

read-onlytrue//tx:attributes/tx:advice​!--定义切面,

advice-reftxAdvicepointcutexecution(*

service.*.*(..))//aop:config​​​​/beans

springmvc

xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxmlns:mvchttp://www.springframework.org/schema/mvcxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/mvc

https://www.springframework.org/schema/mvc/spring-mvc.xsd​!--扫描

controller

classorg.springframework.web.servlet.view.InternalResourceViewResolver!--前缀--property

nameprefix

value.jsp//beanmvc:annotation-driven//beans

编写mybatis配置文件

3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtdconfiguration​settings!--增加

控制台

valueLOG4J//settings​/configuration

编写web.xml

xmlnshttp://xmlns.jcp.org/xml/ns/javaeexmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://xmlns.jcp.org/xml/ns/javaeehttp://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsdversion4.0

metadata-completefalse​display-nameArchetype

Created

--context-paramparam-namecontextConfigLocation/param-nameparam-valueclasspath:spring.xml/param-value/context-param!--

监听器

--listenerlistener-classorg.springframework.web.context.ContextLoaderListener/listener-class/listener​!--过滤器

处理中文--filterfilter-nameencodingFilter/filter-namefilter-classorg.springframework.web.filter.CharacterEncodingFilter/filter-classinit-paramparam-nameencoding/param-nameparam-valueutf-8/param-value/init-param/filterfilter-mappingfilter-nameencodingFilter/filter-nameurl-pattern/*/url-pattern/filter-mapping​​​!--

DispatcherServlet--servletservlet-namespringmvc/servlet-nameservlet-classorg.springframework.web.servlet.DispatcherServlet/servlet-class!--配置

初始化

springmvc.xml--init-paramparam-namecontextConfigLocation/param-nameparam-valueclasspath:springmvc.xml/param-value/init-param/servletservlet-mappingservlet-namespringmvc/servlet-nameurl-pattern//url-pattern/servlet-mapping/web-app​

分页查询

departmentMapper;​​Overridepublic

ListDepartment

departmentMapper.findAll();}​}​

controller

return*/RequestMapping(/page)public

String

model){//判断页码if(current0){current

从第一页开始}//

分页处理PageHelper.startPage(current,PAGESIZE);//

获得全部数据ListDepartment

jspmodel.addAttribute(pageInfo,pageInfo);​return

listPage;}​​}

contentTypetext/html;charsetUTF-8

languagejava

urihttp://java.sun.com/jsp/jstl/core

%htmlheadtitle部门列表----分页查询/title/headbodyh2部门名称

部门主管

${dep.depEmpName}/li​/c:forEach​/c:if/ul​div​c:if

disableddisabled

href/page?current${pageInfo.pageNum-1}上一页/a--%button

onclickwindow.location.href/page?current${pageInfo.pageNum-1}

disableddisabled

href/page?current${pageInfo.pageNum1}下一页/a--%button

onclickwindow.location.href/page?current${pageInfo.pageNum1}

下一页/button/c:if​共${pageInfo.pages}

第${pageInfo.pageNum}页​/div/body/html