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

所有的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一下，所有的配置都是基于上一篇的配置。废话不多说，直接上代码。

本文来源gao@!dai!ma.com搞$$代^@码5网@

<?xml version="1.0" encoding="UTF-8" ?>	<!---ecms 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};					select * from users where id = #{id};					select * from users;	 

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， 哪里不会点哪里

喜欢 (0)赏

[搞代码]

分享 (0)