所有的ORM框架学习曲线都是先来一个CRUD爽一爽,下面我们就来CRUD一下,所有的配置都是基于上一篇的配置。废话不多说,直接上代码。
<?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="com.bird.mybatis.bean.userMapper"> <!--CRUD --> <insert id="insertUser" parameterType="com.bird.mybatis.bean.Users"> insert into users(name, age) values(#{name}, #{age}); </insert> <delete id="deleteUser" parameterType="int"> delete from users where id = #{id}; </delete> <update id="updateUser" parameterType="com.bird.mybatis.bean.Users"> update users set name = #{name}, age = #{age} where id = #{id}; </update> <select id="getUser" parameterType="int" resultType="com.bird.mybatis.bean.Users"> select * from users where id = #{id}; </select> <select id="getAllUser" resultType="com.bird.mybatis.bean.Users"> select * from users; </select></mapper>
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<Users> list = session.selectList(statement); System.out.println(list.size()); session.close(); }}
Ok,so easy, 哪里不会点哪里
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow