构建Mybatis项目(二)

最新推荐文章于 2025-03-26 00:57:38 发布

原创最新推荐文章于 2025-03-26 00:57:38 发布 · 87 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#iBATIS #Apache #XML

Mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个使用MyBatis进行数据插入的具体实例，包括定义数据模型、创建映射器接口及测试类。

创建数据表映射类People,如下

package org.test.mybatis.model;

public class People {
private int id;
private String userName;
private String passWord;
private String realName;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassWord() {
return passWord;
}
public void setPassWord(String passWord) {
this.passWord = passWord;
}
public String getRealName() {
return realName;
}
public void setRealName(String realName) {
this.realName = realName;
}
}

创建数据表操作映射器,如下:

package org.test.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.test.mybatis.model.People;

public interface PeopleMapper {
@Insert("insert into people (userName,passWord,realName) values (#{userName},#{passWord},#{realName})")
void insertPeople(People people);
}

创建测试入口类,如下

package org.test.mybatis.root;

import java.io.IOException;
import java.io.Reader;

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.test.mybatis.mapper.PeopleMapper;
import org.test.mybatis.model.People;

public class Main {

public static void main(String[] args) throws IOException {
String resource = "mybatis.configuration.xml";
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()
.build(reader);
SqlSession session = sqlSessionFactory.openSession();
PeopleMapper pmp = session.getMapper(PeopleMapper.class);
People pp=new People();
pp.setPassWord("xiaoshagua");
pp.setRealName("xiaoshagua");
pp.setUserName("xiaoshagua");
pmp.insertPeople(pp);
session.commit();
}

}

当执行Main类时,数据库将多出一条数据