idea 创建 Maven + Mybatis 项目-蒲公英云

最近在学习使用idea

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

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

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"/> <!--注意此对象一定要从包的根部写起 model.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();
        }
    }
}