我有以下代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DatabaseReader {
    public static final String CONNECTION = "jdbc:mysql://localhost/testdb";
    public static String getById(Integer id) throws SQLException {
        String query = "SELECT * FROM Foo WHERE Id = ?";
        Connection connection = DriverManager.getConnection(CONNECTION);
        PreparedStatement preparedStatement = connection.prepareStatement(query);
        preparedStatement.setInt(1, id);
        ResultSet resultSet = preparedStatement.executeQuery();
        resultSet.next();
        String result = resultSet.getString(0);
        resultSet.close();
        preparedStatement.close();
        connection.close();
        return result;
    }
    public static String getId(int id) throws SQLException{
        return getById(id); 
    }
}

有没有可能powermock函数getbyid，以便在测试getid时，得到getbyid的mock值？我试着这样：

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.fail;
import static org.mockito.Mockito.when;
import static org.powermock.api.mockito.PowerMockito.mockStatic;
import static org.powermock.api.mockito.PowerMockito.verifyStatic;
import java.sql.SQLException;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.powermock.api.mockito.PowerMockito;
import org.powermock.core.classloader.annotations.PrepareForTest;
import org.powermock.modules.junit4.PowerMockRunner;
@RunWith(PowerMockRunner.class)
    @PrepareForTest(DatabaseReader.class)
    public class DatabaseReaderTest {
        @Test
        public void testGetById() {
            int inputId = 1;
            String returnValue = "JavaCodeGeeks";
            mockStatic(DatabaseReader.class);
            try {
                when(DatabaseReader.getById(inputId))
                    .thenReturn(returnValue);
                String actual = DatabaseReader.getId(inputId);
                System.out.println(actual);
                verifyStatic();
                assertEquals(returnValue, actual);
            } catch (SQLException e) {
                fail("No exception should be thrown.");
            }
        }

但是，我打电话的时候它不起作用

String actual = DatabaseReader.getId(inputId);

它尝试调用整个数据库方法。我对iu是否可以模拟静态方法的静态方法调用感到困惑。