java 从SQL查询方法返回泛型类型

2ledvvac  于 2023-03-28  发布在  Java
关注(0)|答案(1)|浏览(139)

我试图从SQL查询方法返回泛型类型,但我坚持将数据库的值分配给泛型类型:

public static <T extends Comparable<T>> T selectQuery(Connection conn, String sql, T[] parameters) {
        T value = null;
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            List<T> list = Arrays.asList(parameters);
            for (T param : list) {
                if (param instanceof String) {
                    ps.setString(list.indexOf(param), (String) param);
                } else if (param instanceof Integer) {
                    ps.setInt(list.indexOf(param), (Integer) param);
                } else if (param instanceof Double) {
                    ps.setDouble(list.indexOf(param), (Double) param);
                }
            }
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                 //AM STUCK RIGHT HERE************
            }
            Conn.closeConn(conn);
        } catch (Exception asd) {
            System.out.println(asd.getMessage());
        }
        return value;
    }

接下来我可以尝试什么?

sg3maiej

sg3maiej1#

int i=0;
while (rs.next()) 
{
     int type=rs.getMetaData().getColumnTypeName(i);
     if(type ==Types.INTEGER)
       value = (T) rs.getInt();
     else if(type ==Types.DOUBLE)
       value = (T) rs.getDouble();
     else if(type ==Types.FLOAT)
       value = (T) rs.getFloat();
     else if(type ==Types.VARCHAR)
       value = (T) rs.getString();
     else if(type ==Types.LONG)
       value = (T) rs.getLong();
}

有关Types in sql的更多参考

相关问题