SSM整合-配置文件

使用工具：maven、idea、jdk8、mysql、tomcat9.0

初学ssm框架，配置文件的配置目录：

                                   

其中generator.xml是用mybatis从数据库中表逆向生成pojo、dao、mapper下此表的相关信息。

配置文件如下：

1、pom.xml

 1 <properties>

 2 <project.build.sourceencoding>utf-8</project.build.sourceencoding>

 3 <maven.compiler.source>1.8</maven.compiler.source>

 4 <maven.compiler.target>1.8</maven.compiler.target>

 5

 6 <!--srping版本-->

 7 <spring.version>4.3.14.release</spring.version>

 8 <!--mybatis版本-->

 9 <mybatis.version>3.4.0</mybatis.version>

 10 <!-- log4j日志文件管理包版本 -->

 11 <slf4j.version>1.6.6</slf4j.version>

 12 <log4j.version>1.2.12</log4j.version>

 13 </properties>

 14

 15

 16 <dependencies>

 17

 18 <!-- 导入mysql数据库链接jar包 -->

 19 <dependency>

 20 <groupid>mysql</groupid>

 21 <artifactid>mysql-connector-java</artifactid>

 22 <version>5.1.6</version>

 23 </dependency>

 24

 25

 26 <!-- https://mvnrepository.com/artifact/junit/junit -->

 27 <dependency>

 28 <groupid>junit</groupid>

 29 <artifactid>junit</artifactid>

 30 <version>4.12</version>

 31 <scope>test</scope>

 32 </dependency>

 33

 34

 35 <!-- mybatis核心包 -->

 36 <dependency>

 37 <groupid>org.mybatis</groupid>

 38 <artifactid>mybatis</artifactid>

 39 <version>${mybatis.version}</version>

 40 </dependency>

 41 <!-- mybatis/spring包 -->

 42 <dependency>

 43 <groupid>org.mybatis</groupid>

 44 <artifactid>mybatis-spring</artifactid>

 45 <version>1.3.0</version>

 46 </dependency>

 47

 48

 49 <!--spring单元测试依赖 -->

 50 <dependency>

 51 <groupid>org.springframework</groupid>

 52 <artifactid>spring-test</artifactid>

 53 <version>${spring.version}</version>

 54 <scope>test</scope>

 55 </dependency>

 56

 57 <!-- springmvc核心包 -->

 58 <dependency>

 59 <groupid>org.springframework</groupid>

 60 <artifactid>spring-webmvc</artifactid>

 61 <version>${spring.version}</version>

 62 </dependency>

 63

 64 <!-- spring核心包 -->

 65 <dependency>

 66 <groupid>org.springframework</groupid>

 67 <artifactid>spring-core</artifactid>

 68 <version>${spring.version}</version>

 69 </dependency>

 70

 71 <dependency>

 72 <groupid>org.springframework</groupid>

 73 <artifactid>spring-beans</artifactid>

 74 <version>${spring.version}</version>

 75 </dependency>

 76

 77 <dependency>

 78 <groupid>org.springframework</groupid>

 79 <artifactid>spring-context</artifactid>

 80 <version>${spring.version}</version>

 81 </dependency>

 82

 83 <dependency>

 84 <groupid>org.springframework</groupid>

 85 <artifactid>spring-context-support</artifactid>

 86 <version>${spring.version}</version>

 87 </dependency>

 88

 89 <dependency>

 90 <groupid>org.springframework</groupid>

 91 <artifactid>spring-tx</artifactid>

 92 <version>${spring.version}</version>

 93 </dependency>

 94

 95 <dependency>

 96 <groupid>org.springframework</groupid>

 97 <artifactid>spring-web</artifactid>

 98 <version>${spring.version}</version>

 99 </dependency>

100

101 <dependency>

102 <groupid>org.springframework</groupid>

103 <artifactid>spring-jdbc</artifactid>

104 <version>${spring.version}</version>

105 </dependency>

106

107 <dependency>

108 <groupid>javax.servlet</groupid>

109 <artifactid>javax.servlet-api</artifactid>

110 <version>3.0.1</version>

111 <scope>provided</scope>

112 </dependency>

113

114 <dependency>

115 <groupid>javax.servlet.jsp</groupid>

116 <artifactid>jsp-api</artifactid>

117 <version>2.2</version>

118 <scope>provided</scope>

119 </dependency>

120 <!--mysql数据库链接包-->

121 <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->

122 <dependency>

123 <groupid>org.apache.commons</groupid>

124 <artifactid>commons-dbcp2</artifactid>

125 <version>2.1.1</version>

126 </dependency>

127

128 <!-- https://mvnrepository.com/artifact/net.sf.json-lib/json-lib-->;

129 <!--<dependency>

130 <groupid>net.sf.json-lib</groupid>

131 <artifactid>json-lib</artifactid>

132 <version>2.4</version>

133 </dependency>-->

134

135 <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->

136 <dependency>

137 <groupid>com.fasterxml.jackson.core</groupid>

138 <artifactid>jackson-databind</artifactid>

139 <version>2.9.8</version>

140 </dependency>

141

142 <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->

143 <dependency>

144 <groupid>com.fasterxml.jackson.core</groupid>

145 <artifactid>jackson-core</artifactid>

146 <version>2.9.8</version>

147 </dependency>

148

149 <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-annotations -->

150 <dependency>

151 <groupid>com.fasterxml.jackson.core</groupid>

152 <artifactid>jackson-annotations</artifactid>

153 <version>2.9.8</version>

154 </dependency>

155

156 <!--jsr303数据校验支持，支持tomcat7及以上版本-->

157 <!-- https://mvnrepository.com/artifact/org.hibernate.validator/hibernate-validator -->

158 <dependency>

159 <groupid>org.hibernate.validator</groupid>

160 <artifactid>hibernate-validator</artifactid>

161 <version>6.0.16.final</version>

162 </dependency>

163

164

165 <!-- jstl标签类 -->

166 <dependency>

167 <groupid>jstl</groupid>

168 <artifactid>jstl</artifactid>

169 <version>1.2</version>

170 </dependency>

171 <!-- 日志文件管理包 -->

172 <dependency>

173 <groupid>log4j</groupid>

174 <artifactid>log4j</artifactid>

175 <version>1.2.17</version>

176 </dependency>

177

178 <!-- 上传组件包 -->

179 <dependency>

180 <groupid>commons-fileupload</groupid>

181 <artifactid>commons-fileupload</artifactid>

182 <version>1.3.1</version>

183 </dependency>

184 <dependency>

185 <groupid>commons-io</groupid>

186 <artifactid>commons-io</artifactid>

187 <version>2.4</version>

188 </dependency>

189 <dependency>

190 <groupid>commons-codec</groupid>

191 <artifactid>commons-codec</artifactid>

192 <version>1.9</version>

193 </dependency>

194

195 <!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->

196 <dependency>

197 <groupid>com.github.pagehelper</groupid>

198 <artifactid>pagehelper</artifactid>

199 <version>5.1.10</version>

200 </dependency>

201

202

203 <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->

204 <dependency>

205 <groupid>org.mybatis.generator</groupid>

206 <artifactid>mybatis-generator-core</artifactid>

207 <version>1.3.7</version>

208 </dependency>

209 <!-- <dependency>

210 <groupid>org.junit.jupiter</groupid>

211 <artifactid>junit-jupiter-api</artifactid>

212 <version>release</version>

213 <scope>compile</scope>

214 </dependency>-->

215

216 </dependencies>

217

218 <build>

219 <finalname>ssm-crud</finalname>

220 <plugins>

221 <plugin>

222 <groupid>org.mybatis.generator</groupid>

223 <artifactid>mybatis-generator-maven-plugin</artifactid>

224 <version>1.3.7</version>

225 </plugin>

226 </plugins>

227 <pluginmanagement><!-- lock down plugins versions to avoid using maven defaults (may be moved to parent pom) -->

228 <plugins>

229 <plugin>

230 <artifactid>maven-clean-plugin</artifactid>

231 <version>3.1.0</version>

232 </plugin>

233 <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#plugin_bindings_for_war_packaging -->

234 <plugin>

235 <artifactid>maven-resources-plugin</artifactid>

236 <version>3.0.2</version>

237 </plugin>

238 <plugin>

239 <artifactid>maven-compiler-plugin</artifactid>

240 <version>3.8.0</version>

241 </plugin>

242 <plugin>

243 <artifactid>maven-surefire-plugin</artifactid>

244 <version>2.22.1</version>

245 </plugin>

246 <plugin>

247 <artifactid>maven-war-plugin</artifactid>

248 <version>3.2.2</version>

249 </plugin>

250 <plugin>

251 <artifactid>maven-install-plugin</artifactid>

252 <version>2.5.2</version>

253 </plugin>

254 <plugin>

255 <artifactid>maven-deploy-plugin</artifactid>

256 <version>2.8.2</version>

257 </plugin>

258 </plugins>

259 </pluginmanagement>

260 </build>

261 </project>

2、db.properties

 1 db.driverclassname=com.mysql.jdbc.driver

 2 db.url=jdbc:mysql://localhost:3306/ssm_crud?useunicode=true&characterencoding=utf-8

 3 db.username=root

 4 db.password=123456

 5 #定义初始连接数newsmanagement

 6 db.initialsize=0

 7 #定义最大连接数

 8 db.maxactive=20

 9 #定义最长等待时间

 10 db.maxwait=60000

3、log4j.properties

 1 # global logging configuration

 2 log4j.rootlogger=debug, stdout

 3 # console output...

 4 log4j.appender.stdout=org.apache.log4j.consoleappender

 5 log4j.appender.stdout.layout=org.apache.log4j.patternlayout

 6 log4j.appender.stdout.layout.conversionpattern=%5p [%t] - %m%n

4、applicationcontext.xml

 1 <?xml version="1.0" encoding="utf-8"?>

 2 <beans xmlns="http://www.springframework.org/schema/beans"

 3 xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

 4 xmlns:p="http://www.springframework.org/schema/p"

 5 xmlns:context="http://www.springframework.org/schema/context"

 6 xmlns:tx="http://www.springframework.org/schema/tx"

 7 xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop"

 8 xsi:schemalocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd

 9 http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

 10 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

 11 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

 12 <!-- 扫描service包，让service的注解起作用 -->

 13 <context:component-scan base-package="com.xwh"/>

 14 <!-- 加载db.propertites -->

 15 <context:property-placeholder location="classpath:db.properties"/>

 16 <bean id="datasource"

 17 class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close">

 18 <property name="driverclassname" value="${db.driverclassname}"/>

 19 <property name="url" value="${db.url}"/>

 20 <property name="username" value="${db.username}"/>

 21 <property name="password" value="${db.password}"/>

 22 <property name="initialsize" value="${db.initialsize}"/>

 23 <property name="maxwaitmillis" value="${db.maxwait}"/>

 24 <property name="maxtotal" value="${db.maxactive}"/>

 25 </bean>

 26 <bean id="sqlsessionfactory"

 27 class="org.mybatis.spring.sqlsessionfactorybean">

 28 <property name="datasource" ref="datasource"></property>

 29 <property name="configlocation" value="classpath:mybatis/mybatis-config.xml"></property>

 30 <property name="mapperlocations" value="classpath:mybatis/mapper/*mapper.xml"></property>

 31 </bean>

 32 <!--配置一个可以执行批量的sqlsession-->

 33 <bean id="sqlsession" class="org.mybatis.spring.sqlsessiontemplate">

 34 <constructor-arg name="sqlsessionfactory" ref="sqlsessionfactory"></constructor-arg>

 35 <constructor-arg name="executortype" value="batch"></constructor-arg>

 36 </bean>

 37 <!-- mapper扫描器 -->

 38 <!-- 会自动生成一个标识为mapper接口类型首字母小写的bean -->

 39 <bean class="org.mybatis.spring.mapper.mapperscannerconfigurer">

 40 <property name="basepackage" value="com.xwh.dao"></property>

 41 <property name="sqlsessionfactorybeanname" value="sqlsessionfactory"></property>

 42 </bean>

 43 <!--事务控制的配置-->

 44 <bean id="txmanager"

 45 class="org.springframework.jdbc.datasource.datasourcetransactionmanager">

 46 <property name="datasource" ref="datasource"></property>

 47 </bean>

 48 <tx:annotation-driven transaction-manager="txmanager"/>

 49 </beans>

 50 

5、springmvc.xml

 1 <?xml version="1.0" encoding="utf-8"?>

 2 <beans xmlns="http://www.springframework.org/schema/beans"

 3 xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

 4 xmlns:p="http://www.springframework.org/schema/p"

 5 xmlns:context="http://www.springframework.org/schema/context"

 6 xmlns:mvc="http://www.springframework.org/schema/mvc"

 7 xsi:schemalocation="http://www.springframework.org/schema/beans

 8 http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

 9 http://www.springframework.org/schema/context

 10 http://www.springframework.org/schema/context/spring-context-3.1.xsd

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

 12 http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

 13

 14 <context:component-scan base-package="com.xwh.controller" />

 15

 16 <mvc:annotation-driven />

 17

 18 <!-- 处理请求转发 -->

 19 <bean class="org.springframework.web.servlet.view.internalresourceviewresolver">

 20 <property name="prefix" value="/web-inf/views/" />

 21 <property name="suffix" value=".jsp" />

 22 </bean>

 23

 24 <!--将springmvc不能处理的请求交给tomcat-->

 25 <mvc:default-servlet-handler/>

 26

 27 <!-- 对静态资源放行 -->

 28 <!-- 映射到根目录下，文件引用静态资源时就加上static.. -->

 29 <mvc:resources mapping="/static/**" location="static/" />

 30

 31

 32 <!-- 上传文件拦截，设置最大上传文件大小 10m=1010241024(b)=10485760 bytes -->

 33 <bean id="multipartresolver"

 34 class="org.springframework.web.multipart.commons.commonsmultipartresolver">

 35 <!-- 最大文件大小限制 -->

 36 <property name="maxuploadsize" value="10485760" />

 37 <property name="defaultencoding" value="utf-8" />

 38 </bean>

 39

 40 </beans>

6、mybatis-config.xml

 1 <?xml version="1.0" encoding="utf-8" ?>

 2 <!doctype configuration

 3 public "-//mybatis.org//dtd config 3.0//en"

 4 "http://mybatis.org/dtd/mybatis-3-config.dtd">

 5

 6 <configuration>

 7

 8 <settings>

 9 <setting name="logimpl" value="log4j"/>

 10 <!-- 使用列标签代替列名 -->

 11 <!--<setting name="usecolumnlabel" value="false"/>-->

 12 <!--允许 jdbc 支持自动生成主键-->

 13 <setting name="usegeneratedkeys" value="false"/>

 14 <!--是否开启自动驼峰命名规则（camel case）映射，即从经典数据库列名 a_column 到经典 java 属性名 acolumn 的类似映射。 -->

 15 <setting name="mapunderscoretocamelcase" value="true"/>

 16 </settings>

 17

 18 <typealiases>

 19 <package name="com.xwh.entity"/>

 20 </typealiases>

 21 <!-- 数据源的配置交给spring -->

 22 <!-- 关联映射文件交给spring的mapper扫描器 -->

 23

 24

 25 <!-- 配置mybatis分页插件pagehelper -->

 26 <plugins>

 27 <plugin interceptor="com.github.pagehelper.pageinterceptor">

 28 <!--分页参数合理化-->

 29 <property name="reasonable" value="true"/>

 30 </plugin>

 31 </plugins>

 32 </configuration>

7、mapper.xml

 1 <?xml version="1.0" encoding="utf-8"?>

 2 <!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

 3 <mapper namespace="com.xwh.dao.employeemapper">

 4

 5 </mapper>

8、generatorconfig.xml

 1 <?xml version="1.0" encoding="utf-8"?>

 2 <!doctype generatorconfiguration

 3 public "-//mybatis.org//dtd mybatis generator configuration 1.0//en"

 4 "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

 5

 6 <generatorconfiguration>

 7 <classpathentry location="e:\reposi\mysql\mysql-connector-java\5.1.30\mysql-connector-java-5.1.30.jar" />

 8

 9 <context id="db2tables" targetruntime="mybatis3">

 10 <!-- 去掉注释-->

 11 <commentgenerator>

 12 <property name="suppressdate" value="true"/>

 13 <property name="suppressallcomments" value="true" />

 14 </commentgenerator>

 15

 16 <jdbcconnection driverclass="com.mysql.jdbc.driver"

 17 connectionurl="jdbc:mysql://localhost:3306/ssm_crud"

 18 userid="root"

 19 password="123456">

 20 </jdbcconnection>

 21

 22 <javatyperesolver >

 23 <property name="forcebigdecimals" value="false" />

 24 </javatyperesolver>

 25

 26 <javamodelgenerator targetpackage="com.xwh.entity" targetproject="src\main\java">

 27 <property name="enablesubpackages" value="true" />

 28 <property name="trimstrings" value="true" />

 29 </javamodelgenerator>

 30

 31 <sqlmapgenerator targetpackage="mapper" targetproject="src\main\resources\mybatis">

 32 <property name="enablesubpackages" value="true" />

 33 </sqlmapgenerator>

 34

 35 <javaclientgenerator type="xmlmapper" targetpackage="com.xwh.dao" targetproject="src\main\java">

 36 <property name="enablesubpackages" value="true" />

 37 </javaclientgenerator>

 38

 39 <table tablename="employee" domainobjectname="employee" enablecountbyexample="false" enableupdatebyexample="false" enabledeletebyexample="false"

 40 enableselectbyexample="false" selectbyexamplequeryid="false">

 41 </table>

 42

 43 <table tablename="department" domainobjectname="department" enablecountbyexample="false" enableupdatebyexample="false" enabledeletebyexample="false"

 44 enableselectbyexample="false" selectbyexamplequeryid="false">

 45 </table>

 46 </context>

 47 </generatorconfiguration>

9、web.xml

 1 <!doctype web-app public

 2 "-//sun microsystems, inc.//dtd web application 2.3//en"

 3 "http://java.sun.com/dtd/web-app_2_3.dtd" >

 4 <web-app version="2.4"

 5 xmlns="http://java.sun.com/xml/ns/j2ee"

 6 xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

 7 xsi:schemalocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

 8

 9 <display-name>ssm-crud</display-name>

 10

 11 <welcome-file-list>

 12 <welcome-file>index2.jsp</welcome-file>

 13 </welcome-file-list>

 14 <!-- 加载spring容器配置 -->

 15 <listener>

 16 <listener-class>

 17 org.springframework.web.context.contextloaderlistener

 18 </listener-class>

 19 </listener>

 20

 21 <!-- 设置spring容器加载所有的配置文件的路径 -->

 22 <context-param>

 23 <param-name>contextconfiglocation</param-name>

 24 <param-value>classpath:spring/applicationcontext.xml</param-value>

 25 </context-param>

 26

 27 <context-param>

 28 <param-name>log4jconfiglocation</param-name>

 29 <param-value>classpath:log4j.properties</param-value>

 30 </context-param>

 31

 32 <!-- 配置springmvc核心控制器 -->

 33 <servlet>

 34 <servlet-name>dispatcherservlet</servlet-name>

 35 <servlet-class>

 36 org.springframework.web.servlet.dispatcherservlet

 37 </servlet-class>

 38 <init-param>

 39 <param-name>contextconfiglocation</param-name>

 40 <param-value>classpath:springmvc/springmvc.xml</param-value>

 41 </init-param>

 42 <load-on-startup>1</load-on-startup>

 43 </servlet>

 44 <servlet-mapping>

 45 <servlet-name>dispatcherservlet</servlet-name>

 46 <url-pattern>/</url-pattern>

 47 </servlet-mapping>

 48

 49 <!-- 解决中文乱码 -->

 50 <filter>

 51 <filter-name>encodingfilter</filter-name>

 52 <filter-class>org.springframework.web.filter.characterencodingfilter</filter-class>

 53 <init-param>

 54 <param-name>encoding</param-name>

 55 <param-value>utf-8</param-value>

 56 </init-param>

 57 <init-param>

 58 <param-name>forcerequestencoding</param-name>

 59 <param-value>true</param-value>

 60 </init-param>

 61 <init-param>

 62 <param-name>forceresponseencoding</param-name>

 63 <param-value>true</param-value>

 64 </init-param>

 65 </filter>

 66 <filter-mapping>

 67 <filter-name>encodingfilter</filter-name>

 68 <url-pattern>/

</url-pattern>
69 </filter-mapping>
70
71 <!--使用rest风格的uri-->
72 <!--将页面普通的post请求转为指定的delete或者put请求-->
73 <filter>
74 <filter-name>hiddenhttpmethodfilter</filter-name>
75 <filter-class>org.springframework.web.filter.hiddenhttpmethodfilter</filter-class>
76 </filter>
77 <filter-mapping>
78 <filter-name>hiddenhttpmethodfilter</filter-name>
79 <url-pattern>/*</url-pattern>
80 </filter-mapping>
81
82 </web-app>
83
84
85

posted @ 2019-08-24 14:27 novicelearning 阅读(...) 评论(...) 编辑 收藏

刷新评论刷新页面

copyright © 2019 novicelearning
powered by .net core 3.0 preview 8 on linux