尚硅谷-MyBatis的CRUD操作 - 数据库编程

项目结构：

User实体类代码：

package com.atguigu.mybatis.bean;

public class User {
	private int id;
	private String name;
	private int age;

	public User() {
		super();
	}

	public User(int id, String name, int age) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}

}

userMapper.xml映射文件代码：




	
	
		insert into users(name,age) values(#{name},#{age})
	
	
	
		delete from users where id=#{id}
	
	
	
		update users set name=#{name},age=#{age} where id=#{id}

UserMapper注解类代码（要么用xml方式，要么用注解方式）：

package com.atguigu.mybatis.test2;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.atguigu.mybatis.bean.User;

public interface UserMapper {

	@Insert("insert into users(name,age) values(#{name},#{age})")
	public int add(User user);
	
	@Delete("delete from users where id=#{id}")
	public int deleteById(int id);
	
	@Update("update users set name=#{name},age=#{age} where id=#{id}")
	public int update(User user);
	
	@Select("select * from users where id=#{id}")
	public User getById(int id);
	
	@Select("select * from users")
	public List getAll();
}

获取SqlSessionFactory工厂的MybatisUtils代码：

package com.atguigu.mybatis.utils;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MybatisUtils {

	public static SqlSessionFactory getFactory() {
		String resource = "conf.xml";
		InputStream inputStream = MybatisUtils.class.getClassLoader().getResourceAsStream(resource);

		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

		return factory;
	}
}

配置文件conf.xml代码：

测试类Test2代码：

package com.atguigu.mybatis.test2;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;

import com.atguigu.mybatis.bean.User;
import com.atguigu.mybatis.utils.MybatisUtils;

/*
 * 测试: CRUD操作的XML的实现和注解实现
 */
public class Test2 {
	//--------------------------------测试XML的实现
	@Test
	public void testAdd(){
		SqlSessionFactory factory=MybatisUtils.getFactory();
		//默认是手动提交的
		SqlSession session=factory.openSession();
		
		String statement="com.atguigu.mybatis.bean.userMapper.addUser";
		int insert=session.insert(statement, new User(-1, "KK", 23));
		//提交事务
		session.commit();
		
		session.close();
		System.out.println(insert);
	}
	
	@Test
	public void testUpdate(){
		SqlSessionFactory factory=MybatisUtils.getFactory();
		//默认是手动提交
		SqlSession ses

尚硅谷-MyBatis的CRUD操作(一)