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;
}
