基于spring和mybatis项目的JUnit测试用例的实现

主要目的：实现JUnit的Crud
项目目前情况：spring+mybatis
想在前后端分离的情况下，
后端实现各个模块CRUD的junit
遇到的最大问题先是注入之后提示nullPointException
接着很快反应过来
是junit运行单个文件的时候并没有在启动容器，也就是说单独执行一个文件没有初始化spring，也就无法使用service了
那么如何才能初始化spring呢？这就是这次junit中遇到的最大的问题

@Autowired
public static ProjectService projectService;

package test;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JsonConfig;
import org.junit.BeforeClass;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import project.dao.ProjectDao;
import project.dao.ProjectService;
import project.domain.Project;

import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;

//import org.springframework.beans.factory.annotation.Autowired;

/**
 * Created by san-pc on 2016/2/26.
 */
public class ProjectTestbeat1 {

   /* @Autowired
    public static ProjectDao projectDao;
*/
   @Autowired
   public static ProjectService projectService;
    @BeforeClass
    public static void init() {//junit之前init spring
        ApplicationContext   context = new ClassPathXmlApplicationContext("classpath*:conf/root.xml");//这里路径之前没有配对于是一直出错
        projectService = (ProjectService)context.getBean("projectService");
    }
    @Test
    public  void addProject() throws Exception {
        Project project = new Project();
        project.setProjectName("七天通知贷");
        project.setProjectCode("20151601032046");
        project.setProjectType("通知贷");
        project.setInterestDate(7);
        project.setInterestRatio(0.0009);
        project.setCompanyId(1);
        project.setCompanyName("旺金控股公司");
        project.setLinkmanId(Long.valueOf(16292 + ""));
        project.setLinkmanName("胡二");
        project.setCreateId(16309);
        project.setCreaterName("罗星星");
        project.setBudgetIncome(12000);
        project.setBudgetExpenses(1000);
        project.setRealExpenses(2000);
        project.setCreateDate(new Date());//创建日期
        project.setEditDate(new Date());//最后修改时间
        project.setPstartDate(new Date());//竞标日期
        project.setPfullDate(new Date());//满标日期
        project.setPvalueDate(new Date());//起息日期
        project.setPendDate(new Date());//回款日期
        project.setPrealendDate(new Date());//实际回款日期
        project.setRemark("测试数据");
        project.setStateCode("0");
        projectService.insertProject(project);
        projectService.updateProject(project);

    }

    public static void main(String[] args){
        try {
         //   addProject();
        } catch (Exception e) {
            System.out.println("---------------------添加错误--------------------");
            e.printStackTrace();
        }
    }
    public Map<String, String> SELECT1(Map<String, String> b) {
        return b;
    }

    // @Test
    public static Map<String, Project> JSON2Map() {
        System.out.println("shuchu");
        Map<String, Project> map = new HashMap<String, Project>();
        return map;
    }
}

上面代码中的
ApplicationContext context = new ClassPathXmlApplicationContext(“classpath*:conf/root.xml”);//
大家一定觉得好奇了，因为我们的配置文件肯定不止一个，如何把spirng和spring-mvc以及其他xml引入呢？
这个时候就需要写一个类似web.xml的文件包含所有需要的配置文件了
即：root.xml

接着spring的初始化就算完成了
接着是测试mapping的crud
首先是测试insert

第一部分是基本配置
<mapper namespace="project.dao.ProjectDao">


    <!--表名 -->
    <sql id="table_name">project</sql>

    <sql id="table_roles">staff_roles</sql>

    <sql id="select_fields">
               project_name,project_code, project_type, interest_date,interest_ratio,company_id,
                company_name,linkman_id,linkman_name,create_id,creater_name,budget_income,
                budget_expenses,real_expenses,create_date,edit_date,
               pstart_date, pfull_date,pvalue_date,pend_date,prealend_date,remark,state_code
    </sql>
    <resultMap id="entityMap" type="project.domain.Project">
        <result column="project_name" property="projectName"  />
        <result column="project_code" property="projectCode" />
        <result column="project_type" property="projectType" />
        <result column="interest_date" property="interestDate" />
        <result column="interest_ratio" property="interestRatio" />
        <result column="company_id" property="companyId" />
        <result column="company_name" property="companyName"  />
        <result column="linkman_id" property="linkmanId" />
        <result column="linkman_name" property="linkmanName" />
        <result column="create_id" property="createId" />
        <result column="creater_name" property="createrName" />
        <result column="budget_income" property="budgetIncome" />
        <result column="budget_expenses" property="budgetExpenses" />
        <result column="real_expenses" property="realExpenses" />
        <result column="create_date" property="createDate"  />
        <result column="edit_date" property="editDate" />
        <result column="pstart_date" property="updatedAt" />
        <result column="pfull_date" property="operatorId" />
        <result column="pvalue_date" property="pvalueDate" />
        <result column="pend_date" property="pendDate"  />
        <result column="prealend_date" property="prealendDate" />
        <result column="remark" property="remark" />
        <result column="state_code" property="stateCode" />
    </resultMap>

第二部分是CRUD模块的实现
    <!--新增-->
    <!--keyProperty：指主键属性名，也是返回的数据
    useGeneratedKeys：表示设置是否使用JDBC的getGenereatedKeys方法获取主键并赋值到keyProperty设置的领域模型属性中->
    <insert id="insertProject" parameterType="project.domain.Project" keyColumn="project_id" useGeneratedKeys="true" keyProperty="project_id">
        INSERT INTO
        <include refid="table_name"></include>
        (
        <include refid="select_fields" />
        )
        VALUES
        (
        #{projectName},#{projectCode},#{projectType},#{interestDate},#{interestRatio},#{companyId},
        #{companyName},#{linkmanId},#{linkmanName},#{createId},#{createrName},#{budgetIncome},
        #{budgetExpenses},#{realExpenses},#{createDate},#{editDate},
        #{pstartDate},#{pfullDate},#{pvalueDate}, #{pendDate}, #{prealendDate},#{remark},
        #{stateCode}
        )
    </insert>

最后测试结果（如下）新增成功，但是部分字段未保存成功，数据丢失问题，有空继续补全