簡單使用mybatis(idea中使用)

標籤：cli   opened   依賴   ble   資源檔   input   載入   new   localhost   

首先建立一個maven項目

第一步：在pom.xml中添加依賴

<dependencies>        <!--mybatis-->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.4.6</version>        </dependency>        <!--資料庫相關 jar 包-->        <dependency>            <groupId>org.mariadb.jdbc</groupId>            <artifactId>mariadb-java-client</artifactId>            <version>2.3.0</version>        </dependency>        <!-- JUnit單元測試工具 -->    <dependency>        <groupId>junit</groupId>        <artifactId>junit</artifactId>        <version>4.10</version>    </dependency>    </dependencies>

第二步：建立資料庫表

CREATE TABLE BOOK(ID INT AUTO_INCREMENT PRIMARY KEY,NAME VARCHAR(20),NUMBER int );insert into BOOK(NAME,NUMBER) VALUES(‘Java程式設計‘,10),(‘資料結構‘,10),(‘設計模式‘,10)

第三步：在main目錄下的java原始碼寫代碼

實體類Book

package com.wbg.entity;public class Book {    int id;    String name;    int number;    @Override    public String toString() {        return "Book{" +                "id=" + id +                ", name=‘" + name + ‘\‘‘ +                ", number=" + number +                ‘}‘;    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public Book() {    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getNumber() {        return number;    }    public void setNumber(int number) {        this.number = number;    }    public Book(int id, String name, int number) {        this.id = id;        this.name = name;        this.number = number;    }}

View CodebookMapper介面

package com.wbg.dao;import com.wbg.entity.Book;public interface bookMapper {    Book selectBookById();}

BookDao

package com.wbg.dao;import com.wbg.entity.Book;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import java.io.InputStream;public class BookDao {    public Book getBookById(int id){        //使用類載入器載入mybatis的設定檔        InputStream inputStream=BookDao.class.getClassLoader().getResourceAsStream("config.xml");        //構建sqlSession的工廠        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);        //建立能執行對應檔中的sql        SqlSession sqlSession=sqlSessionFactory.openSession();        Book book=sqlSession.selectOne("com.wbg.dao.bookMapper.selectBookById",2);          return book;    }    public static void main(String[] args) {        BookDao bookDao=new BookDao();        System.out.println(bookDao.getBookById(1));    }}

View Code第四步：在resources中建立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"/>            <dataSource type="POOLED">                <property name="driver" value="org.mariadb.jdbc.Driver"/>                <property name="url" value="jdbc:mariadb://localhost:3306/stu"/>                <property name="username" value="root"/>                <property name="password" value="123456"/>            </dataSource>        </environment>    </environments>    <mappers>        <mapper resource="mapper/bookMapper.xml"/>    </mappers></configuration>

第五步：在resources中建立mapper目錄，在目錄下建立bookMapper.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.wbg.dao.bookMapper">    <select id="selectBookById" resultType="com.wbg.entity.Book">        select * from Book where id=#{id}    </select></mapper>

測試

 

 項目：https://github.com/weibanggang/mybatistest

 

簡單使用mybatis(idea中使用)