定義接口類:?

package com.atChina.dao;import com.atChina.bean.Employee;public interface EmployeeMapper {public Employee getEmployeeById(Integer depno);public void addEmploy(Employee employee);public Integer updateEmp(Employee employee);public Integer deleteEmpById(Integer id); }

sql映射文件,增刪改查的實(shí)現(xiàn)

<?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"> <!-- namespace不能隨便自定義了，應(yīng)該是接口類的全限定名 --> <mapper namespace="com.atChina.dao.EmployeeMapper"><!-- id:唯一標(biāo)識(shí) ,應(yīng)該是接口類中的抽象方法名resultType: 返回值類型#{deptno}:參數(shù) {}中的deptno是占位符,起任何名字都行 --><selectid="getEmployeeById" resultType="emp" >select * from DEPTTEST where deptno = #{deptno}</select><!-- parameterType可以省略不寫(xiě) --><insert id="addEmploy" parameterType="com.atChina.bean.Employee">insert into DEPTTEST(deptno, dname, loc) values(#{deptno}, #{dname}, #{loc})</insert><update id="updateEmp">update DEPTTEST a set dname=#{dname}, loc=#{loc}where deptno = #{deptno}</update><delete id="deleteEmpById">delete from DEPTTEST a where deptno = #{deptno}</delete> </mapper>

?測(cè)試:

/** 測(cè)試增刪改* 1. mybatis允許增刪改直接定義以下數(shù)據(jù)類型返回值* Integer, Long, Boolean,或者對(duì)一個(gè)的基本類型 */@Testpublic void test03() throws IOException{SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();// 不會(huì)自動(dòng)提交SqlSession openSession = sqlSessionFactory.openSession();try{Employee e = new Employee();e.setDeptno(50);e.setDname("hehe");e.setLoc("earth");EmployeeMapper em = openSession.getMapper(EmployeeMapper.class);//em.addEmploy(e); 增加一條數(shù)據(jù)//em.updateEmp(e); 更新數(shù)據(jù)Integer delete = em.deleteEmpById(50); // 刪除數(shù)據(jù)System.out.println(delete);// 提交數(shù)據(jù)openSession.commit();}finally{openSession.close();}}

?

總結(jié)

以上是生活随笔為你收集整理的mybaits四-1:增删改查的实现的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。