IDEA创建MyBatis项目--实现简单的查操作

旧城等待， 2022-05-08 06:22 152阅读 0赞

本篇文章只是为了快速创建一个Mybatis实现查的项目，并没有对知识点进行讲。我个人认为学习框架先是动手实现一下，先不用管为什么要这么做，等运行成功后再去琢磨比较容易懂和记得牢。

![70][]

![70 1][]

> ### 通过maven加载Mybatis依赖包 ###

![70 2][]

<dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.3.0</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.29</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.12</version>
            </dependency>
        </dependencies>

> ### 新建config.properties配置文件 ###

![70 3][]

![70 4][]

> ### 新建Mybatis配置文件 ###

<?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>
        <properties resource="config.properties"/>
        <typeAliases>
    
            <package name=""/>
        </typeAliases>
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${database.driver}"/>
                    <property name="url" value="${database.url}"/>
                    <property name="username" value="${database.username}"/>
                    <property name="password" value="${database.password}"/>
                </dataSource>
            </environment>
        </environments>
        <mappers>
            <mapper resource="mapper/StudentMapper.xml"/>
        </mappers>
    
    </configuration>

![70 5][]

> ### 编写SqlSessionFactoryUtils工具类 ###

package com.Utils;
    
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import org.apache.ibatis.io.Resources;
    
    import java.io.IOException;
    import java.io.InputStream;
    
    public class SqlSessionFactoryUtils {
    
        private final static Class<SqlSessionFactoryUtils> lock=SqlSessionFactoryUtils.class;
    
        private static SqlSessionFactory sqlSessionFactory=null;
    
        private SqlSessionFactoryUtils(){};
    
        public static SqlSessionFactory getSqlSessionFactory(){
            synchronized (lock){
                if (sqlSessionFactory!=null){
                    return sqlSessionFactory;
                }
    
                String resource="mybatis-config.xml";
                InputStream inputStream;
                try {
                    inputStream=Resources.getResourceAsStream(resource);
                    sqlSessionFactory =new SqlSessionFactoryBuilder().build(inputStream);
                }catch (IOException e){
                    e.printStackTrace();
                    return null;
                }
    
                return sqlSessionFactory;
            }
        }
    
        public static SqlSession openSqlSession(){
            if (sqlSessionFactory==null){
                getSqlSessionFactory();
            }
            return  sqlSessionFactory.openSession();
        }
    
    
    }

### ![70 6][] ###

> ### 编写Student实体类 ###

package com.entity;
    
    public class Student {
    
        private int id;
        private String name;
        private int age;
    
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "Student{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    }

### ![70 7][] ###

> ### 编写StudentMapper接口 ###

package com.mapper;
    
    import com.entity.Student;
    
    public interface StudentMapper {
        public Student getStudent(long id);
    }

### ![70 8][] ###

> ### 编写StudentMapper.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.mapper.StudentMapper">
    
        <select id="getStudent" parameterType="long" resultType="com.entity.Student">
            select id,name,age from student where id=#{id}
        </select>
    
    </mapper>

![70 9][]

> ### 数据库表结构 ###

![70 10][]

> ### 编写Main类 ###

package com;
    
    import com.entity.Student;
    import com.mapper.StudentMapper;
    import com.utils.SqlSessionFactoryUtils;
    import org.apache.ibatis.session.SqlSession;
    
    public class Main {
    
        public static void main(String[] args){
            SqlSession sqlSession=SqlSessionFactoryUtils.openSqlSession();
            StudentMapper studentMapper=sqlSession.getMapper(StudentMapper.class);
            System.out.println(studentMapper.getStudent(1).toString());
        }
    }

### ![70 11][] ###

![70 12][]

> ### 注意的点 ###

1.  Mapper.xml的namespace与Mapper.java类的包名要一致
2.  Mapper.xml中select元素的id属性值必须跟Mapper.java中方法名要一致

> ### 报错 ###

出现这个错误，可以看一下报错的内容：Could not find resource com/xml/StudentMapper.xml。一个很不好的习惯，把xml放在了java/com/xml包下，java包目录下就应该放java代码，放xml实在不应该。把xml文件放在resources目录下，便解决这个问题。<mapper resource="mapper/StudentMapper.xml"/>实际就是查找resources/mapper目录的文件。

![70 13][]

"C:\Program Files\Java\jdk1.8.0_131\bin\java.exe" "-javaagent:E:\IntelliJ IDEA 2018.1.6\lib\idea_rt.jar=59220:E:\IntelliJ IDEA 2018.1.6\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Users\林颖\Desktop\conmybatis\target\classes;C:\Users\林颖\.m2\repository\org\mybatis\mybatis\3.3.0\mybatis-3.3.0.jar;C:\Users\林颖\.m2\repository\mysql\mysql-connector-java\5.1.29\mysql-connector-java-5.1.29.jar;C:\Users\林颖\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\林颖\.m2\repository\org\slf4j\slf4j-api\1.7.12\slf4j-api-1.7.12.jar;C:\Users\林颖\.m2\repository\org\slf4j\slf4j-log4j12\1.7.12\slf4j-log4j12-1.7.12.jar" com.mian
    log4j:WARN No appenders could be found for logger (org.apache.ibatis.logging.LogFactory).
    log4j:WARN Please initialize the log4j system properly.
    log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
    Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
    ### Error building SqlSession.
    ### The error may exist in com/xml/StudentMapper.xml
    ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/xml/StudentMapper.xml
    	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:82)
    	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:66)
    	at com.Utils.SqlSessionFactoryUtils.getSqlSessionFactory(SqlSessionFactoryUtils.java:29)
    	at com.Utils.SqlSessionFactoryUtils.openSqlSession(SqlSessionFactoryUtils.java:41)
    	at com.mian.main(mian.java:11)
    Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/xml/StudentMapper.xml
    	at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:115)
    	at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:95)
    	at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
    	... 4 more
    Caused by: java.io.IOException: Could not find resource com/xml/StudentMapper.xml
    	at org.apache.ibatis.io.Resources.getResourceAsStream(Resources.java:114)
    	at org.apache.ibatis.io.Resources.getResourceAsStream(Resources.java:100)
    	at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:338)
    	at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:113)
    	... 6 more
    
    进程完成，退出码 1

**修改之前：**

![70 14][]

--------------------

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: 
    ### Error querying database.  Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: ${database.driver}

遇到这种问题肯定是config.properties跟 value="$\{database.xx\}"两个文件其中一个写错了。

[70]: /images/20220508/f989b4c58a2841e5bf0a9d6e0ef3cf88.png
[70 1]: /images/20220508/68f0f11d2983495487c064f5f5d9bd9b.png
[70 2]: /images/20220508/f16e8112738d4e0b8441bac3124c4c1c.png
[70 3]: /images/20220508/ba028d8a2f79467f84fe5027fb742ec8.png
[70 4]: /images/20220508/15b50d97c39a494d82445e416a9f56a0.png
[70 5]: /images/20220508/8ab54e8d5bf54f00a64f3d4553012ca0.png
[70 6]: /images/20220508/dac1e0325fd24947981c9532276d8444.png
[70 7]: /images/20220508/91bcd99d878948ef96c060d38a12c966.png
[70 8]: /images/20220508/8a03b66ae0d84b53a5f10712082029b3.png
[70 9]: /images/20220508/cdb19de1610b4c3b8761ff9833e25846.png
[70 10]: /images/20220508/983aab1de674423387d9d367acbd36cc.png
[70 11]: /images/20220508/d5662e5e75f14768b00842b3f02be7e4.png
[70 12]: /images/20220508/e1244b38377f4c299678fc28a2f3d1d8.png
[70 13]: /images/20220508/c8fa2d2bf90b48fb9de9b49f45b8c496.png
[70 14]: /images/20220508/d961745b2a264c7e80f3cac586dc7335.png