public void save(Proj project, String rval, String oval) throws SQLException { if (!rval.equals(project._ResultComment)) { String sql = "update [PROD_UPG_DATA].[dbo].[RES_ATTACHMENTS] set [mycomment] = '" + rval + "' where [attachmenttype] = 'COMMENTRESULT' and [ordno] = '" + currentSelection + "'"; PreparedStatement ps = con.prepareStatement(sql); boolean b = ps.execute(); ps.close(); project._ResultComment = rval; } if (!oval.equals(project._OrderComment)) { String sql = "update [PROD_UPG_DATA].[dbo].[RES_ATTACHMENTS] set [mycomment] = '" + oval + "' where [attachmenttype] = 'COMMENTORDER' and [ordno] = '" + currentSelection + "'"; PreparedStatement ps = con.prepareStatement(sql); boolean b = ps.execute(); ps.close(); project._OrderComment = oval; } }
public List<Proj> getProjects() throws SQLException { List<Proj> folderList = new ArrayList<Proj>(); String sql = "select [ordno], [mycomment], [attachmenttype] from [PROD_UPG_DATA].[dbo].[RES_ATTACHMENTS] where [attachmenttype] = 'COMMENTORDER' or [attachmenttype] = 'COMMENTRESULT'"; PreparedStatement ps = con.prepareStatement(sql); ResultSet rs = ps.executeQuery(); while (rs.next()) { String foldername = rs.getString(1); fset.add(foldername.substring(0, foldername.length() - 4)); Proj project = null; if (orderMap.containsKey(foldername)) { project = orderMap.get(foldername); } else { project = new Proj(rs.getString(1)); orderMap.put(foldername, project); folderList.add(project); } if (project != null) { String comment = rs.getString(2); String attype = rs.getString(3); if (attype.contains("COMMENTORDER")) { project._OrderComment = comment; } else { project._ResultComment = comment; } } } rs.close(); ps.close(); return folderList; }