MyBatis基本操作

最新推荐文章于 2025-06-21 22:23:54 发布

原创最新推荐文章于 2025-06-21 22:23:54 发布 · 330 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #MySQL

Java框架专栏收录该内容

6 篇文章

订阅专栏

官网下载MyBatis jar包项目中直接导入即可，下载地址：MyBatis下载地址另外导入自己用的数据库的驱动包以及log4j的jar包。

目录截图如下：

数据库的格式：

数据库对应的实体类User.java

package org.fkit.domain;

public class User {
	private Integer id;
	private String name;
	private String sex;
	private Integer age;
	public User(){
		super();
	}
	public User(String name,String sex,Integer age){
		super();
		this.name=name;
		this.sex=sex;
		this.age=age;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {<?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="org.fkit.mapper.UserMapper">
  	<insert id="save" parameterType="org.fkit.domain.User" useGeneratedKeys="true">
  		insert into tb_user(name,sex,age) values (#{name},#{sex},#{age})
  	</insert>
  </mapper>

this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}}

映射文件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="org.fkit.mapper.UserMapper">
  	<insert id="save" parameterType="org.fkit.domain.User" useGeneratedKeys="true">
  		insert into tb_user(name,sex,age) values (#{name},#{sex},#{age})
  	</insert>
  </mapper>

MyBatis的配置文件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>
<settings>
	<setting name="logImpl" value="LOG4J"/>
</settings>
  <environments default="mysql">
    <environment id="mysql">
      <transactionManager type="JDBC"/>
      <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="cptbtptp89757"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>

    <mapper resource="org/fkit/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

测试类：

package org.fkit.test;

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.fkit.domain.User;

public class MyBatisTest {
	public static void main(String[] args) throws Exception{
		InputStream inputStream=Resources.getResourceAsStream("mybatis-config.xml");
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session=sqlSessionFactory.openSession();
		User user=new User("admin","男",26);
		session.insert("org.fkit.mapper.UserMapper.save",user);
		session.commit();
		session.close();
	}
}

log4j.properties用于控制台输出信息

# Global logging configuration  
log4j.rootLogger=ERROR, stdout  
# MyBatis logging configuration...  
log4j.logger.org.fkit.test=TRACE 
log4j.logger.org.fkit.mapper.UserMapper.save=TRACE 
# Console output...  
log4j.appender.stdout=org.apache.log4j.ConsoleAppender  
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout  
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

运行结果：

数据库结果：