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 static void init() {
Add.init();
Address.init();
Align.init();
Alloc.init();
Anchor.init();
And.init();
Bad.init();
Bitcast.init();
Block.init();
Builtin.init();
Call.init();
Cmp.init();
Cond.init();
Confirm.init();
Const.init();
Conv.init();
CopyB.init();
Deleted.init();
Div.init();
Dummy.init();
End.init();
Eor.init();
Free.init();
IJmp.init();
Id.init();
Jmp.init();
Load.init();
Member.init();
Minus.init();
Mod.init();
Mul.init();
Mulh.init();
Mux.init();
NoMem.init();
Not.init();
Offset.init();
Or.init();
Phi.init();
Pin.init();
Proj.init();
Raise.init();
Return.init();
Sel.init();
Shl.init();
Shr.init();
Shrs.init();
Size.init();
Start.init();
Store.init();
Sub.init();
Switch.init();
Sync.init();
Tuple.init();
Unknown.init();
}
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;
}
