Maven+SpringMVC+Spring+MyBatis连接MySQL数据库详细搭建整合过程

Bertha 。 2022-06-03 03:45 378阅读 0赞

**搭建步骤**

1.  创建Maven Web项目
2.  SpringMVC 配置及测试
3.  Spring+Mybatis配置及连接数据库测试

**一、创建Maven Web项目**  
依照个人习惯自行创建。先新建一个Maven工程，再添加web支持  
可参考博客：[http://www.cnblogs.com/wql025/p/5205716.html][http_www.cnblogs.com_wql025_p_5205716.html]  
工程目录如图：  
![这里写图片描述][SouthEast]  
完整的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>
    
        <groupId>com.zhou.ssm</groupId>
        <artifactId>ssmTest</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <spring.version>4.3.1.RELEASE</spring.version>
            
            <mybatis.version>3.4.5</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-context</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-test</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>4.10</version>
                
            </dependency>
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.5</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.2.5.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.35</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>1.3.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>net.sf.json-lib</groupId>
                <artifactId>json-lib</artifactId>
                <version>2.4</version>
                <classifier>jdk15</classifier>
            </dependency>
    
            
            <dependency>
                <groupId>commons-httpclient</groupId>
                <artifactId>commons-httpclient</artifactId>
                <version>3.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>javax.validation</groupId>
                <artifactId>validation-api</artifactId>
                <version>1.1.0.Final</version>
            </dependency>
    
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.3.1</version>
            </dependency>
            <dependency>
                <groupId>commons-io</groupId>
                <artifactId>commons-io</artifactId>
                <version>2.4</version>
            </dependency>
            <dependency>
                <groupId>commons-codec</groupId>
                <artifactId>commons-codec</artifactId>
                <version>1.9</version>
            </dependency>
    
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
        </dependencies>
    
    </project>

**二、配置SpringMVC及测试**

1.  pom添加SpringMVC依赖

<dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.10</version>
                
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.2.5.RELEASE</version>
            </dependency>

1.  resources文件夹下，添加配置文件springmvc.xml

1.  web.xml<–配置springmvc DispatcherServlet–>

<?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>springMVC</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring-mvc.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
            <async-supported>true</async-supported>
        </servlet>
        <servlet-mapping>
            <servlet-name>springMVC</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
    </web-app>

1.  测试  
    view文件夹下，新建index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>Title</title>
    </head>
    <body>
    Controller -->  index
    </body>
    </html>

java包下，新建com.zhou.ssm包，目录下新建controller包  
新建HelloController.java

@Controller
    public class IndexController {
        @RequestMapping(value="/", method= RequestMethod.GET)
        public String index(){
            return "index";
        }
    }

配置tomcat运行测试。  
SpringMVC配置简单可参考:  
[http://www.cnblogs.com/yanyd/p/4266179.html][http_www.cnblogs.com_yanyd_p_4266179.html]  
[http://www.cnblogs.com/winner-0715/p/5294917.html][http_www.cnblogs.com_winner-0715_p_5294917.html]  
超详细可参考：[http://blog.csdn.net/qq\_27093465/article/details/68961393][http_blog.csdn.net_qq_27093465_article_details_68961393]

**三、Spring+Mybatis配置及连接数据库测试**

1.  pom.xml添加依赖：见最开始完整pom
2.  添加配置文件jdbc.properties（数据库名test）,spring-mybatis.xml  
    jdbc.properties,修改web.xml

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
    jdbc.username=root
    jdbc.password=123456

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:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
           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-4.3.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
    
        
        <context:property-placeholder location="classpath:jdbc.properties" />
    
        
        <bean id="jdbcDataSource"
              class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="${jdbc.driverClassName}" />
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
        </bean>
    
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="jdbcDataSource" />
            
            <property name="typeAliasesPackage" value="com.zhou.ssm"></property>
            
            <property name="mapperLocations" value="classpath:/mapper/*.xml"></property>
        </bean>
    
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
            
            <property name="basePackage" value="com.zhou.ssm"></property>
        </bean>
    
        
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory" />
        </bean>
    
    
        
        <context:component-scan base-package="com.zhou.ssm">
            <context:exclude-filter type="aspectj" expression="com.ipu.pushMessage.mapper.*"/>
        </context:component-scan>
        <aop:aspectj-autoproxy proxy-target-class="true"></aop:aspectj-autoproxy>
    </beans>

在web.xml中添加：

<listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mybatis.xml</param-value>
        </context-param>

3.代码连接数据库，单元测试连接  
![这里写图片描述][SouthEast 1]

bean包，新建Media.java类， mysql建表

public class Media {
        public String media_id;
        public String type;
        public String created_time;
        public String status;
    
        public String getMedia_id() {
            return media_id;
        }
    
        public void setMedia_id(String media_id) {
            this.media_id = media_id;
        }
    
        public String getType() {
            return type;
        }
    
        public void setType(String type) {
            this.type = type;
        }
    
        public String getCreated_time() {
            return created_time;
        }
    
        public void setCreated_time(String created_time) {
            this.created_time = created_time;
        }
    
        public String getStatus() {
            return status;
        }
    
        public void setStatus(String status) {
            this.status = status;
        }
    }

mapper包下新建MediaMapper接口

@Repository
    public interface MediaMapper {
        public int saveMedia(Media media);
        public List<Media> queryAll();
    }

service包下，新建MediaService接口

public interface MediaService {
        public int saveMedia(Media media);
        public List<Media> queryAll();
    }

impl包下，新建MediaServiceImpl类实现MediaService接口

@Service
    public class MediaServiceImpl implements MediaService{
        
        @Autowired
        private MediaMapper mediamapper;
    
        @Override
        public int saveMedia(Media media){
            return mediamapper.saveMedia(media);
        }
        @Overside
        public List<Media> queryAll(){
            return mediamapper.queryAll();
        }
    }

配置文件resources包下的mapper包，新建MediaMapper.xml  
增删改查详解参考：[http://www.mybatis.org/mybatis-3/zh/sqlmap-xml.html\#insert\_update\_and\_delete][http_www.mybatis.org_mybatis-3_zh_sqlmap-xml.html_insert_update_and_delete]

<?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.ipu.pushMessage.mapper.MediaMapper">
        
        <insert id="saveMedia" parameterType="Media">
            insert into psg_wechat_media(TYPE, MEDIA_ID, CREATED_TIME, STATUS) VALUES(#{type}, #{media_id}, #{created_time}, #{status})
        </insert>
        <select id="queryAll" resultType="Media">
              select * from psg_wechat_media
        </select>
    </mapper>

添加测试类：

public class TestSpringMyBatis {
        @Test
        public void saveMedia() {
            System.out.println("start-------------------------");
            //初始化容器
            ApplicationContext ctx=new ClassPathXmlApplicationContext("spring-mybatis.xml");
            //获得bean
            MediaMapper mediaMapper = ctx.getBean(MediaMapper.class);
            //访问数据库
            Media media = new Media();
            media.setCreated_time("2017-01-01 10:23:23");
            media.setMedia_id("80222");
            media.setStatus("0");
            media.setType("thume");
            mediaMapper.saveMedia(media);
            System.out.println("end----------------------------");
        }
    }

public class QueryAllMedia {
        @Test
        public void queryallmedia(){
            System.out.println("start-------------------------");
            //初始化容器
            ApplicationContext ctx=new ClassPathXmlApplicationContext("spring-mybatis.xml");
            //获得bean
            MediaMapper mediaMapper = ctx.getBean(MediaMapper.class);
    
            List<Media> medialist = mediaMapper.queryAll();
            for(Media i: medialist){
                System.out.println("media: "+i.getMedia_id());
                System.out.println("type: "+i.getType());
                System.out.println("created_time: "+i.getCreated_time());
                System.out.println("status: "+i.getStatus());
                System.out.println();
            }
            System.out.println(medialist);
        }
    }

右键运行测试类。  
参考博客：[https://www.cnblogs.com/lmei/p/7190755.html?utm\_source=itdadao&utm\_medium=referral][https_www.cnblogs.com_lmei_p_7190755.html_utm_source_itdadao_utm_medium_referral]

[http_www.cnblogs.com_wql025_p_5205716.html]: http://www.cnblogs.com/wql025/p/5205716.html
[SouthEast]: /images/20220603/0d47bac840af4dfcae46d6910ff1fd01.png
[http_www.cnblogs.com_yanyd_p_4266179.html]: http://www.cnblogs.com/yanyd/p/4266179.html
[http_www.cnblogs.com_winner-0715_p_5294917.html]: http://www.cnblogs.com/winner-0715/p/5294917.html
[http_blog.csdn.net_qq_27093465_article_details_68961393]: http://blog.csdn.net/qq_27093465/article/details/68961393
[SouthEast 1]: /images/20220603/92693891eb114208aba5ab21b1318782.png
[http_www.mybatis.org_mybatis-3_zh_sqlmap-xml.html_insert_update_and_delete]: http://www.mybatis.org/mybatis-3/zh/sqlmap-xml.html#insert_update_and_delete
[https_www.cnblogs.com_lmei_p_7190755.html_utm_source_itdadao_utm_medium_referral]: https://www.cnblogs.com/lmei/p/7190755.html?utm_source=itdadao&utm_medium=referral