java - 如何为ArrayList对象编写JUnit测试用例？

Question

这是我的一级管理员邮政代码。包含一些字符串及其 getter 和 Setter。

package org.sanket.zivameDataBase.adminPostalCode.model;

public class AdminPostalCode {

    private String entity_id1;
    private String postal_code1;
    private String city1;
    private String state1;
    private String country1;
    private String days_to_deliver1;
    private String cod1;
    private String pg1;
    private String rpu1;
    private String updated_by1;
    private String updated_at1;
    private String cod_couriername1;
    private String pg_couriername1;
    private String rto_couriername1;

    public AdminPostalCode(){}
    public AdminPostalCode(String entity_id1, String postal_code1,
            String city1, String state1, String country1,
            String days_to_deliver1, String cod1, String pg1, String rpu1,
            String updated_by1, String updated_at1, String cod_couriername1,
            String pg_couriername1, String rto_couriername1) {
        super();
        this.entity_id1 = entity_id1;
        this.postal_code1 = postal_code1;
        this.city1 = city1;
        this.state1 = state1;
        this.country1 = country1;
        this.days_to_deliver1 = days_to_deliver1;
        this.cod1 = cod1;
        this.pg1 = pg1;
        this.rpu1 = rpu1;
        this.updated_by1 = updated_by1;
        this.updated_at1 = updated_at1;
        this.cod_couriername1 = cod_couriername1;
        this.pg_couriername1 = pg_couriername1;
        this.rto_couriername1 = rto_couriername1;
    }


    public String getEntity_id1() {
        return entity_id1;
    }
    public void setEntity_id1(String entity_id1) {
        this.entity_id1 = entity_id1;
    }
    public String getPostal_code1() {
        return postal_code1;
    }
    public void setPostal_code1(String postal_code1) {
        this.postal_code1 = postal_code1;
    }
    public String getCity1() {
        return city1;
    }
    public void setCity1(String city1) {
        this.city1 = city1;
    }
    public String getState1() {
        return state1;
    }
    public void setState1(String state1) {
        this.state1 = state1;
    }
    public String getCountry1() {
        return country1;
    }
    public void setCountry1(String country1) {
        this.country1 = country1;
    }
    public String getDays_to_deliver1() {
        return days_to_deliver1;
    }
    public void setDays_to_deliver1(String days_to_deliver1) {
        this.days_to_deliver1 = days_to_deliver1;
    }
    public String getCod1() {
        return cod1;
    }
    public void setCod1(String cod1) {
        this.cod1 = cod1;
    }
    public String getPg1() {
        return pg1;
    }
    public void setPg1(String pg1) {
        this.pg1 = pg1;
    }
    public String getRpu1() {
        return rpu1;
    }
    public void setRpu1(String rpu1) {
        this.rpu1 = rpu1;
    }
    public String getUpdated_by1() {
        return updated_by1;
    }
    public void setUpdated_by1(String updated_by1) {
        this.updated_by1 = updated_by1;
    }
    public String getUpdated_at1() {
        return updated_at1;
    }
    public void setUpdated_at1(String updated_at1) {
        this.updated_at1 = updated_at1;
    }
    public String getCod_couriername1() {
        return cod_couriername1;
    }
    public void setCod_couriername1(String cod_couriername1) {
        this.cod_couriername1 = cod_couriername1;
    }
    public String getPg_couriername1() {
        return pg_couriername1;
    }
    public void setPg_couriername1(String pg_couriername1) {
        this.pg_couriername1 = pg_couriername1;
    }
    public String getRto_couriername1() {
        return rto_couriername1;
    }
    public void setRto_couriername1(String rto_couriername1) {
        this.rto_couriername1 = rto_couriername1;
    }

}

这是我的数据库连接类

package org.sanket.zivameDataBase.adminPostalCode.DataBase;

import java.sql.Connection;
import java.sql.DriverManager;


public class DataBaseConnection {
    public Connection getConnection() throws Exception
    {
    try
    {
    String connectionURL = "jdbc:mysql://localhost:3306/zdb";
    Connection connection = null;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    connection = DriverManager.getConnection(connectionURL, "root", "root");
    return connection;
    } catch (Exception e)
    {
    throw e;
    }

    }


}

这是我的访问类。

package org.sanket.zivameDataBase.adminPostalCode.DataBase;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.sanket.zivameDataBase.adminPostalCode.model.AdminPostalCode;

public class Access {

    public List<AdminPostalCode> getAdminPostalCode(int code,Connection con) throws SQLException
    {
        List<AdminPostalCode> adminDetail = new ArrayList<AdminPostalCode>();
        PreparedStatement stmt = con.prepareStatement("select * from admin_postalcode where postal_code ="+code+"");
        ResultSet resultSet = stmt.executeQuery();

    //System.out.println(resultSet);
        try
        {  
            while (resultSet.next()) 
            {   
                AdminPostalCode adminPostalCode = new AdminPostalCode(); 
                adminPostalCode.setEntity_id1(resultSet.getString("entity_id")); 
                adminPostalCode.setPostal_code1(resultSet.getString("postal_code"));
                adminPostalCode.setCity1(resultSet.getString("city"));
                adminPostalCode.setState1(resultSet.getString("state"));
                adminPostalCode.setCountry1(resultSet.getString("country"));
                adminPostalCode.setDays_to_deliver1(resultSet.getString("days_to_deliver"));
                adminPostalCode.setCod1(resultSet.getString("cod"));
                adminPostalCode.setPg1(resultSet.getString("pg"));
                adminPostalCode.setRpu1(resultSet.getString("rpu"));
                adminPostalCode.setUpdated_by1(resultSet.getString("updated_by"));
                adminPostalCode.setUpdated_at1(resultSet.getString("updated_at"));
                adminPostalCode.setCod_couriername1(resultSet.getString("cod_couriername"));
                adminPostalCode.setPg_couriername1(resultSet.getString("pg_couriername"));
                adminPostalCode.setRto_couriername1(resultSet.getString("rto_couriername"));

                adminDetail.add(adminPostalCode);

            }


        }catch (SQLException e)
            {
            e.printStackTrace();
            }
        return adminDetail ;


    }

}

现在我想为上面的代码编写 JUnit 测试用例。我尝试了以下方式。但它不起作用请帮助我编写 JUnit 测试用例。剩下的一切都工作正常。

package adminPostalCode;

import static org.junit.Assert.*;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.junit.Test;
import org.sanket.zivameDataBase.adminPostalCode.DataBase.Access;
import org.sanket.zivameDataBase.adminPostalCode.DataBase.DataBaseConnection;
import org.sanket.zivameDataBase.adminPostalCode.model.AdminPostalCode;

public class SampleTest {

    List<AdminPostalCode> detailsActual = new ArrayList<AdminPostalCode>();
    List<AdminPostalCode> detailsExpected = new ArrayList<AdminPostalCode>();

    boolean abc;

    AdminPostalCode adminPoCo = new AdminPostalCode();

    public SampleTest()
    {
        adminPoCo.setCity1("WEST CHAMPARAN");
        adminPoCo.setCod1("0");
        adminPoCo.setCod_couriername1("NO SERVICE");
        adminPoCo.setDays_to_deliver1("11");
        adminPoCo.setEntity_id1("19625");
        adminPoCo.setPg1("1");
        adminPoCo.setPg_couriername1("INDIA POST");
        adminPoCo.setPostal_code1("845106");
        adminPoCo.setRpu1("0");
        adminPoCo.setRto_couriername1("NO SERVICE");
        adminPoCo.setState1("BIHAR");
        adminPoCo.setUpdated_by1("panindra@milastar.in");
        adminPoCo.setUpdated_at1("2015-03-19 19:30:22.0");
        adminPoCo.setCountry1("IN");

        detailsExpected.add(adminPoCo);

    }

    @Test
    public void test() throws Exception {
        //fail("Not yet implemented");
        DataBaseConnection db = new DataBaseConnection();
        Connection con = db.getConnection();
        Access access = new Access();
        detailsActual =access.getAdminPostalCode(845106, con);

        abc = (detailsActual.equals(detailsExpected)) ; 
             System.out.println(abc);


    }

}

Answer 1

• 在junit中使用assertXxx而不是System.out。 junit 用于自动化测试并查找代码中的潜在问题并提供有关这些问题的有用信息。如果您使用 System.out，junit 的帮助就会少得多。

• 如果你使用junit编写单元测试，你不应该连接“真实”数据库，你应该使用一些模拟框架(例如mockito)来模拟Access对象。

• 如果您想使用 junit 编写集成测试，您应该使用一些特定的 junit 扩展框架，例如 dbunit。