MyBatis簡單的增刪改查以及簡單的分頁查詢實現

jopen 10年前發布 | 229K 次閱讀 MyBatis MyBatis3 持久層框架

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

</div> </div>

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

</div> </div>

    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()+"]";  
    }  
}  </pre><a style="text-indent:0px;" title="派生到我的代碼片" href="/misc/goto?guid=4959615104961912255" target="_blank"></a></div>

</div>
</div>


    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;  
    }  
}  </pre><a style="text-indent:0px;" title="派生到我的代碼片" href="/misc/goto?guid=4959615104961912255" target="_blank"></a></div>

</div>
</div>


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;

    }

}  </pre></div>
</div>
</div>
來自：http://blog.csdn.net/caolipeng_918/article/details/39346657
                    
                    
                         本文由用戶 jopen 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
                         轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
                         本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！
                         本文地址：http://www.baiduhome.net/lib/view/open1410956248601.html
                         MyBatis MyBatis3 持久層框架
                    

                
                
                    
                        相關經驗
                        
  MyBatis簡單的增刪改查以及簡單的分頁查詢實現
   MyBatis3.2.2+SpringMVC3.0 簡單實現(增刪改查)
   MyBatis基本增刪改查操作
   MyBatis3.1.1+Spring3.1.1的增、刪、查、改以及分頁和事務管理
   MyBatis封裝簡單的CRUD
                         
                    
                    
                        相關資訊
                        
  數據庫的最簡單實現
   Mybatis 分頁插件 4.1.0 發布
   Mybatis 分頁插件 4.1.2 發布
   Fluqi讓JQuery更簡單
   簡單的CMS系統 DynPage
                         
                    
                    
                        相關文檔
                        
   C#連接Oracle數據庫執行簡單的增刪改查操作
    使用ADF創建簡單的增刪改查
    thinkphp的增刪改查
    Hibernate 簡單查詢
    使用SSH開發增刪改查的綜合用戶管理例子
    使用SSH開發增刪改查的綜合用戶管理例子
    GoF 23 種設計模式解析附實現源碼(2nd Edition)
                         
                    

                    目錄