1. 主页 > 程序 > Mysql >

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

      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, 哪里不会点哪里 内容推荐:免费高清PNG素材下载

本文由某某资讯网发布,不代表某某资讯网立场,转载联系作者并注明出处:http://www.xueouxue.com/program/Mysql/229736.html

联系我们

在线咨询:点击这里给我发消息

微信号:

工作日:9:30-18:30,节假日休息