Mybatis简单增、删、改、查语句和后台操作代码

一、操作语句

<?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="customer">

<!-- 查询语句 -->
 <select id="findInfoById" resultType="com.csz.mybatis.bean.Customer" parameterType="int">
         select * from customer where id=#{id}
 </select>
<!-- 添加语句 -->
<insert id="addInfo" parameterType="com.csz.mybatis.bean.Customer">
	insert into customer(age,name)
	values(#{age},#{name})
</insert>
<!-- 修改语句 -->
<update id="updateInfo" parameterType="com.csz.mybatis.bean.Customer">
   UPDATE  customer SET age=#{age} WHERE id=#{id}
</update>
<!-- 删除语句 -->
<delete id="deleteInfo" parameterType="com.csz.mybatis.bean.Customer" >
    DELETE FROM customer where id=#{id}
</delete>
</mapper>

二、后台代码

//删除的方法
	public void delete(Customer customer) throws IOException{	
		String resource = "mybatis.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session = sqlSessionFactory.openSession();	
		//删除语句
		session.delete("customer.deleteInfo", customer);
		session.commit();
		session.close();		
	}
	//修改的方法
	public void updata(Customer customer) throws IOException{
		
		String resource = "mybatis.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session = sqlSessionFactory.openSession();	
		//修改语句
		session.update("customer.updateInfo", customer);
		session.commit();
		session.close();		
	}
	//添加的方法
	public void add(Customer customer) throws IOException{
		
		String resource = "mybatis.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session = sqlSessionFactory.openSession();	
		//插入语句
		session.insert("customer.addInfo", customer);
		session.commit();
		session.close();		
	}

	//查询的方法
	public Customer findInfoById(int ID) throws IOException{

		String resource = "mybatis.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream) ;
		SqlSession session = sqlSessionFactory.openSession();
		//根据id查询单行语句，要想查询多条语句，用selectList()方法
		Customer customer = session.selectOne("customer.findInfoById", ID);		
		System.out.println(customer);
		session.close();		
		return customer;
	}