Mybatis简单配置详解 小白适合

Mybatis配置

目录结构：

UserMapper接口以 传入参数类型为实体和结果类型为Map为演示

public interface UserMapper {
	//通过id查询多个用户 
    List<Map> queryUserById(User user);
}

一个UserMapper接口对应一个UserMapper.xml

parameterType:参数类型，映射你pojo实体集如com.pojo.User
resultType:结果类型,java.util.Map
sql:查询对应select ， 参数必须对应你参数类型的字段如id
sql 里面就应该是 id=#{id}

<?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">
<!--映射配置信息namespace：命名空间-->
<mapper namespace="com.mapper.UserMapper">
 <select id="queryUserById" parameterType="com.pojo.User" resultType="java.util.Map">
        select * from users where id=#{id}
    </select>
    </mapper>

mybatis.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">
<!--mybatis核心配置-->
<configuration>

    <!--通过日志方式输出sql语句-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"></setting>
    </settings>

    <environments default="development">
        <environment id="development">
            <!--事务管理器：JDBC-->
            <transactionManager type="JDBC"/>
			
            <!--数据源提供的连接池：POOLED-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                 <!--记到修改数据库名-->
                <property name="url" value="jdbc:mysql://localhost:3306/xxx?characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

    <!--映射-->
    <mappers>
        <!--mapper-->
        <!--单个配置方式：缺点：每加入一个mapper.xml就必须添加-->
        <!--<mapper resource="com/gxa/mapper/UserMapper.xml"/>-->
        <!--包扫描方式：推荐使用，但一定注意接口类名称必须与Mapper.xml文件保持一致-->
       <package name="com.mapper" />
    </mappers>
</configuration>

测试类

public class Mybatis_Test_01 {
    @Test
    public  void test01() throws IOException {
        String resource = "mybatis.xml";
        /* 读取项目中的mybatis.xml文件 */
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //创建一个SqlSessionFactory的工厂类
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //创建SqlSession会话
        SqlSession sqlSession=sqlSessionFactory.openSession(true);//默认为手动提交false，自动提交为true
        //得到Mapper调用对象
        UserMapper userMapper= sqlSession.getMapper(UserMapper.class);
        sqlSession.commit();//手动提交
        User user=new User();
        user.setId(1);
        List<Map<String,Object>> map=userMapper.queryUserById(user);
        System.out.println(map);
    }
}

导入依赖

<dependencies>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/commons-dbutils/commons-dbutils -->
    <dependency>
      <groupId>commons-dbutils</groupId>
      <artifactId>commons-dbutils</artifactId>
      <version>1.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.1.41</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>4.1.0</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>4.1.0</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas -->
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml-schemas</artifactId>
      <version>4.1.0</version>
    </dependency>
    <!--杨拯新增-->
    <!-- https://mvnrepository.com/artifact/com.mchange/mchange-commons-java -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>mchange-commons-java</artifactId>bu
      <version>0.2.11</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.httpcomponents/httpclient -->
    <dependency>
      <groupId>org.apache.httpcomponents</groupId>
      <artifactId>httpclient</artifactId>
      <version>4.5.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.httpcomponents/httpcore -->
    <dependency>
      <groupId>org.apache.httpcomponents</groupId>
      <artifactId>httpcore</artifactId>
      <version>4.4.10</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
    <dependency>
      <groupId>org.apache.logging.log4j</groupId>
      <artifactId>log4j-core</artifactId>
      <version>2.12.1</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>2.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/javax.mail/mail -->
    <dependency>
      <groupId>javax.mail</groupId>
      <artifactId>mail</artifactId>
      <version>1.4.7</version>
    </dependency>
    <!--JSTL依赖-->
    <dependency>
      <groupId>org.apache.taglibs</groupId>
      <artifactId>taglibs-standard-spec</artifactId>
      <version>1.2.5</version>
    </dependency>
    <dependency>
      <groupId>org.apache.taglibs</groupId>
      <artifactId>taglibs-standard-impl</artifactId>
      <version>1.2.5</version>
    </dependency>
    <dependency>
      <groupId>com.alipay.sdk</groupId>
      <artifactId>alipay-sdk-java</artifactId>
      <version>3.7.4.ALL</version>
    </dependency>
  </dependencies>

##build里面添加如下代码防止找不到

<build>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>
    </build>