maven 配MyBatis

maven 配MyBatis

今天踩的坑，就是你明天能装的逼
进入正题，新手一个，基础不牢，地动山摇。就是瞎折腾

目录结构:

maven配置
添加依赖

<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.2</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.17</version>
    </dependency>

设置recources目录

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

数据库表情况

sqlMappingConfig.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>
    <typeAliases>
        <typeAlias alias="B" type="com.zeng.web.B"/>
    </typeAliases>
    <environments default="king">
        <environment id="king">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/king?characterEncoding=utf-8&amp;serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="MapperUser.xml"></mapper>
    </mappers>
</configuration>

MapperUser.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="com.zeng/web.MapperUser">

    <select id="findUser" parameterType="String" resultType="B">
        SELECT * FROM b where user=#{user}
    </select>

</mapper>

B.class

package com.zeng.web;

/**
 * @author 曾鑫磊
 * @Personalizwd signature
 * @Create 2019/9/20 16:29
 */
public class B {
    private String tel;
    private String user;
    private String password;
    private String identity;
    public B(){
        super();
    }
    public void setUser(String user){
        this.user=user;
    }
    public String getIdentity(){
        return identity;
    }

}

测试方法Test.java

public class Test{
	public static void main(String[] args){
	String resources="sqlMappingConfig.xml";
	InputStream inputStream=Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
	SqlSession sqlSession=sqlSessionFactory.openSession();
	B b=sqlSession.selectOne("findUser","未登陆");
	}
}

就是这样一个流程，仅供参考，顺便记录下，谢谢观看