MyBatis的前身就是iBatis。是一個數據持久層(ORM)框架。 MyBatis是支持普通SQL查詢，存儲過程和高級映射的優秀持久層框架。 MyBatis消除了幾乎所有的JDBC 代碼和參數的手工設置以及結果集的檢索。 MyBatis使用簡單的XML或註解用於配置和原始映射，將接口和Java 的POJOs（Plan Old Java Objects，普通的Java 對象）映射成數據庫中的記錄。每個MyBatis應用程序主要都是使用SqlSessionFactory實例的，一個SqlSessionFactory實例可以通過SqlSessionFactoryBuilder獲得。
具體代碼如下所示：
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <typeAliases> <!-- give a alias for model --> <typeAlias alias="goods" type="com.clark.model.Goods"></typeAlias> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@172.30.0.125:1521:oradb01" /> <property name="username" value="settlement" /> <property name="password" value="settlement" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/clark/model/goodsMapper.xml" /> </mappers> </configuration><?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="clark"> <!-- 將db查詢出來的結果映射到Model--Goods --> <resultMap type="com.clark.model.Goods" id="t_good"> <id column="id" property="id"/> <result column="cate_id" property="cateId"/> <result column="name" property="name"/> <result column="price" property="price"/> <result column="description" property="description"/> <result column="order_no" property="orderNo"/> <result column="update_time" property="updateTime"/> </resultMap> <!-- 根據id查詢返回Goods類型<typeAlias alias="goods" type="com.clark.model.Goods"></typeAlias>--> <!--resultMap 和resultType的使用區別--> <select id="selectGoodById" parameterType="int" resultType="goods"> select id,cate_id,name,price,description,order_no,update_time from goods where id = #{id} </select> <!-- 查詢所有Goods 返回resultMap類型--> <select id="selectAllGoods" resultMap="t_good"> select id,cate_id,name,price,description,order_no,update_time from goods </select> <!-- 指定parameterType=map 其中map的形式為Map<String,PageBean> map--> <select id="selectGoodsByPage" resultMap="t_good" parameterType="map"> <!-- order by id asc是指對查詢後的結果進行升序排序--> <![CDATA[ select * from (select g.*,rownum rn from (select * from goods) g where 1=1 and rownum <= #{pageBean.endNumber}) where rn >= #{pageBean.startNumber}order by id asc]]> </select> <!-- 新增Goods 參數類型為Goods--> <insert id="insertGood" parameterType="goods"> insert into goods(id,cate_id,name,price,description,order_no,update_time) values(#{id},#{cateId},#{name},#{price},#{description},#{orderNo},#{updateTime}) </insert> <!-- 更新Goods 參數類型為Goods--> <update id="updateGood" parameterType="goods"> update goods g set g.name = #{name},g.order_no =#{orderNo} where g.id = #{id} </update> <!-- 刪除Goods 參數類型為int--> <delete id="deleteGood" parameterType="int"> delete from goods g where g.id = #{id} </delete> </mapper>package com.clark.model; import java.util.Date; public class Goods { private Integer id; private Integer cateId; private String name; private double price; private String description; private Integer orderNo; private Date updateTime; public Goods(){ } public Goods(Integer id, Integer cateId, String name, double price, String description, Integer orderNo, Date updateTime) { super(); this.id = id; this.cateId = cateId; this.name = name; this.price = price; this.description = description; this.orderNo = orderNo; this.updateTime = updateTime; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Integer getCateId() { return cateId; } public void setCateId(Integer cateId) { this.cateId = cateId; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public Integer getOrderNo() { return orderNo; } public void setOrderNo(Integer orderNo) { this.orderNo = orderNo; } public Date getTimeStamp() { return updateTime; } public void setTimeStamp(Date updateTime) { this.updateTime = updateTime; } @Override public String toString() { return "[goods include:Id="+this.getId()+",name="+this.getName()+ ",orderNo="+this.getOrderNo()+",cateId="+this.getCateId()+ ",updateTime="+this.getTimeStamp()+"]"; } }package com.clark.model; //模擬的一個分頁對象PageBean public class PageBean { //開始數private Integer startNumber; //結束數private Integer endNumber; public PageBean(){ } public PageBean(Integer startNumber, Integer endNumber) { super(); this.startNumber = startNumber; this.endNumber = endNumber; } public Integer getStartNumber() { return startNumber; } public void setStartNumber(Integer startNumber) { this.startNumber = startNumber; } public Integer getEndNumber() { return endNumber; } public void setEndNumber(Integer endNumber) { this.endNumber = endNumber; } }package com.clark.mybatis; import java.io.IOException; import java.io.Reader; import java.util.HashMap; import java.util.List; import java.util.Map; 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 com.clark.model.Goods; import com.clark.model.PageBean; public class TestGoods { public static void main(String[] args) throws IOException { String resource = "configuration.xml"; Reader reader = null; SqlSessionFactory sessionFactory = null; SqlSession session = null; try { reader = Resources.getResourceAsReader(resource); sessionFactory = new SqlSessionFactoryBuilder().build(reader); session = sessionFactory.openSession(); PageBean pageBean = new PageBean(8, 20); Map<String,PageBean> map = new HashMap<String, PageBean>(); map.put("pageBean", pageBean); List<Goods> gs = findGoodsByPage(session,map); for (Goods goods2 : gs) { System.out.println(goods2.toString()); } } catch (IOException e) { e.printStackTrace(); }finally{ session.close(); reader.close(); } } //find by id public static Goods findGoodById(SqlSession session,Integer id){ //clark對應著goodMapper.xml配置文件中的namespace name="clark" Goods goods = (Goods)session.selectOne("clark.selectGoodById", id); return goods; } //find all public static List<Goods> findAllGoods(SqlSession session){ List<Goods> goods = session.selectList("clark.selectAllGoods"); return goods; } public static List<Goods> findGoodsByPage(SqlSession session,Map<String,PageBean> map){ List<Goods> goods = session.selectList("clark.selectGoodsByPage",map); return goods; } //insert a goods public static int insertGoods(SqlSession session,Goods goods){ int result = session.insert("clark.insertGood", goods); session.commit(); return result; } //update goods public static int updateGoods(SqlSession session,Goods goods){ int result = session.update("clark.updateGood", goods); session.commit(); return result; } //delete goods public static int deleteGood(SqlSession session,Integer id){ int result = session.delete("clark.deleteGood", id); session.commit(); return result; } }關於Mybatis實現增刪改查及分頁查詢的方法的相關知識，就給大家介紹到這裡，後續還會持續給大家更新，謝謝大家一直以來對武林網網站的支持。