Servlet+Mybatis整合

最新推荐文章于 2022-03-08 15:10:31 发布

原创最新推荐文章于 2022-03-08 15:10:31 发布 · 2k 阅读

CC 4.0 BY-SA版权

本文详细介绍如何将Servlet与Mybatis框架进行整合，包括创建Web工程、配置pom.xml、设置mybatis-config.xml、利用工具类操作数据库以及配置相关属性。通过具体步骤和代码示例，为读者提供了一个完整的Servlet+Mybatis项目搭建指南。

Servlet+Mybatis整合

1.步骤

1.创建Web工程
2.在pom.xml文件中引入依赖包
3.resources目录下引入资源包
4.编程mapper,service,model,controller即可
5.发布tomcat服务器中布署运行

2.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.sy</groupId>
  <artifactId>0415_mybatis_serlvet</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>0415_mybatis_serlvet Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <!--mybatis-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

    <!--log4j-->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>

    <!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.40</version>
    </dependency>

    <!--junit-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

    <!--servlet-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.0</version>
      <scope>provided</scope>
    </dependency>

    <!--JSON-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.58</version>
    </dependency>

    <!--JSTL-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>0415_mybatis_serlvet</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>


      <!--强制找包的资源文件-->
      <resources>
        <resource>
          <directory>src/main/java</directory>
          <includes>
            <include>**/*.xml</include>
          </includes>
        </resource>
        <resource>
          <directory>src/main/resources</directory>
          <includes>
            <include>**/*.xml</include>
            <include>**/*.properties</include>
          </includes>
        </resource>
      </resources>

    <plugins>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
        <configuration>
          <uriEncoding>utf-8</uriEncoding>
          <port>8080</port>
          <path>/</path>
        </configuration>
      </plugin>
    </plugins>

  </build>
</project>

3.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>
    <!--引入外部的db.properties文件-->
    <properties resource="db.properties"></properties>

    <!--设置mybatis的全局行为-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>

        <!--lazy加载-->
        <setting name="lazyLoadingEnabled" value="false"></setting>

        <!--开启二级缓存-->
        <setting name="cacheEnabled" value="false"></setting>
    </settings>


    <!--给model层的类起别名-->
    <typeAliases>
        <!--
        <typeAlias type="model.User" alias="User"></typeAlias>
        -->

        <!--给model包中所有类起别名,别名为该类的类名,不区分大小写-->
        <package name="model"></package>
    </typeAliases>

    <!--连接环境-->
    <environments default="development">
        <environment id="development">
            <!--事务:使用JDBC事务-->
            <transactionManager type="JDBC"></transactionManager>
            <!--数据源:生成connection对像,把connection对像放在连接池中-->
            <dataSource type="POOLED">
                <property name="driver" value="${db_driver}"></property>
                <property name="url" value="${db_url}"></property>
                <property name="username" value="${db_user}"></property>
                <property name="password" value="${db_password}"></property>
            </dataSource>
        </environment>
    </environments>

    <!--引入maaper映射文件:读取映射规则-->
    <mappers>
        <!--加载接口所在的包-->
       <package name="mapper"></package>
    </mappers>
</configuration>

4.引入工具类

package tools;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.InputStream;

public class MybatisUtil {

    private static SqlSessionFactory factory;

    static {
        try{
            InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            //2.创建SqlSessionFactoryBuilder对像
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            //3.创建SqlSessionFactory对像
            factory = builder.build(inputStream);
            //释放builder
            builder = null;
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    /**
     * 获取session对像
     * @return
     */
    public static SqlSession openSession(){
        return factory.openSession();
    }
}

5.配置文件

db.properties

db_driver=com.mysql.jdbc.Driver
db_url=jdbc:mysql:///invitationmanage
db_user=root
db_password=root

log4j.properties

# Global logging configuration
log4j.rootLogger=debug, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n