jeudi 1 septembre 2016

Make the JDBC call throw a SQLException for a test case

I am writing test cases for my program and to maximize the code coverage I have to raise a SQLException, that exception will then be checked in my test case.

public double getTotalAmount(String form,String name) {
    DbManager manager = new DbManager();
    double amount = 0;
    ResultSet executeQuery = manager.findAll("select amount From "+form+" where employee_name='"+name+"'");
    try {
        while (executeQuery.next()) {
            String tempAmount = executeQuery.getString("amount");
            amount += Double.valueOf(tempAmount);
        }
        return amount;
    } catch (SQLException e) {

        e.printStackTrace();
    }
    manager.closeConnection();
    return -1;

Now I am unable to raise the SQLException in my code, can you suggest me how can I raise this exception in my code.

Aucun commentaire:

Enregistrer un commentaire