eclipse下springmvc+spring+maven+mybatis+mysql的搭建，并实现增删改查

Love The Way You Lie 2022-01-21 02:41 239阅读 0赞

eclipse下SpringMVC+Maven+Mybatis+MySQL项目搭建

这篇文章主要讲解在eclipse环境下SpringMVC+Maven+Mybatis+MySQL的项目搭建过程。

1.  创建Maven工程。

右击-->New->Other

![209997-20170527235949375-468860519.png][]

点击->Manven Porject

![209997-20170528000011032-1438813622.png][]

点击->勾选快速框架

![209997-20170528000029938-282340536.png][]

输入项目名，包（Packaging，如果只是普通的项目，选jar就好了，如果是web项目就选war，这里是web项目，所以选择war）

![209997-20170528000111782-1425574064.png][]

右击项目->Properties->Java Build Path->选择Libraries->点击选中 JRE System Library->Edit

![209997-20170528000127063-1219006223.png][]

选择默认JRE，注：必须系统安装了JDK。

![209997-20170528000421766-1915674640.png][]

点击Project Facets 去掉勾选 Dynamic Web Module 再把 Java 改为系统设置版本。

![209997-20170528000916032-1967630600.png][]

再打开Project Facets ->勾选 Dynamic Web Module 选择3.0版本时，下面有个 Further configuration available... ->点击

，![209997-20170528001144610-479104778.png][]

输入 content directory 地址： src/main/webapp，把web.xml勾选

![209997-20170528001500922-2094989619.png][]

创建好的工程目录如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5ndWl5dXl1_size_16_color_FFFFFF_t_70][]

下面把所有的.xml文件粘贴出来，以便使用：

实现增删改查的UserDao.xml, 代码如下：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="cn.cqu.dao.UserDao">
    
        <resultMap id="BaseResultMap" type="cn.cqu.model.User">
            <id column="USER_ID" property="userId" jdbcType="INTEGER" />
            <result column="USER_NAME" property="userName" jdbcType="CHAR" />
            <result column="USER_PASSWORD" property="userPassword" jdbcType="CHAR" />
        </resultMap>
        
        <select id="selectUserById" parameterType="Integer" resultMap="BaseResultMap">
            SELECT * FROM t_user WHERE USER_ID = #{userId}
        </select>
        
       <insert id="add" parameterType="cn.cqu.model.User">
            INSERT INTO t_user VALUE (#{userId},#{userName},#{userPassword})
       </insert> 
       
       
       <delete id="deleteById" parameterType="Integer">
            DELETE FROM t_user WHERE USER_ID=#{userId}
       </delete> 
       
       
       <update id="updateById" parameterType="Integer">
            UPDATE t_user SET USER_ID=#{userId}, USER_NAME=#{userName}, USER_PASSWORD=#{userPassword} WHERE USER_ID=#{userId}
       </update> 
       
        
    </mapper>

mybatis-config.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">  
    <configuration>    
    
        <settings>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="defaultStatementTimeout" value="3000"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            
            <setting name="useGeneratedKeys" value="true"/>
        </settings>
    
        
    
    </configuration>

jdbc.properties配置信息如下：

jdbc_driverClassName=com.mysql.jdbc.Driver
    jdbc_url=jdbc:mysql://localhost:3306/tgy?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC
    jdbc_username=root
    jdbc_password=tgy

spring.xml文件内容如下（spring.xml是配置数据源，dao层，controller层的）

<?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:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">
    
    
      
      <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list>
                   <value>classpath:properties/*.properties</value>
                    
                </list>
            </property>
      </bean>
      
      
      
       
      <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
          
          
         
          <property name="driverClassName">
              <value>${jdbc_driverClassName}</value>
          </property>
          <property name="url">
              <value>${jdbc_url}</value>
          </property>
          <property name="username">
              <value>${jdbc_username}</value>
          </property>
          <property name="password">
              <value>${jdbc_password}</value>
          </property>
      </bean>
      
      
      <context:component-scan base-package="cn.cqu"   />
      
      
      
      <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="cn.cqu.dao" />
      </bean>
      
      
      <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
           <property name="dataSource" ref="dataSource" />
           <property name="mapperLocations" value="classpath:mapper/*.xml"/> 
           <property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />
           
       </bean>
    </beans>

spring-mvc.xml的配置文件如下（是配置controller层和view层的）

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:p="http://www.springframework.org/schema/p" 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-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
    
       <mvc:annotation-driven  />
       
       
       <context:component-scan base-package="cn.cqu"   />
       
       
       
       <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            <property name="prefix" value="WEB-INF/view/" />
            <property name="suffix" value=".jsp" />
        </bean>
    
    </beans>

web.xml的配置信息如下（其主要是初始化时加载spring.xml和spring-mvc.xml中配置的内容）

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
    
    <display-name>tgy</display-name>
    
    	
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring.xml</param-value>
        </context-param>
        
         
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        
        
        <servlet>
            <servlet-name>springmvc</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:springmvc/spring-mvc.xml</param-value>
            </init-param>
        </servlet>
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
        
        <filter>
            <filter-name>CharacterEncodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        </filter>
        <filter-mapping>
            <filter-name>CharacterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
        
    
    
    	<welcome-file-list>
    	    <welcome-file>default.jsp</welcome-file>
    	</welcome-file-list>
    </web-app>

最后一个是maven的配置文件。

<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>
      <groupId>cn.cqu</groupId>
      <artifactId>tgy</artifactId>
      <version>0.0.1</version>
      <packaging>war</packaging>
      
      
      <parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.3.5.RELEASE</version>
    		<relativePath/> 
    	</parent>
    
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<java.version>1.8</java.version>
    		
            <spring.version>4.1.5.RELEASE</spring.version>
            
            <slf4j.version>1.6.6</slf4j.version>
            <log4j.version>1.2.12</log4j.version>
            
            <junit.version>4.10</junit.version>
            
            <mybatis.version>3.2.1</mybatis.version>
    	</properties>
    
    	<dependencies>
    	
    	    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</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-context</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-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-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-web</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>${junit.version}</version>
                <scope>test</scope>
            </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>commons-logging</groupId>
    	    <artifactId>commons-logging</artifactId>
    	    <version>1.2</version>
    		</dependency>
            
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${spring.version}</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.0</version>
            </dependency>
    	    
    		
    		
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>8.0.15</version>
    			<scope>runtime</scope>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>fastjson</artifactId>
    			<version>1.2.13</version>
    		</dependency>
    		<dependency>
    			<groupId>com.qiniu</groupId>
    			<artifactId>qiniu-java-sdk</artifactId>
    			<version>7.1.1</version>
    		</dependency>
    		<dependency>
    			<groupId>javax.mail</groupId>
    			<artifactId>mail</artifactId>
    			<version>1.4.7</version>
    		</dependency>
    		<dependency>
    			<groupId>redis.clients</groupId>
    			<artifactId>jedis</artifactId>
    			<version>2.8.0</version>
    		</dependency>
    
    		
    	</dependencies>
    	
    	<build>
        	<plugins>
    	    	<plugin>
    		        <artifactId>maven-compiler-plugin</artifactId>
    		        <version>3.7.0</version>
    		        <configuration>
    		          <source>1.8</source>
    		          <target>1.8</target>
    		        </configuration>
    	        </plugin>
            </plugins>
        </build>
    	
    </project>

至此整个项目完成。

[209997-20170527235949375-468860519.png]: /images/20220121/8a134d078ef84799a28e03913467993b.png
[209997-20170528000011032-1438813622.png]: /images/20220121/d235f1fecf2447c6951a69cfc00a110a.png
[209997-20170528000029938-282340536.png]: /images/20220121/a45ec1bd5de146dab13c085adfbcae90.png
[209997-20170528000111782-1425574064.png]: /images/20220121/19080e5ca95f4c1d89bead0a26ae5c61.png
[209997-20170528000127063-1219006223.png]: /images/20220121/68add743cece429c866964ef3f9a8dc1.png
[209997-20170528000421766-1915674640.png]: /images/20220121/703185f70e5f4035805c03e313418a54.png
[209997-20170528000916032-1967630600.png]: /images/20220121/b49d4eeacd4c41b5a5dcd518ca132ed7.png
[209997-20170528001144610-479104778.png]: /images/20220121/3a2fc7936ba04998a05a3f97ac112072.png
[209997-20170528001500922-2094989619.png]: /images/20220121/881ba684963c4d9ba42c0fcbb652316a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RpYW5ndWl5dXl1_size_16_color_FFFFFF_t_70]: /images/20220121/c04bc3c6b45641b796a03c8bd04313e9.png