help.java

    public List<String> getDataValueFromDataName(String dataname) {
        Connection con = null;
        List<String> list = new ArrayList<>();
        try {
            con = open();
            PreparedStatement ps = con.prepareStatement(
                    "SELECT DataValue FROM PDAPI WHERE DataName = ?"
            );
            ResultSet rs = ps.executeQuery();
            while(rs.next()) {
                list.add(rs.getString("DataValue"));
            }
        } catch(Exception e) {
            e.printStackTrace();
        } finally {
            close(con);
        }
        return list;
    }