mybatis 开发环境搭建

女爷i 2022-08-26 01:28 222阅读 0赞

不说废话直接上代码,首先看下我的目录机构：

![SouthEast][]

![Image 1][]

红色部分，表明你所需的jar包，已经配置文件.

创建用户表，以及插入数据.

create table books(id int (11) not null auto_increment,
                         image_url varchar(100) not null,
                         book_name varchar(50) not null,
                         author varchar(20) not null,
                         description varchar(255) not null,
                         primary key (id))ENGINE=InnoDB DEFAULT CHARSET=utf8;
                         
    insert into  books(image_url,book_name,author,description) values('resources/images/english.jpg','考研英语','孙悟空','内容系统而全面，英语学习的好帮手！内容系统而全面，英语学习的好帮手！内容系统而全面，英语学习的好帮手！内容系统而全面，英语学习的好帮手!');       
    insert into  books(image_url,book_name,author,description) values('resources/images/english.jpg','考研数学','刘诗诗','内容系统而全面，数学学习的好帮手，内容系统而全面，数学学习的好帮手内容系统而全面，数学学习的好帮手内容系统而全面，数学学习的好帮手');

创建Book.java

package com.mybatis.model;
    
    public class Book {
         private int id;
         private String imageUrl;
         private String name;
         private String author;
         private String description;
         
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public String getImageUrl() {
    		return imageUrl;
    	}
    	public void setImageUrl(String imageUrl) {
    		this.imageUrl = imageUrl;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getAuthor() {
    		return author;
    	}
    	public void setAuthor(String author) {
    		this.author = author;
    	}
    	public String getDescription() {
    		return description;
    	}
    	public void setDescription(String description) {
    		this.description = description;
    	}
         
    }

设置mybatis 配置文件:configuration.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>
      <typeAliases>
        
            <typeAlias type="com.mybatis.model.Book" alias="Book"/> 
      </typeAliases>
      
      
      <environments default="development">
         <environment id="development">
             <transactionManager type="JDBC"/>
             <dataSource type="POOLED">
                   <property name="driver" value="com.mysql.jdbc.Driver"/>
                   <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
                   <property name="username" value="root"/>
                   <property name="password" value="123456"/>
             </dataSource>
         </environment>
      </environments>
      
      <mappers>
         
           <mapper resource="com/mybatis/model/book.xml"/>
      </mappers>
      
    </configuration>

建立与Book.java对应的映射文件 book.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.mybatis.model.BookMapper">
      
         <select id="selectBookById"  parameterType="int" resultType="Book">
              select * from books where id=#{id}
         </select>
    </mapper>

最后就让我们编写一个测试类，运行我们的程序

package com.mybatis.test;
    
    import java.io.IOException;
    
    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 com.mybatis.model.Book;
    
    public class Test {
    
    	/***
    	 * 获得MyBatis SqlSessionFactory
    	 * SqlSessionFactory 负责创建SqlSession ,一旦创建成功，就可以用SqlSession实例来执行映射语句
    	 * ，commit,rollback,close等方法
    	 * @return
    	 */
    	
    	private static SqlSessionFactory getSessionFactory(){
    		SqlSessionFactory sessionFactory=null;
    		String resource="configuration.xml";
    		 try {
    			sessionFactory=new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader(resource));
    		} catch (IOException e) {
    			e.printStackTrace();
    		}
    		return sessionFactory;
    	}
    	public static void main(String[] args) {
              SqlSession session=getSessionFactory().openSession();
              Book book=session.selectOne("com.mybatis.model.BookMapper.selectBookById", 2);
              System.out.println(book.getAuthor());
    	}
    }

[SouthEast]: /images/20220824/6160924157f642188928a5a9e93b8426.png
[Image 1]: