<link rel="stylesheet" href="https://csdnimg.cn/release/blogv2/dist/mdeditor/css/editerView/ck_htmledit_views-1a85854398.css">
<div id="content_views" class="markdown_views prism-atom-one-light">
<svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
<path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
</svg>
<h2><a name="t0"></a><a id="_0"></a>人生有太多不如意,我们要学会去努力</h2>
前言:SSM 整合
整合的思路是:
先创建spring框架
通过spring整合spring mvc
通过spring整合mybatis
ssm整合流程图
1、创建maven工程模块
此图内容为需要配置的目录
2、导入配置文件
导入:springmvc.xml,spring.xml; 其中log4j.properties,jdbc.properties等配置文件根据需求导入!
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/xxx?characterEncoding=utf8
jdbc.username=root
jdbc.password=xxx
- 1
- 2
- 3
- 4
log4j.rootLogger=DEBUG,Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO
- 1
- 2
- 3
- 4
- 5
3、在pom.xml中导入相关依赖
有多余的依赖,根据需求使用
<?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>
<span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>com<span class="token punctuation">.</span>qf<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>springmvc<span class="token operator">-</span>demo4<span class="token operator">-</span>ssm<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.0</span><span class="token operator">-</span>SNAPSHOT<span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>packaging<span class="token punctuation">></span></span>war<span class="token operator"><</span><span class="token operator">/</span>packaging<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>properties<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>spring<span class="token punctuation">.</span>version<span class="token punctuation">></span></span><span class="token number">5.0</span><span class="token number">.2</span><span class="token punctuation">.</span>RELEASE<span class="token operator"><</span><span class="token operator">/</span>spring<span class="token punctuation">.</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>slf4j<span class="token punctuation">.</span>version<span class="token punctuation">></span></span><span class="token number">1.6</span><span class="token number">.6</span><span class="token operator"><</span><span class="token operator">/</span>slf4j<span class="token punctuation">.</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>log4j<span class="token punctuation">.</span>version<span class="token punctuation">></span></span><span class="token number">1.2</span><span class="token number">.12</span><span class="token operator"><</span><span class="token operator">/</span>log4j<span class="token punctuation">.</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>mysql<span class="token punctuation">.</span>version<span class="token punctuation">></span></span><span class="token number">5.1</span><span class="token number">.6</span><span class="token operator"><</span><span class="token operator">/</span>mysql<span class="token punctuation">.</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>mybatis<span class="token punctuation">.</span>version<span class="token punctuation">></span></span><span class="token number">3.4</span><span class="token number">.5</span><span class="token operator"><</span><span class="token operator">/</span>mybatis<span class="token punctuation">.</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>project<span class="token punctuation">.</span>build<span class="token punctuation">.</span>sourceEncoding<span class="token punctuation">></span></span>UTF<span class="token operator">-</span><span class="token number">8</span><span class="token operator"><</span><span class="token operator">/</span>project<span class="token punctuation">.</span>build<span class="token punctuation">.</span>sourceEncoding<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>project<span class="token punctuation">.</span>reporting<span class="token punctuation">.</span>outputEncoding<span class="token punctuation">></span></span>UTF<span class="token operator">-</span><span class="token number">8</span><span class="token operator"><</span><span class="token operator">/</span>project<span class="token punctuation">.</span>reporting<span class="token punctuation">.</span>outputEncoding<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>properties<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>依赖jar包<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependencies<span class="token punctuation">></span></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> spring <span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>aspectj<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>aspectjweaver<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.6</span><span class="token number">.8</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>aop<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>context<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>web<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>把这个包导入相当于把spring中所有需要的包都导入了<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>webmvc<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>test<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>spring 事务管理<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>tx<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>jdbc 连接池<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>springframework<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>spring<span class="token operator">-</span>jdbc<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>spring<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>测试包<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>junit<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>junit<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">4.12</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>scope<span class="token punctuation">></span></span>compile<span class="token operator"><</span><span class="token operator">/</span>scope<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>数据库连接池依赖<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>mysql<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>mysql<span class="token operator">-</span>connector<span class="token operator">-</span>java<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>mysql<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>javax<span class="token punctuation">.</span>servlet<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>servlet<span class="token operator">-</span>api<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.5</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>scope<span class="token punctuation">></span></span>provided<span class="token operator"><</span><span class="token operator">/</span>scope<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>jsp<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>javax<span class="token punctuation">.</span>servlet<span class="token punctuation">.</span>jsp<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>jsp<span class="token operator">-</span>api<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.0</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>scope<span class="token punctuation">></span></span>provided<span class="token operator"><</span><span class="token operator">/</span>scope<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>jsp标准标签库<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>jstl<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>jstl<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.2</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> log start <span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>log4j<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>log4j<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>log4j<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>日志<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>slf4j<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>slf4j<span class="token operator">-</span>api<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>slf4j<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>日志<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>slf4j<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>slf4j<span class="token operator">-</span>log4j12<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>slf4j<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> log end <span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>mybatis<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>mybatis<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span>$<span class="token punctuation">{<!-- --></span>mybatis<span class="token punctuation">.</span>version<span class="token punctuation">}</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>spring整合mybatis适配包<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>mybatis<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>mybatis<span class="token operator">-</span>spring<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.3</span><span class="token number">.0</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>数据库<span class="token operator">--</span><span class="token operator">-</span>连接池<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>c3p0<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>c3p0<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">0.9</span><span class="token number">.1</span><span class="token number">.2</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>type<span class="token punctuation">></span></span>jar<span class="token operator"><</span><span class="token operator">/</span>type<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>scope<span class="token punctuation">></span></span>compile<span class="token operator"><</span><span class="token operator">/</span>scope<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>用于JSON数据转换 三个版本一致<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>com<span class="token punctuation">.</span>fasterxml<span class="token punctuation">.</span>jackson<span class="token punctuation">.</span>core<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>jackson<span class="token operator">-</span>databind<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.9</span><span class="token number">.6</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>com<span class="token punctuation">.</span>fasterxml<span class="token punctuation">.</span>jackson<span class="token punctuation">.</span>core<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>jackson<span class="token operator">-</span>core<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.9</span><span class="token number">.6</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>com<span class="token punctuation">.</span>fasterxml<span class="token punctuation">.</span>jackson<span class="token punctuation">.</span>core<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>jackson<span class="token operator">-</span>annotations<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.9</span><span class="token number">.6</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>分页助手依赖<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>com<span class="token punctuation">.</span>github<span class="token punctuation">.</span>pagehelper<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>pagehelper<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">5.1</span><span class="token number">.10</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>日志依赖<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>ch<span class="token punctuation">.</span>qos<span class="token punctuation">.</span>logback<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>logback<span class="token operator">-</span>classic<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.2</span><span class="token number">.3</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>可以使指定类使用<span class="token annotation punctuation">@Slf4j</span>日志注解<span class="token punctuation">,</span>直接拿log对象调用方法↓<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>可以作实体类的get set方法<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>dependency<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>projectlombok<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>lombok<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">1.18</span><span class="token number">.10</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependency<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>dependencies<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>build<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>plugins<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>plugin<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>groupId<span class="token punctuation">></span></span>org<span class="token punctuation">.</span>apache<span class="token punctuation">.</span>tomcat<span class="token punctuation">.</span>maven<span class="token operator"><</span><span class="token operator">/</span>groupId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>artifactId<span class="token punctuation">></span></span>tomcat7<span class="token operator">-</span>maven<span class="token operator">-</span>plugin<span class="token operator"><</span><span class="token operator">/</span>artifactId<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>version<span class="token punctuation">></span></span><span class="token number">2.2</span><span class="token operator"><</span><span class="token operator">/</span>version<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>configuration<span class="token punctuation">></span></span> <span class="token generics"><span class="token punctuation"><</span>port<span class="token punctuation">></span></span><span class="token number">18081</span><span class="token operator"><</span><span class="token operator">/</span>port<span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>path<span class="token punctuation">></span></span><span class="token operator">/</span><span class="token operator"><</span><span class="token operator">/</span>path<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>configuration<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>plugin<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>plugins<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>build<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token class-name">UserMapper</span><span class="token punctuation">.</span>xml放在接口下要加上下面这句话才行<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>build<span class="token punctuation">></span></span><span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>resources<span class="token punctuation">></span></span><span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>resource<span class="token punctuation">></span></span><span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>directory<span class="token punctuation">></span></span>src<span class="token operator">/</span>main<span class="token operator">/</span>java<span class="token operator"><</span><span class="token operator">/</span>directory<span class="token operator">></span><span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>includes<span class="token punctuation">></span></span><span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span><span class="token generics"><span class="token punctuation"><</span>include<span class="token punctuation">></span></span><span class="token operator">*</span><span class="token operator">*</span><span class="token comment">/*.xml</include>--> <!--</includes>--> <!--</resource>--> <!--</resources>--> <!--</build>-->
</project>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
4、创建数据库
/*
SQLyog Ultimate v12.4.3 (64 bit)
MySQL - 5.7.14-log : Database - student
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/!40101 SET SQL_MODE=’’/;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO’ /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
CREATE DATABASE /!32312 IF NOT EXISTS/student
/*!40100 DEFAULT CHARACTER SET utf8 */;
USE student
;
/*Table structure for table account
*/
DROP TABLE IF EXISTS account
;
CREATE TABLE account
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(20) DEFAULT NULL,
money
double DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
/*Data for the table account
*/
insert into account
(id
,name
,money
) values
(3,‘小舞’,34545),
(10,‘修罗’,34545),
(12,‘文若’,23546),
(13,‘邹神佛’,45645),
(16,‘鲍勃’,23453),
(17,‘卡耐基’,34545),
(18,‘奥格’,45654),
(19,‘苏菲’,23456),
(20,‘Jowett’,34653),
(21,‘卓沃’,23544),
(22,‘绕佛为’,23445),
(23,‘晓燕’,23543),
(24,‘小艳’,34645),
(25,‘史丹佛’,43356),
(26,‘士大夫’,23445),
(27,‘林肯’,34534),
(28,‘瑞文S’,23535);
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
5、创建bean
如果公司允许可以使用生成lombok自动get,set
package com.qf.bean;
public class Account {
private Integer id;
private String name;
private Double money;
<span class="token keyword">public</span> <span class="token class-name">Account</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token class-name">Account</span><span class="token punctuation">(</span><span class="token class-name">Integer</span> id<span class="token punctuation">,</span> <span class="token class-name">String</span> name<span class="token punctuation">,</span> <span class="token class-name">Double</span> money<span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">this</span><span class="token punctuation">.</span>id <span class="token operator">=</span> id<span class="token punctuation">;</span>
<span class="token keyword">this</span><span class="token punctuation">.</span>name <span class="token operator">=</span> name<span class="token punctuation">;</span>
<span class="token keyword">this</span><span class="token punctuation">.</span>money <span class="token operator">=</span> money<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token class-name">Integer</span> <span class="token function">getId</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">return</span> id<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">setId</span><span class="token punctuation">(</span><span class="token class-name">Integer</span> id<span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">this</span><span class="token punctuation">.</span>id <span class="token operator">=</span> id<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token class-name">String</span> <span class="token function">getName</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">return</span> name<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">setName</span><span class="token punctuation">(</span><span class="token class-name">String</span> name<span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">this</span><span class="token punctuation">.</span>name <span class="token operator">=</span> name<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token class-name">Double</span> <span class="token function">getMoney</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">return</span> money<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">setMoney</span><span class="token punctuation">(</span><span class="token class-name">Double</span> money<span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">this</span><span class="token punctuation">.</span>money <span class="token operator">=</span> money<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token annotation punctuation">@Override</span>
<span class="token keyword">public</span> <span class="token class-name">String</span> <span class="token function">toString</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">return</span> <span class="token string">"Account{"</span> <span class="token operator">+</span>
<span class="token string">"id="</span> <span class="token operator">+</span> id <span class="token operator">+</span>
<span class="token string">", name='"</span> <span class="token operator">+</span> name <span class="token operator">+</span> <span class="token string">'\''</span> <span class="token operator">+</span>
<span class="token string">", money="</span> <span class="token operator">+</span> money <span class="token operator">+</span>
<span class="token string">'}'</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
利用反向生成,从前端写到数据库符合人脑思维
6、创建controller
@Controller @RequestMapping("/account") public class AccountController {
<span class="token annotation punctuation">@Autowired</span> <span class="token keyword">private</span> <span class="token class-name">AccountService</span> accountService<span class="token punctuation">;</span> <span class="token annotation punctuation">@RequestMapping</span><span class="token punctuation">(</span><span class="token string">"/find2"</span><span class="token punctuation">)</span> <span class="token annotation punctuation">@ResponseBody</span> <span class="token keyword">public</span> <span class="token class-name">TableData</span> <span class="token function">find</span><span class="token punctuation">(</span><span class="token class-name">Integer</span> page<span class="token punctuation">,</span><span class="token class-name">Integer</span> limit<span class="token punctuation">)</span><span class="token punctuation">{<!-- --></span> <span class="token class-name">PageInfo</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Account</span><span class="token punctuation">></span></span> pageInfo <span class="token operator">=</span> accountService<span class="token punctuation">.</span><span class="token function">findAccounts</span><span class="token punctuation">(</span>page<span class="token punctuation">,</span>limit<span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token class-name">TableData</span> tableData <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">TableData</span><span class="token punctuation">(</span><span class="token string">"no data"</span><span class="token punctuation">,</span> <span class="token number">0</span><span class="token punctuation">,</span> pageInfo<span class="token punctuation">.</span><span class="token function">getList</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">,</span>pageInfo<span class="token punctuation">.</span><span class="token function">getTotal</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token keyword">return</span> tableData<span class="token punctuation">;</span> <span class="token punctuation">}</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
7、创建service
//service接口 public interface AccountService {
<span class="token class-name">PageInfo</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Account</span><span class="token punctuation">></span></span> <span class="token function">findAccounts</span><span class="token punctuation">(</span><span class="token class-name">Integer</span> page<span class="token punctuation">,</span> <span class="token class-name">Integer</span> limit<span class="token punctuation">)</span><span class="token punctuation">;</span>
- 1
- 2
- 3
- 4
@Service //实现service接口 public class AccountServiceImpl implements AccountService {
@Autowired private AccountMapper accountMapper; @Override //分页查询跟查询全部 public PageInfo<Account> findAccounts(Integer page, Integer limit) { PageHelper.startPage(page,limit); List<Account> accounts = accountMapper.findAccounts(); return new PageInfo<Account>(accounts); }
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
8、创建mapper
@Component //创建mapper接口 public interface AccountMapper {
<span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Account</span><span class="token punctuation">></span></span> <span class="token function">findAccounts</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
- 1
- 2
- 3
- 4
- 5
mapper映射文件,文件命名必须跟mapper接口相同,如果跟接口放在一起则在pom.xml中最后加上build
<?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.qf.mapper.AccountMapper">
<span class="token operator"><</span>select id<span class="token operator">=</span><span class="token string">"findAccounts"</span> resultType<span class="token operator">=</span><span class="token string">"Account"</span><span class="token operator">></span> select <span class="token operator">*</span> from account <span class="token operator"><</span><span class="token operator">/</span>select<span class="token operator">></span>
</mapper>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
9、配置web.xml
在WEB-INF中配置web.xml文件
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <!--前端控制器--> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<span class="token operator"><</span>init<span class="token operator">-</span>param<span class="token operator">></span> <span class="token operator"><</span>param<span class="token operator">-</span>name<span class="token operator">></span>contextConfigLocation<span class="token operator"><</span><span class="token operator">/</span>param<span class="token operator">-</span>name<span class="token operator">></span> <span class="token operator"><</span>param<span class="token operator">-</span>value<span class="token operator">></span>classpath<span class="token operator">:</span>springmvc<span class="token punctuation">.</span>xml<span class="token operator"><</span><span class="token operator">/</span>param<span class="token operator">-</span>value<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>init<span class="token operator">-</span>param<span class="token operator">></span> <span class="token operator"><</span>load<span class="token operator">-</span>on<span class="token operator">-</span>startup<span class="token operator">></span><span class="token number">1</span><span class="token operator"><</span><span class="token operator">/</span>load<span class="token operator">-</span>on<span class="token operator">-</span>startup<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>servlet<span class="token operator">></span> <span class="token operator"><</span>servlet<span class="token operator">-</span>mapping<span class="token operator">></span> <span class="token operator"><</span>servlet<span class="token operator">-</span>name<span class="token operator">></span>dispatcherServlet<span class="token operator"><</span><span class="token operator">/</span>servlet<span class="token operator">-</span>name<span class="token operator">></span> <span class="token operator"><</span>url<span class="token operator">-</span>pattern<span class="token operator">></span><span class="token operator">/</span><span class="token operator"><</span><span class="token operator">/</span>url<span class="token operator">-</span>pattern<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>servlet<span class="token operator">-</span>mapping<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>字符编码过滤器<span class="token operator">--</span><span class="token operator">></span> <span class="token generics"><span class="token punctuation"><</span>filter<span class="token punctuation">></span></span> <span class="token operator"><</span>filter<span class="token operator">-</span>name<span class="token operator">></span>characterEncodingFilter<span class="token operator"><</span><span class="token operator">/</span>filter<span class="token operator">-</span>name<span class="token operator">></span> <span class="token operator"><</span>filter<span class="token operator">-</span><span class="token keyword">class</span><span class="token operator">></span><span class="token class-name"><span class="token namespace">org<span class="token punctuation">.</span>springframework<span class="token punctuation">.</span>web<span class="token punctuation">.</span>filter<span class="token punctuation">.</span></span>CharacterEncodingFilter</span><span class="token operator"><</span><span class="token operator">/</span>filter<span class="token operator">-</span><span class="token keyword">class</span><span class="token operator">></span> <span class="token operator"><</span>init<span class="token operator">-</span>param<span class="token operator">></span> <span class="token operator"><</span>param<span class="token operator">-</span>name<span class="token operator">></span>encoding<span class="token operator"><</span><span class="token operator">/</span>param<span class="token operator">-</span>name<span class="token operator">></span> <span class="token operator"><</span>param<span class="token operator">-</span>value<span class="token operator">></span>utf<span class="token operator">-</span><span class="token number">8</span><span class="token operator"><</span><span class="token operator">/</span>param<span class="token operator">-</span>value<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>init<span class="token operator">-</span>param<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>filter<span class="token operator">></span> <span class="token operator"><</span>filter<span class="token operator">-</span>mapping<span class="token operator">></span> <span class="token operator"><</span>filter<span class="token operator">-</span>name<span class="token operator">></span>characterEncodingFilter<span class="token operator"><</span><span class="token operator">/</span>filter<span class="token operator">-</span>name<span class="token operator">></span> <span class="token operator"><</span>url<span class="token operator">-</span>pattern<span class="token operator">></span><span class="token comment">/*</url-pattern> </filter-mapping>
</web-app>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
10、配置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: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 http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> 配置的连接池对象 value位置可以配置文件引入<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>bean id<span class="token operator">=</span><span class="token string">"dataSource"</span> <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"com.mchange.v2.c3p0.ComboPooledDataSource"</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"driverClass"</span> value<span class="token operator">=</span><span class="token string">"com.mysql.jdbc.Driver"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"jdbcUrl"</span> value<span class="token operator">=</span><span class="token string">"jdbc:mysql://localhost:3306/student"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"user"</span> value<span class="token operator">=</span><span class="token string">"root"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"password"</span> value<span class="token operator">=</span><span class="token string">"xxx"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> 配置<span class="token class-name">SqlSession</span>的工厂 <span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>bean id<span class="token operator">=</span><span class="token string">"sqlSessionFactory"</span> <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"org.mybatis.spring.SqlSessionFactoryBean"</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"dataSource"</span> ref<span class="token operator">=</span><span class="token string">"dataSource"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>别名<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"typeAliasesPackage"</span> value<span class="token operator">=</span><span class="token string">"com.qf.bean"</span><span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>property<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>分页助手插件配置拦截↓<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"plugins"</span><span class="token operator">></span> <span class="token operator"><</span>bean <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"com.github.pagehelper.PageInterceptor"</span><span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>property<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span> 配置扫描dao的包 <span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>bean id<span class="token operator">=</span><span class="token string">"mapperScanner"</span> <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"org.mybatis.spring.mapper.MapperScannerConfigurer"</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"basePackage"</span> value<span class="token operator">=</span><span class="token string">"com.qf.mapper"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span>bean id<span class="token operator">=</span><span class="token string">"transactionManager"</span> <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"org.springframework.jdbc.datasource.DataSourceTransactionManager"</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"dataSource"</span> ref<span class="token operator">=</span><span class="token string">"dataSource"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>事务控制<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>tx<span class="token operator">:</span>advice id<span class="token operator">=</span><span class="token string">"tx"</span> transaction<span class="token operator">-</span>manager<span class="token operator">=</span><span class="token string">"transactionManager"</span><span class="token operator">></span> <span class="token operator"><</span>tx<span class="token operator">:</span>attributes<span class="token operator">></span> <span class="token operator"><</span>tx<span class="token operator">:</span>method name<span class="token operator">=</span><span class="token string">"list"</span> read<span class="token operator">-</span>only<span class="token operator">=</span><span class="token string">"true"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span>tx<span class="token operator">:</span>method name<span class="token operator">=</span><span class="token string">"addAccount"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>tx<span class="token operator">:</span>attributes<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>tx<span class="token operator">:</span>advice<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>前置增强<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>aop<span class="token operator">:</span>config<span class="token operator">></span> <span class="token operator"><</span>aop<span class="token operator">:</span>advisor pointcut<span class="token operator">=</span><span class="token string">"execution(* com.qf.service.impl.*.*(..))"</span> advice<span class="token operator">-</span>ref<span class="token operator">=</span><span class="token string">"tx"</span><span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>aop<span class="token operator">:</span>config<span class="token operator">></span>
</beans>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
11、配置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://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<span class="token operator"><</span>context<span class="token operator">:</span>component<span class="token operator">-</span>scan base<span class="token operator">-</span><span class="token keyword">package</span><span class="token operator">=</span><span class="token string">"com.qf"</span> <span class="token operator">/</span><span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>配置注解驱动dr<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>mvc<span class="token operator">:</span>annotation<span class="token operator">-</span>driven<span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>mvc<span class="token operator">:</span>annotation<span class="token operator">-</span>driven<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>静态资源过滤<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span>mvc<span class="token operator">:</span><span class="token keyword">default</span><span class="token operator">-</span>servlet<span class="token operator">-</span>handler<span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>mvc<span class="token operator">:</span><span class="token keyword">default</span><span class="token operator">-</span>servlet<span class="token operator">-</span>handler<span class="token operator">></span> <span class="token operator"><</span>bean <span class="token keyword">class</span><span class="token operator">=</span><span class="token string">"org.springframework.web.servlet.view.InternalResourceViewResolver"</span><span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"suffix"</span> value<span class="token operator">=</span><span class="token string">".jsp"</span><span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>property<span class="token operator">></span> <span class="token operator"><</span>property name<span class="token operator">=</span><span class="token string">"prefix"</span> value<span class="token operator">=</span><span class="token string">"/WEB-INF/pages/"</span><span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span>property<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">/</span>bean<span class="token operator">></span> <span class="token operator"><</span><span class="token operator">!</span><span class="token operator">--</span>引入spring<span class="token punctuation">.</span>xml文件的内容交给springmvc来管理<span class="token operator">--</span><span class="token operator">></span> <span class="token operator"><</span><span class="token keyword">import</span> <span class="token namespace">resource</span><span class="token operator">=</span><span class="token string">"spring.xml"</span><span class="token operator">></span><span class="token operator"><</span><span class="token operator">/</span><span class="token keyword">import</span><span class="token operator">></span>
</beans>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
启动项目输入:http://localhost:8080/
简单的查询就出来了
故天将降大任于是人也,必先苦其心志,劳其筋骨,饿其体肤,空乏其身,行拂乱其所为,所以动心忍性,曾益其所不能!