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/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