欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Mybatis简单的CRUD基于XML文件配置

程序员文章站 2022-05-10 13:38:19
...

所有的ORM框架学习曲线都是先来一个CRUD爽一爽,下面我们就来CRUD一下,所有的配置都是基于上一篇的配置。废话不多说,直接上代码。 ?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/m

所有的ORM框架学习曲线都是先来一个CRUD爽一爽,下面我们就来CRUD一下,所有的配置都是基于上一篇的配置。废话不多说,直接上代码。


		insert into users(name, age) values(#{name}, #{age});
	
		delete from users where id = #{id};
	
		update users set name = #{name}, age = #{age} where id = #{id};
	
package com.bird.mybatis.bean;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

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;

public class MyTest {
	
	private SqlSessionFactory factory;
	
	@Before
	public void init() {
		String resource = "conf.xml";
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {
			e.printStackTrace();
		}
		factory = new SqlSessionFactoryBuilder().build(reader);
	}
	
	@Test
	public void testAdd() {
		//默认是手动的 
		SqlSession session = factory.openSession();
		String statement = "com.bird.mybatis.bean.userMapper.insertUser";
		int rows = session.insert(statement, new Users(-1, "哈哈", 29));
		//提交
		session.commit();
		System.out.println(rows);
		session.close();
	}
	
	@Test
	public void testUpdate() {
		SqlSession session = factory.openSession();
		String statement = "com.bird.mybatis.bean.userMapper.updateUser";
		session.update(statement, new Users(4, "呵呵", 29));
		session.commit();
		session.close();
	}
	
	@Test
	public void testDelete() {
		SqlSession session = factory.openSession();
		String statement = "com.bird.mybatis.bean.userMapper.deleteUser";
		session.delete(statement, 1);
		session.commit();
		session.close();
	}
	
	@Test
	public void testGetAllUser() {
		SqlSession session = factory.openSession();
		String statement = "com.bird.mybatis.bean.userMapper.getAllUser";
		List list = session.selectList(statement);
		System.out.println(list.size());
		session.close();
	}
}
Ok,so easy, 哪里不会点哪里