快速搭建MyBatis 框架

mysql.driver=com.mysql.jdbc.Driver

mysql.url=jdbc:mysql://localhost:3306/test

mysql.username=root

mysql.password=123456

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

    <!-- 載入外在化檔案 -->

    <!--載入jdbc.properties 資料庫連線資訊配置檔案-->

<properties resource="jdbc.properties"></properties>

    <!-- 配置mybatis的環境模式，新增資料庫資訊，開啟事務  一般development開發模式-->

    <environments default="development">

        <environment id="development">

            <!-- 事務管理器 -->

            <transactionManager type="JDBC"/>

            <!-- 資料來源 -->

            <dataSource type="POOLED">

                <property name="driver" value="${mysql.driver}"/>

                <property name="url" value="${mysql.url}"/>

                <property name="username" value="${mysql.username}"/>

                <property name="password" value="${mysql.password}"/>

            </dataSource>

        </environment>

    </environments>

    <!-- 對映器：指定對映檔案或者對映類一個對映檔案就要多寫一個用來載入對應的對映檔案-->

    <mappers>

        <mapper resource="mapping/UserMapping.xml"/>

    </mappers>

</configuration>

   <properties>

        <property name="mysql.driver" value="com.mysql.jdbc.Driver"></property>

        <property name="mysql.url" value="jdbc:mysql://localhost:3306/test"></property>

        <property name="mysql.username" value="root"></property>

        <property name="mysql.password" value="123456"></property>

    </properties>

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

<!-- 設定根元素 -->

<!-- namespace:提供對映檔案的唯一標識，使MyBatis能夠找得到這個xml檔案 -->

<mapper namespace="mapping.UserMappings">

    <!-- 寫SQL 語句 -->

    <!-- 查詢語句 -->

    <select id="getAll" resultType="entity.User">

        select * from goods

    </select>

    <!-- 刪除語句 -->

    <delete id="delAll"></delete>

    <!-- 插入語句 -->

    <insert id="insertAll"></insert>

    <!-- 更新語句 -->

<update id="upAll"></update>

</mapper>

package entity;

publicclass User {

privateintid;

private String name;

privateintprice;

publicint getId() {

    returnid;

}

publicvoid setId(int id) {

    this.id = id;

}

public String getName() {

    return name;

}

publicvoid setName(String name) {

    this.name = name;

}

publicint getPrice() {

    returnprice;

}

publicvoid setPrice(int price) {

    this.price = price;

}

package test;

import java.io.IOException;

import java.io.Reader;

import java.util.List;

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 entity.User;

publicclass UserTest {

privatestatic Reader reader;//定義一個IO流

privatestatic SqlSessionFactory sFactory;//定義一個sql 的會話工廠

    static{

       try {

           //讀取Mybatis 配置檔案

           reader = Resources.getResourceAsReader("mybatis-cofig.xml");

           //例項化SQL會話工廠SqlSessionFactory

           sFactory = new SqlSessionFactoryBuilder().build(reader);

       } catch (IOException e) {

           e.printStackTrace();

       }

    }

    @Test

    publicvoid test01(){

       //開啟會話

       SqlSession session = sFactory.openSession();

//和物件對映檔案的名稱空間相同，加上要執行的語句的id

       String sql="UserMappings.getAll";

       List<User> list = session.selectList(sql);

       for(User :list){

           System.out.println(user.getName());

       }

    }

}