Spring+SpringMVC+Mybatis框架搭建

待我称王封你为后i 2022-09-26 00:24 256阅读 0赞

项目建设完成之后的结构：

![A100756555-124775.png_small.png][]

数据库的表结构如下：

![A100758758-124775.png_small.png][]

环境建设：搭建Maven环境、Tomcat环境、需要MySql 数据库支持，使用的编程工具Eclipse （这些是前期准备）；

开始创建工程：

1.创建一个Maven工程：

![A100800992-124775.png_small.png][]

选择webapp

![A100803258-124775.png_small.png][]

随便填写了：

![A100805445-124775.png_small.png][]

创建完成之后工程会报错：

接下来怎么解决的？

选中项目点击右键，选择“Properties”  进入下面界面：

选中project facets ，然后将java版本改成 你的jdk版本，或者1.6以上版本。

![A100807820-124775.png_small.png][]

之后选择 java build path

![A100810258-124775.png_small.png][]

修改lib里面的java版本：

选中上面的jre System Library 然后选择 edit ![A100812633-124775.png_small.png][]

保存之后再看看工程。上面的操作主要是让目录结构显示正常。（上面的不一定可以解决问题，工程还是会报错的）

在pom.xml文件中添加依赖：

<dependency>   
            <groupId>javax</groupId>   
            <artifactId>javaee-api</artifactId>   
            <version>7.0</version>   
        </dependency>

这个立竿见影；不报错了。

之后再pom文件中添加依赖包，最终pom.xml文件如下：

<pre style="font-size: 13px; padding: 9.5px; font-family: Monaco, Menlo, Consolas, "Courier New", monospace; color: rgb(51, 51, 51); border-radius: 4px; margin-top: 0px; margin-bottom: 10px; line-height: 20px; word-break: break-all; word-wrap: break-word; white-space: pre-wrap; background-color: rgb(245, 245, 245); border: 1px solid rgba(0, 0, 0, 0.14902);"><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/maven-v4_0_0.xsd">
 <modelVersion>4.0.0</modelVersion>
 <groupId>com.eliteams</groupId>
 <artifactId>quick4j</artifactId>
 <packaging>war</packaging>
 <version>1.0.0</version>
 <name>quick4j App</name>
 <url>https://github.com/starzou/quick4j</url>
 
 <build>
 <finalName>quick4j</finalName>
 <plugins>
 
 <plugin>
 <groupId>org.mybatis.generator</groupId>
 <artifactId>mybatis-generator-maven-plugin</artifactId>
 <version>${plugin.mybatis.generator}</version>
 <configuration>
 <configurationFile>${mybatis.generator.generatorConfig.xml}</configurationFile>
 <overwrite>true</overwrite>
 <verbose>true</verbose>
 </configuration>
 </plugin>
 
 
 <plugin>
 <groupId>org.apache.maven.plugins</groupId>
 <artifactId>maven-compiler-plugin</artifactId>
 <version>${plugin.maven-compiler}</version>
 <configuration>
 <source>${project.build.jdk}</source>
 <target>${project.build.jdk}</target>
 <encoding>${project.build.sourceEncoding}</encoding>
 </configuration>
 </plugin>
 
 <plugin>
 <groupId>org.apache.maven.plugins</groupId>
 <artifactId>maven-surefire-plugin</artifactId>
 <version>${plugin.maven-surefire}</version>
 <configuration>
 <skipTests>${skipTests}</skipTests>
 </configuration>
 </plugin>
 </plugins>
 
 
 <resources>
 <resource>
 <directory>src/main/resources</directory>
 <includes>
 <include>**/*.properties</include>
 <include>**/*.xml</include>
 </includes>
 <filtering>true</filtering>
 </resource>
 <resource>
 <directory>src/main/java</directory>
 <includes>
 <include>**/*.properties</include>
 <include>**/*.xml</include>
 </includes>
 <filtering>true</filtering>
 </resource>
 </resources>
 </build>
 
 <properties>
 
 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
 <project.build.locales>zh_CN</project.build.locales>
 <project.build.jdk>1.7</project.build.jdk>
 
 
 <mybatis.generator.generatorConfig.xml>${basedir}/src/test/resources/generatorConfig.xml</mybatis.generator.generatorConfig.xml>
 <mybatis.generator.generatorConfig.properties>file:///${basedir}/src/test/resources/generatorConfig.properties</mybatis.generator.generatorConfig.properties>
 
 
 <plugin.mybatis.generator>1.3.1</plugin.mybatis.generator>
 <plugin.maven-compiler>3.1</plugin.maven-compiler>
 <plugin.maven-surefire>2.18.1</plugin.maven-surefire>
 <skipTests>true</skipTests>
 
 
 <junit.version>4.11</junit.version>
 <spring.version>4.0.2.RELEASE</spring.version>
 <mybatis.version>3.2.2</mybatis.version>
 <mybatis.spring.version>1.2.2</mybatis.spring.version>
 <mysql.connector.version>5.1.30</mysql.connector.version>
 <postgresql.version>9.1-901.jdbc4</postgresql.version>
 <slf4j.version>1.6.6</slf4j.version>
 <log4j.version>1.2.12</log4j.version>
 <httpclient.version>4.1.2</httpclient.version>
 <jackson.version>1.9.13</jackson.version>
 <c3p0.version>0.9.1.2</c3p0.version>
 <druid.version>1.0.5</druid.version>
 <tomcat.jdbc.version>7.0.53</tomcat.jdbc.version>
 <jstl.version>1.2</jstl.version>
 <google.collections.version>1.0</google.collections.version>
 <cglib.version>3.1</cglib.version>
 <shiro.version>1.2.3</shiro.version>
 <commons.fileupload.version>1.3.1</commons.fileupload.version>
 <commons.codec.version>1.9</commons.codec.version>
 <commons.net.version>3.3</commons.net.version>
 <aspectj.version>1.6.12</aspectj.version>
 <netty.version>4.0.18.Final</netty.version>
 <hibernate.validator.version>5.1.1.Final</hibernate.validator.version>
 </properties>

<dependency>
 <groupId>junit</groupId>
 <artifactId>junit</artifactId>
 <version>${junit.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-core</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-web</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-oxm</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-tx</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-jdbc</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-webmvc</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-aop</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-context-support</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.springframework</groupId>
 <artifactId>spring-test</artifactId>
 <version>${spring.version}</version>
 </dependency>
 
 
 
 <dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis</artifactId>
 <version>${mybatis.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.mybatis</groupId>
 <artifactId>mybatis-spring</artifactId>
 <version>${mybatis.spring.version}</version>
 </dependency>
 
 
 
 <dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
 <version>${mysql.connector.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>com.alibaba</groupId>
 <artifactId>druid</artifactId>
 <version>${druid.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>org.codehaus.jackson</groupId>
 <artifactId>jackson-mapper-asl</artifactId>
 <version>${jackson.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>log4j</groupId>
 <artifactId>log4j</artifactId>
 <version>${log4j.version}</version>
 </dependency>
 <dependency>
 <groupId>org.slf4j</groupId>
 <artifactId>slf4j-api</artifactId>
 <version>${slf4j.version}</version>
 </dependency>
 <dependency>
 <groupId>org.slf4j</groupId>
 <artifactId>slf4j-log4j12</artifactId>
 <version>${slf4j.version}</version>
 </dependency>
 
 
 
 <dependency>
 <groupId>javax.servlet</groupId>
 <artifactId>javax.servlet-api</artifactId>
 <version>3.0.1</version>
 <scope>provided</scope>
 </dependency>
 
 
 <dependency>
 <groupId>javax.servlet</groupId>
 <artifactId>jstl</artifactId>
 <version>${jstl.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>commons-fileupload</groupId>
 <artifactId>commons-fileupload</artifactId>
 <version>${commons.fileupload.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.apache.httpcomponents</groupId>
 <artifactId>httpclient</artifactId>
 <version>${httpclient.version}</version>
 </dependency>
 
 <dependency>
 <groupId>commons-codec</groupId>
 <artifactId>commons-codec</artifactId>
 <version>${commons.codec.version}</version>
 </dependency>
 
 <dependency>
 <groupId>commons-net</groupId>
 <artifactId>commons-net</artifactId>
 <version>${commons.net.version}</version>
 </dependency>
 
 <dependency>
 <groupId>commons-logging</groupId>
 <artifactId>commons-logging</artifactId>
 <version>1.1.3</version>
 </dependency>
 <dependency>
 <groupId>commons-collections</groupId>
 <artifactId>commons-collections</artifactId>
 <version>3.2.1</version>
 </dependency>
 
 
 
 
 <dependency>
 <groupId>com.google.collections</groupId>
 <artifactId>google-collections</artifactId>
 <version>${google.collections.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>cglib</groupId>
 <artifactId>cglib-nodep</artifactId>
 <version>${cglib.version}</version>
 </dependency>
 
 
 
 <dependency>
 <groupId>org.apache.shiro</groupId>
 <artifactId>shiro-spring</artifactId>
 <version>${shiro.version}</version>
 </dependency>
 <dependency>
 <groupId>org.apache.shiro</groupId>
 <artifactId>shiro-ehcache</artifactId>
 <version>${shiro.version}</version>
 </dependency>
 <dependency>
 <groupId>org.apache.shiro</groupId>
 <artifactId>shiro-core</artifactId>
 <version>${shiro.version}</version>
 </dependency>
 <dependency>
 <groupId>org.apache.shiro</groupId>
 <artifactId>shiro-web</artifactId>
 <version>${shiro.version}</version>
 </dependency>
 <dependency>
 <groupId>org.apache.shiro</groupId>
 <artifactId>shiro-quartz</artifactId>
 <version>${shiro.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>org.aspectj</groupId>
 <artifactId>aspectjweaver</artifactId>
 <version>${aspectj.version}</version>
 </dependency>
 <dependency>
 <groupId>org.aspectj</groupId>
 <artifactId>aspectjrt</artifactId>
 <version>${aspectj.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>org.hibernate</groupId>
 <artifactId>hibernate-validator</artifactId>
 <version>${hibernate.validator.version}</version>
 </dependency>
 
 
 <dependency>
 <groupId>io.netty</groupId>
 <artifactId>netty-all</artifactId>
 <version>${netty.version}</version>
 </dependency>
 
 <dependency>
 <groupId>org.mybatis.generator</groupId>
 <artifactId>mybatis-generator-core</artifactId>
 <version>1.3.2</version>
 <type>jar</type>
 <scope>test</scope>
 </dependency>
 
 <dependency>
 <groupId>redis.clients</groupId>
 <artifactId>jedis</artifactId>
 <version>2.6.2</version>
 <type>jar</type>
 <scope>compile</scope>
 </dependency>

<dependency><groupId>org.bouncycastle</groupId><artifactId>bcprov-ext-jdk15on</artifactId><version>1.50</version></dependency><dependency><groupId>org.apache.directory.studio</groupId><artifactId>org.apache.commons.codec</artifactId><version>1.8</version></dependency><dependency><groupId>com.sun.mail</groupId><artifactId>javax.mail</artifactId><version>1.5.0</version></dependency><dependency><groupId>commons-dbcp</groupId><artifactId>commons-dbcp</artifactId><version>1.2.2</version></dependency>

</dependencies>

</pre> 之后再看lib里面是否都导入了jar包： 接着需要配置resource下面的四个配置文件，目录结构如下： jdbc.properties 、log4j.properties、  spring-mvc.xml 、 spring-mybatis.xml 这些文件可能都需要自己创建。需要自己创建一个数据库表testu，包括四个字段 id username password age  jdbc.properties 配置如下：<pre code_snippet_id="585011" snippet_file_name="blog_20150121_2_6939963" name="code" class="html" style="margin-top: 10px; margin-bottom: 10px; padding: 5px; white-space: pre-wrap; background-color: rgb(225, 255, 252); border-width: 1px 1px 1px 3px; border-style: solid; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) rgb(108, 226, 108); border-image: initial; font-size: 1em !important; line-height: 1.1em !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; color: black !important;">jdbc.driver=com.mysql.jdbc.Driver
 jdbc.url=jdbc:mysql://localhost:3306/testu?useUnicode=true&characterEncoding=UTF-8
 jdbc.username=root
 jdbc.password=root
 #\u5B9A\u4E49\u521D\u59CB\u8FDE\u63A5\u6570
 jdbc.initialSize=0
 #\u5B9A\u4E49\u6700\u5927\u8FDE\u63A5\u6570 
 jdbc.maxActive=20
 #\u5B9A\u4E49\u6700\u5927\u7A7A\u95F2 
 jdbc.maxIdle=20
 #\u5B9A\u4E49\u6700\u5C0F\u7A7A\u95F2
 jdbc.minIdle=1
 #\u5B9A\u4E49\u6700\u957F\u7B49\u5F85\u65F6\u95F4
 jdbc.maxWait=60000

log4j.properties配置如下：

#定义LOG输出级别
    log4j.rootLogger=INFO,Console,File
    #定义日志输出目的地为控制台
    log4j.appender.Console=org.apache.log4j.ConsoleAppender
    log4j.appender.Console.Target=System.out
    #可以灵活地指定日志输出格式，下面一行是指定具体的格式
    log4j.appender.Console.layout = org.apache.log4j.PatternLayout
    log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n
    
    #文件大小到达指定尺寸的时候产生一个新的文件
    log4j.appender.File = org.apache.log4j.RollingFileAppender
    #指定输出目录
    log4j.appender.File.File = logs/ssm.log
    #定义文件最大大小
    log4j.appender.File.MaxFileSize = 10MB
    # 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志
    log4j.appender.File.Threshold = ALL
    log4j.appender.File.layout = org.apache.log4j.PatternLayout
    log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

spring-mvc.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:p="http://www.springframework.org/schema/p"
 	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-3.1.xsd 
 http://www.springframework.org/schema/context 
 http://www.springframework.org/schema/context/spring-context-3.1.xsd 
 http://www.springframework.org/schema/mvc 
 http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 	
 	<context:component-scan base-package="com.cn.uuu.controller" />
 	
 	<bean id="mappingJacksonHttpMessageConverter"
 		class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
 		<property name="supportedMediaTypes">
 			<list>
 				<value>text/html;charset=UTF-8</value>
 			</list>
 		</property>
 	</bean>
 	
 	<bean
 		class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
 		<property name="messageConverters">
 			<list>
 				<ref bean="mappingJacksonHttpMessageConverter" />	
 			</list>
 		</property>
 	</bean>
 	
 	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
 		
 		<property name="prefix" value="/WEB-INF/jsp/" />
 		<property name="suffix" value=".jsp" />
 	</bean>
 	
 	
 	<bean id="multipartResolver" 
 class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> 
 
 <property name="defaultEncoding" value="utf-8" /> 
 
 <property name="maxUploadSize" value="10485760000" /> 
 
 <property name="maxInMemorySize" value="40960" /> 
 </bean> 
 
 </beans>

spring-mybatis.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:p="http://www.springframework.org/schema/p"
 	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-3.1.xsd 
 http://www.springframework.org/schema/context 
 http://www.springframework.org/schema/context/spring-context-3.1.xsd 
 http://www.springframework.org/schema/mvc 
 http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 	
 	<context:component-scan base-package="com.cn.uuu" />
 	
 	<bean id="propertyConfigurer"
 		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 		<property name="location" value="classpath:jdbc.properties" />
 	</bean>
 	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
 		destroy-method="close">
 		<property name="driverClassName" value="${jdbc.driver}" />
 		<property name="url" value="${jdbc.url}" />
 		<property name="username" value="${jdbc.username}" />
 		<property name="password" value="${jdbc.password}" />
 		
 		<property name="initialSize" value="${jdbc.initialSize}"></property>
 		
 		<property name="maxActive" value="${jdbc.maxActive}"></property>
 		
 		<property name="maxIdle" value="${jdbc.maxIdle}"></property>
 		
 		<property name="minIdle" value="${jdbc.minIdle}"></property>
 		
 		<property name="maxWait" value="${jdbc.maxWait}"></property>
 	</bean>
 
 	
 	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
 		<property name="dataSource" ref="dataSource" />
 		
 		<property name="mapperLocations" value="classpath:com/cn/uuu/mapping/*.xml"></property>
 	</bean>
 
 	
 	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
 		<property name="basePackage" value="com.cn.uuu.IDao" />
 		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
 	</bean>
 
 	
 	<bean id="transactionManager"
 		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
 		<property name="dataSource" ref="dataSource" />
 	</bean>
 
 </beans>

到这里配置文件基本配置完毕

接下来怎么创建一个简单的实例运行：

可以参考这篇文章 http://blog.csdn.net/cool\_easy/article/details/42778239   使用代码生成。生成

这三个包，还有几个文件需要自己创建。

代码结构如下

最后的代码详见：http://download.csdn.net/detail/naploen8/8381755

原文链接: [http://blog.csdn.net/cool\_easy/article/details/42963573][http_blog.csdn.net_cool_easy_article_details_42963573]

[A100756555-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100756555-124775.png_small.png
[A100758758-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100758758-124775.png_small.png
[A100800992-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100800992-124775.png_small.png
[A100803258-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100803258-124775.png_small.png
[A100805445-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100805445-124775.png_small.png
[A100807820-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100807820-124775.png_small.png
[A100810258-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100810258-124775.png_small.png
[A100812633-124775.png_small.png]: http://doc.okbase.net/picture/addon/2015/01/21/A100812633-124775.png_small.png
[http_blog.csdn.net_cool_easy_article_details_42963573]: http://blog.csdn.net/cool_easy/article/details/42963573