Maven项目-MyBatis入门配置

最新推荐文章于 2025-05-13 20:24:28 发布

原创最新推荐文章于 2025-05-13 20:24:28 发布 · 723 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍如何使用MyBatis框架进行数据库操作，包括Maven项目搭建、实体类定义、Mapper接口及XML映射文件的创建，以及配置文件的设置。通过具体示例，展示如何实现学生信息的查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、首先构建maven项目

pom.xml 配置

<dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
</dependency>

<dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
     </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

建表（最简单的建表）

create table student(

id number,

name varchar2(20),

age number

);

整体结构

二、项目构建

Student.java

package com.mybatis.bean;

public class Student {
    private Integer id;
    private String name;
    private Integer age;

    public Student() {
        super();
    }
    public Student(Integer id, String name, Integer age) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
    }
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Integer getAge() {
        return age;
    }
    public void setAge(Integer age) {
        this.age = age;
    }
    @Override
    public String toString() {
        return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";
    }

}

StudentMapper.java

package com.mybatis.dao;

import com.mybatis.bean.Student;

public interface StudentMapper {
public Student selectStudent(Integer id);
}

StudentMapper.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.dao.StudentMapper">
  <select id="selectStudent" resultType="Student" parameterType="int">
    select * from student where id = #{id}
  </select>
</mapper>

config.properties

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
username=scott
password=tiger

resources

log4j.properties

#log4j.rootLogger=DEBUG,A1,R
log4j.rootLogger=info,A1,R
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=bbscs7log.txt
log4j.appender.R.MaxFileSize=500KB
log4j.appender.R.MaxBackupIndex=10
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} [%t] [%c] [%p] - %m%n

mybatis.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="com/mybatis/dao/config.properties"/>
    <typeAliases>
        <package name="com.mybatis.bean" />
    </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="com/mybatis/dao/StudentMapper.xml" />
    </mappers>
</configuration>

三、测试类

TestMybatis.java

package com.mybatis.test;

import java.io.IOException;
import java.io.InputStream;

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.Before;
import org.junit.Test;

import com.mybatis.bean.Student;
import com.mybatis.dao.StudentMapper;

public class TestMybatis {

    private SqlSessionFactory sqlSessionFactory = null;

    @Before
    public void init() throws IOException{
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

        //2.加载sqlMapConfig.xml文件
        InputStream is = Resources.getResourceAsStream("mybatis.xml");
        //3.创建一个factory工厂
        sqlSessionFactory = builder.build(is);

    }

    @Test
    public void testSelect(){
        SqlSession session = sqlSessionFactory.openSession();
        StudentMapper mapper = session.getMapper(StudentMapper.class);
        Student selectStudent = mapper.selectStudent(1);
        System.out.println(selectStudent);

    }

}