为DAO编写Junit测试用例

Question

customer-Mapper.xml

<?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">
    <insert id="newCustomer" parameterType="com.yell.hibu.domain.Customer">
        INSERT INTO CUSTOMER(CUSTOMER_ID, NAME, EMAIL_ID,GRAPHIC_NAME,MOBILE,DOB,LANGUAGE,CITY,COUNTRY) values(#{customerID},#{customerName},#{emailID},#{userFileFileName},#{mobileNo},#{dob},#{language},#{city},#{country})
    </insert>

    <select id="selectCustomer" resultMap="customer">
          SELECT * FROM CUSTOMER WHERE CUSTOMER_ID = #{customerID};
        </select>

             <resultMap type="com.yell.hibu.domain.Customer" id="customer">
             <result property="customerID" column="CUSTOMER_ID" />
                 <result property="customerName" column="NAME" />
                 <result property="emailID" column="EMAIL_ID" />
                 <result property="userFileFileName" column="GRAPHIC_NAME" />
                 <result property="mobileNo" column="MOBILE" />
                 <result property="dob" column="DOB" />
                 <result property="language" column="LANGUAGE" />
                 <result property="city" column="CITY" />
                 <result property="country" column="COUNTRY" />

        </resultMap>
</mapper>

daoimpl.java

package com.yell.hibu.dao;

import org.apache.log4j.Logger;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.yell.hibu.domain.Customer;

    public class CustomerDaoImpl extends SqlSessionDaoSupport implements CustomerDao{

        private final Logger logger= Logger.getLogger(this.getClass());

        public void insertCustomer(Customer customer) {
            logger.info("Entered into CustomerDaoImpl :: insertCustomer()");
            getSqlSession().insert("customer.newCustomer", customer);
            logger.info("leaving from CustomerDaoImpl :: insertCustomer()");

        }

    }

Answer 1

由于我使用EasyMock，所以我模拟返回模拟会话对象或抛出异常的sessionFactory实例。

@Test(expectedExceptions = Exception.class)
public void testFailureToConnect() throws Exception {

    iocSessionFactory = EasyMock.createMock(SqlSessionFactory.class);
    oracleDAOImpl.setIocOracleSessionFactory(iocSessionFactory);
    EasyMock.expect(iocSessionFactory.openSession()).andThrow(new RuntimeException("CONNECTION ERROR"));
    EasyMock.replay(iocSessionFactory);

    oracleDAOImpl.getData();
}