SpringMVC + Spring + MyBatis集成

最新推荐文章于 2024-07-29 14:22:26 发布

萌萌1126_

最新推荐文章于 2024-07-29 14:22:26 发布

阅读量154

点赞数

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/qq_35888841/article/details/79389566

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.基本需要导入的jar包:

<dependencies>

<dependency>

    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>3.8.1</version>
    <scope>test</scope>
  </dependency>
  <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
  </dependency>
  <!-- SSM  -->
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.1.0</version>
  </dependency>
  <!-- Spring 在 3.2.13版本后，要单独引用 -->
  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.2.5.RELEASE</version>
  </dependency>

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

  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context-support</artifactId>
    <version>4.2.5.RELEASE</version>
  </dependency>
  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.2.5.RELEASE</version>
  </dependency>
  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.2.5.RELEASE</version>
  </dependency>
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.1.1</version>
  </dependency>
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.21</version>
  </dependency>

  <dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.7.1</version>
  </dependency>
  <dependency>
    <groupId>org.codehaus.jackson</groupId>
    <artifactId>jackson-mapper-asl</artifactId>
    <version>1.9.11</version>
  </dependency>
  <dependency>
    <groupId>commons-fileupload</groupId>
    <artifactId>commons-fileupload</artifactId>
    <version>1.2.2</version>
  </dependency>
  <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
  </dependency>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>1.7.16</version>
  </dependency>
  <!--db-->
  <dependency>
    <groupId>commons-beanutils</groupId>
    <artifactId>commons-beanutils-core</artifactId>
    <version>1.8.3</version>
  </dependency>
  <dependency>
    <groupId>commons-codec</groupId>
    <artifactId>commons-codec</artifactId>
    <version>1.10</version>
  </dependency>
  <dependency>
    <groupId>commons-collections</groupId>
    <artifactId>commons-collections</artifactId>
    <version>3.2.2</version>
  </dependency>
  <dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
  </dependency>
  <dependency>
    <groupId>commons-httpclient</groupId>
    <artifactId>commons-httpclient</artifactId>
    <version>3.1</version>
  </dependency>
  <dependency>
    <groupId>commons-io</groupId>
    <artifactId>commons-io</artifactId>
    <version>2.4</version>
  </dependency>
  <dependency>
    <groupId>commons-lang</groupId>
    <artifactId>commons-lang</artifactId>
    <version>2.6</version>
  </dependency>
  <dependency>
    <groupId>commons-logging</groupId>
    <artifactId>commons-logging</artifactId>
    <version>1.1.3</version>
  </dependency>
  <dependency>
    <groupId>commons-pool</groupId>
    <artifactId>commons-pool</artifactId>
    <version>1.6</version>
  </dependency>
  <dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>sqljdbc4</artifactId>
    <version>4.0</version>
  </dependency>

</dependencies>

2.创建配置文件

2.1:dataBase.properties文件配置连接数据的参数

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

    url=地址
    user=用户名
    password=密码

2.2:myBaits-config.xml放实体类的配置(当然不用也可以只不过需要在

mappers文件中

parameterType="把他写全",如果配置了就可以直接用他的实体类名字)

<?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 >
   <typeAliases>
      <package name="com.spring.pojo" />
   </typeAliases>
</configuration>

2.3:springmvc-servlet.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:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    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.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">
        
   <context:component-scan base-package="com.controller"/>
   
   <mvc:annotation-driven/>

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

    <!-- 防止拦截器拦截静态资源 -->
   <mvc:default-servlet-handler default-servlet-name="default"/>
   
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" >
      <property name="prefix" value="/WEB-INF/pages/"/>
      <property name="suffix" value=".jsp"/>
   </bean>
   
</beans>

2.4:ApplicationContext.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:tx="http://www.springframework.org/schema/tx"
   xmlns:context="http://www.springframework.org/schema/context"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd 
     http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.2.xsd">

   <!--<context:property-placeholder location="classpath:dataBase.properties" />-->

   <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
      <property name="locations">
         <list>
            <value>classpath:dataBase.properties</value>
         </list>
      </property>
      <property name="ignoreUnresolvablePlaceholders" value="true" />
   </bean>



   <bean id="basicDataSource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName" value="${driver}" />
      <property name="url" value="${url}" />
      <property name="username" value="${user}" />
      <property name="password" value="${password}" />
   </bean>




   <!-- 数据库访问层 -->
   <bean class="org.mybatis.spring.SqlSessionFactoryBean">
      <property name="dataSource" ref="basicDataSource" />
      <property name="configLocation" value="classpath:myBaits-config.xml" />
      <property name="mapperLocations">
         <list>
            <value>classpath:mappers/*.xml</value>
         </list>
      </property>
   </bean>

   <!--   <bean id="logService" class="com.spring.aop.LogService" />-->


   <!-- mapper 数据库访问层 采用【映射文件扫描器】自动进行持久层的配置 -->
   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
      <property name="basePackage" value="com.dao" />
   </bean>
   <!-- service 控制层 采用【映射文件扫描器】自动进行持久层的配置 -->
   <context:component-scan base-package="com.service" />
   <!-- aop自动开启 -->
   <aop:aspectj-autoproxy />

   <!-- 配置声明事务 -->
   <bean id="dataSourceTransactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="basicDataSource" />
   </bean>
   <!-- 事务开启扫描 -->
   <tx:annotation-driven transaction-manager="dataSourceTransactionManager" />
</beans>

2.5:注意要在web.xml引入

ApplicationContext.xml

springmvc-servlet.xml

<!DOCTYPE web-app PUBLIC
        "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app version="2.4"
         xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

    <display-name>Archetype Created Web Application</display-name>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:ApplicationContext.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-servlet.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <jsp-config>
        <jsp-property-group>
            <description>html encoding</description>
            <display-name>JSPConfiguration</display-name>
            <url-pattern>*.html</url-pattern>
            <el-ignored>true</el-ignored>
            <page-encoding>UTF-8</page-encoding>
            <scripting-invalid>false</scripting-invalid>
            <include-prelude></include-prelude>
            <include-coda></include-coda>
        </jsp-property-group>
    </jsp-config>

    <!-- 配置处理中文乱码的过滤器filter -->
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>utf-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--druid监控中心-->

    <session-config>
        <session-timeout>600</session-timeout>
    </session-config>

</web-app>

3.创建实体类(pojo)

4.创建数据访问层（dao）

@Repository
public interface WebsiteMapper {

    int insert(Website website);
}

5.创建业务逻辑层(service)

service:

public interface WebsiteService {

    int insert(Website website);
}

serviceImpl:

@Service("websiteService")
public class WebsiteServiceImpl implements WebsiteService {
    @Autowired
    private WebsiteMapper websiteMapper;

    public int insert(Website website) {
        return websiteMapper.insert(website);
    }
}

6.创建mapper文件注:(如果用的是ider开发工具mapper文件需放在resources文件下面否则就算配置了,也扫描不到)

<?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.dao.WebsiteMapper" >(dao文件里面定义的接口)

  <insert id="insert">(dao文件接口里面的方法名称 注:一定要一致)

      INSERT INTO [zForm6].[dbo].[website] ( [Name],[Phone], [Message], [GetDate], [EndDate]) VALUES (#{Name}, #{Phone}, #{Message}, GetDate(), NULL);
  </insert>
</mapper>

7.Controller

@ResponseBody
@RequestMapping(value = "/add", method = RequestMethod.POST, produces = "text/html;charset=UTF-8")
public String website(Website webs) {
    String result="";
    int count =web.insert(webs);
    if(count==1){
        result="成功";
    }

    return result;
}

注:

produces = "text/html;charset=UTF-8" 解决后台返回数据乱码问题

萌萌1126_

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SpringMVC + Spring + MyBatis集成

1.基本需要导入的jar包:&lt;dependencies&gt;&lt;dependency&gt; &lt;groupId&gt;junit&lt;/groupId&gt; &lt;artifactId&gt;junit&lt;/artifactId&gt; &lt;version&gt;3.8.1&lt;/version&gt; &lt
复制链接

扫一扫

专栏目录