IntelliJ IDEA搭建maven mybatis環境

一,IntelliJ IDEA搭建maven mybatis環境

工具:

IntelliJ IDEA Ultimate 2019

tomcat 8.5.57

JDK 1.8.0_221

maven 3.6.3

MySQL資料庫

1.建立一個maven工程

2.輸入工程名和定義工程位置

3.選擇maven的本地位置

二、引入Tomcat

1.引入Tomcat之前打war包

2.點選Edit Configurations…

3.點選加号，

4.找到Tomcat Server

5.找到剛打完的war包，點選ok即可

6.運作Tomcat

三、開始搭建maven mybatis環境

1.導入依賴

<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>
           

2.在java包com.cyh.pojo建立一個User.java

package com.cyh.pojo;

public class User {
    private int uid;
    private String uname;
    private int uage;

    public int getUid() {
        return uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public int getUage() {
        return uage;
    }

    public void setUage(int uage) {
        this.uage = uage;
    }
}

           

3.建立相應的資料庫

-- 導出  表 mybatis.users 結構
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `uid` int(10) NOT NULL auto_increment,
  `uname` varchar(50) default '0',
  `uage` varchar(50) default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 正在導出表  mybatis.users 的資料: ~1 rows ((大約))
DELETE FROM `users`;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`uid`, `uname`, `uage`) VALUES
	(1, '李四', '12');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;
           

4.然後在resources檔案夾中建立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>
    <!-- 環境配置 -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <!-- 資料庫連接配接相關配置 ,這裡動态擷取config.properties檔案中的内容-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
                <property name="username" value="root" />
                <property name="password" value="x5" />
            </dataSource>
        </environment>
    </environments>
    <!-- mapping檔案路徑配置 -->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>

</configuration>
           

5.建立mapper檔案，并在其中建立UserMapper.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指定Dao接口的完整類名
mybatis會依據這個接口動态建立一個實作類去實作這個接口，
而這個實作類是一個Mapper對象
        -->
<mapper namespace="com.cyh.pojo.User">
    <select id="findById" parameterType="int" resultType="com.cyh.pojo.User"> select * from users where uid = #{id}
    </select>
</mapper>
           

6.寫單元測試類

import com.cyh.pojo.User;
 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 org.junit.Test;

       import java.io.IOException;
import java.io.Reader;

         public class UserTest {
     @Test
    public void userFindByIdTest(){
              //定義讀取檔案名
               String resources = "mybatis-config.xml";
               //建立流
                Reader reader=null;
              try {
                         //讀取mybatis-config.xml檔案到reader對象中
                        reader= Resources.getResourceAsReader(resources);
                     } catch (IOException e) {
                        e.printStackTrace();
                    }
                 //初始化mybatis,建立SqlSessionFactory類的執行個體
                 SqlSessionFactory sqlMapper=new SqlSessionFactoryBuilder().build(reader);
                 //建立session執行個體
                SqlSession session=sqlMapper.openSession();
                //傳入參數查詢，傳回結果
                 User user=session.selectOne("findById",1);
                 //輸出結果
                 System.out.println(user.getUname());
               //關閉session
                 session.close();

         }
 }

           

7.運作單元測試類，一個簡單的mybatis環境就搭建完成了。