idea 创建 Maven + Mybatis 项目

╰半橙微兮° 2022-01-23 01:07 279阅读 0赞

最近在学习使用idea

这里说一下如何使用idea 创建一个Maven + Mybatis 项目

我也是借鉴了别人的博客，这里感谢一下这里的作者

[https://www.cnblogs.com/lijiasnong/p/8337381.html][https_www.cnblogs.com_lijiasnong_p_8337381.html]

一。首先新建一个Maven 项目

1.新建Maven项目这里不再多说了，接下来我们在 src/main 下新建java 和 resources 两个目录 并 mark directory sa 相应的项，这里不多说了，不会的可以去我的主页看看如何新建Maven 项目

2.接下来我们在 resources 目录下 新建 config.properties , log4j.properties, 和 mybatis-config.xml

项目结构如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70][]

3.哦，对了 还是在pom文件中引入对 mybatis的支持吧

<dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.2.8</version>
        </dependency>
    
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.21</version>
        </dependency>

先暂时引入这两个 其他的先不引用，

接下来我们给出 config.properties 的内容

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/test
    username=root
    password=22222222

这里是连接数据库的一些信息，当然这里的用户名和密码得写自己的

接下来是 log4j.properties

log4j.rootLogger=DEBUG, Console
    
    log4j.appender.Console=org.apache.log4j.ConsoleAppender
    log4j.appender.Console.layout=org.apache.log4j.PatternLayout
    log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
    log4j.logger.java.sql.ResultSet=INFO
    log4j.logger.org.apache=INFO
    log4j.logger.java.sql.Connection=DEBUG
    log4j.logger.java.sql.Statement=DEBUG
    log4j.logger.java.sql.PreparedStatement=DEBUG

接下来是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>
        <properties resource="config.properties"/>
        <typeAliases>
            <typeAlias type="model.Person" alias="Person"/> 
        </typeAliases>
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${driver}"/>
                    <property name="url" value="${url}"/>
                    <property name="username" value="${username}"/>
                    <property name="password" value="${password}"/>
                </dataSource>
            </environment>
        </environments>
        <mappers>
            <mapper resource="mapper/Person.xml"/>
        </mappers>
    </configuration>

接下来在resources 目录下 新建mapper 目录 在此目录下 新建Person.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">
        <insert id="insertPerson" parameterType="Person">
          insert into person(id, userName, age, mobilePhone) values (#{id}, #{userName}, #{age}, #{mobilePhone})
        </insert>
    </mapper>

我们在java下面创建 model 包 然后创建 Person.java

package model;
    
    public class Person {
    
        private int id;
        private String userName;
        private int age;
        private String mobilePhone;
    
        public Person(int id, String userName, int age, String mobilePhone) {
            this.id = id;
            this.userName = userName;
            this.age = age;
            this.mobilePhone = mobilePhone;
        }
    
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
    
        public String getUserName() {
            return userName;
        }
    
        public void setUserName(String userName) {
            this.userName = userName;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        public String getMobilePhone() {
            return mobilePhone;
        }
    
        public void setMobilePhone(String mobilePhone) {
            this.mobilePhone = mobilePhone;
        }
    }

当然此java实体中的属性对应 数据库中 person的表

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70 1][]

接下来我们在java目录下创建一个util 包 在此包下 我们创建一个 创建SqlSession的工具类 MybatisUtil.java

package utils;
    
    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.IOException;
    import java.io.Reader;
    
    public class MybatisUtil {
    
        private final  static SqlSessionFactory sqlSessionFactory;
    
        static {
            String resource="mybatis-config.xml";
            Reader reader =null;
            try {
                reader = Resources.getResourceAsReader(resource);
            } catch (IOException e) {
                e.printStackTrace();
            }
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        }
    
        /**
         * 获取SqlSessionFactory
         * @return SqlSessionFactory
         */
        public static SqlSessionFactory getSqlSessionFactory(){
            return sqlSessionFactory;
        }
    
        /**
         * 获取SqlSession
         * @return SqlSession
         */
        public static SqlSession getSqlSession(){
            return sqlSessionFactory.openSession();
        }
        /**
         * 关闭SqlSession
         */
        public  static void closeSession(SqlSession sqlSession){
            if (sqlSession!=null)
                sqlSession.close();
        }
    
    
    }

接下来我们就可以创建测试类了

package test;
    
    import model.Person;
    import org.apache.ibatis.session.SqlSession;
    import utils.MybatisUtil;
    
    public class Test01 {
    
        public static void main(String[] args) {
            SqlSession sqlSession = MybatisUtil.getSqlSession();
    
            int id = 2;
            String userName = "jinchen";
            int age = 18;
            String mobilePhone = "18766126517";
            Person person = new Person(id, userName, age, mobilePhone);
            try {
                sqlSession.insert("insertPerson", person);
                sqlSession.commit();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    
    }

执行main函数，我们就会在数据库person表中出插入一条记录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70 2][]

经验证确实插入，此种知识一个极为简单的mybatis的例子，想要学习更加深入的知识还是多查看资料

不积跬步，无以至千里

不积小流，无以成江海

[https_www.cnblogs.com_lijiasnong_p_8337381.html]: https://www.cnblogs.com/lijiasnong/p/8337381.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70]: /images/20220123/1170d0868c7e4fadac1d6c8af5200cbc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70 1]: /images/20220123/7dac34a31b5f44249e1b189bc8184c7d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdXlpbmcxODAyMDI4OTE1_size_16_color_FFFFFF_t_70 2]: /images/20220123/4cf69827fc2a48e8aceed34560c1878d.png