java - Junit测试期望值

Question

我有以下方法在 Junit 中测试

public static boolean saveLocationData(String student, String city, String location){
    boolean status=false;
    try {
        Connection mySqlConn = MySQLConn.getConnection();
        String mySqlQuery = "INSERT INTO locations VALUES ( ?, ?, ?)";
        PreparedStatement preparedStatement =    mySqlConn.prepareStatement(mySqlQuery);
        preparedStatement.setString(1, student);
        preparedStatement.setString(2, city); 
        preparedStatement.setString(3, location); 
        preparedStatement.execute();                                                                 
    } catch (Exception exception){
        /////
    }
    return status;
}

我尝试过的测试是:

final void  saveLOCATIONData() {                                   
    boolean validation = LocationDao.saveLocationData("student", "nyc", "usa");
    assertTrue(validation);

    //doesn’t exist
    validation = LocationDao.saveLocationData("example", "example", "example");
    assertFalse(validation);
}

当我运行测试时，它说预期值应该为 true，而不是 false，而这是我在数据库中拥有的实际数据。是什么原因导致了这个问题？

Answer 1

请尝试以下代码:-

public static boolean saveLocationData(String student, String city, String location){
    boolean status=false;
    try {
        Connection mySqlConn = MySQLConn.getConnection();
        String mySqlQuery = "INSERT INTO locations VALUES ( ?, ?, ?)";
        PreparedStatement preparedStatement =    mySqlConn.prepareStatement(mySqlQuery);
        preparedStatement.setString(1, student);
        preparedStatement.setString(2, city); 
        preparedStatement.setString(3, location); 
        preparedStatement.execute();
        status=true;                                                                 
    } catch (Exception exception){
        /////
    }
    return status;
}

*************************************************
final void  saveLOCATIONData() {                                   
    boolean validation = LocationDao.saveLocationData("student", "nyc", "usa");
    assertTrue(validation);

    //doesn’t exist
    validation = LocationDao.saveLocationData("example", "example", "example");
    assertFalse(validation);
}