我有几个对象是特定类的子类(ValidateVO) . 所有这些都存储在我们的数据库中,并在验证表上使用类型代码 . 我想创建一个方法,我可以为每个获取相关信息的类调用 . 我不确定实例化类的类型,或者我不知道如何为此正确地声明泛型
private List extends ValidateVO> getValidateSubclassByType(Class extends ValidateVO> clazz, String type) {
List extends ValidateVO> validates = new ArrayList<>();
StringBuilder bldValidates = new StringBuilder()
.append("SELECT VALIDATE_ID, VALIDATE_DESCRIPTION, VALIDATE_ACTIVE ")
.append("FROM tblVALIDATE WHERE VALIDATE_TYPE = ?");
try (
Connection con = dataSource.getConnection();
PreparedStatement pstmtValidates = con.prepareStatement(bldValidates.toString());
) {
pstmtValidates.setString(1, type);
ResultSet rsWholesalerGroups = pstmtValidates.executeQuery();
if (rsWholesalerGroups.isBeforeFirst()) {
while (rsWholesalerGroups.next()) {
// if I use ValidateVO here, I have a problem when I add it to the list
ValidateVO validate = clazz.newInstance();
validate.setId(rsWholesalerGroups.getInt("VALIDATE_ID"));
validate.setName(rsWholesalerGroups.getString("VALIDATE_DESCRIPTION"));
validate.setActive(rsWholesalerGroups.getString("VALIDATE_ACTIVE").equals("Y"));
// The following is the line with the error
// The method add(capture#2-of ? extends ValidateVO) in the type List is not applicable for the arguments (ValidateVO)
validates.add(validate);
}
} else {
System.out.println("No WHOLESALERS");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
return validates;
}