// --------------------------------------------------------------------------
// QueryFactory : Table statements
// --------------------------------------------------------------------------
public List getTableStatements() {
List stmts = new ArrayList();
String stmt;
int dataPolicy = SectorPrms.getPositionDataPolicy();
if (dataPolicy == QueryPrms.NONE) {
stmt =
"create table "
+ Risk.getTableName()
+ " ("
+ "id int not null, "
+ "position_id int, "
+ "risk_value int"
+ ")";
} else {
stmt =
"create table "
+ Risk.getTableName()
+ " ("
+ getIdCreateStatement()
+ ", "
+ getPositionIdCreateStatement()
+ ", "
+ getRiskValueCreateStatement()
+ ") ";
}
stmts.add(stmt);
return stmts;
}
@Override
protected void onInitializationHeader(BlockHeaderWidget header) {
Risk risk = getObject();
header.addText(risk.getPriorityLabelModel(), "100px", true, false);
header.addText(risk.getLabelModel());
header.appendCell(new EmoticonsWidget(risk), null, true);
header.addMenuAction(new ActivateChangeHistoryAction(risk));
header.addMenuAction(new DeleteRiskAction(risk));
}
public static void openFile(String[] argv, Risk r) {
List files = new ArrayList();
for (int c = 0; c < argv.length; c++) {
String arg = argv[c];
if (arg.indexOf('=') < 0 && arg.length() > 0 && arg.charAt(0) != '-') {
files.add(arg);
}
}
if (files.size() == 1) {
r.parser("loadgame " + files.get(0));
} else if (files.size() > 1) {
JOptionPane.showMessageDialog(null, "unknown command: " + files);
}
}
public static void runLobby(Risk risk) {
try {
if (lobbyURL != null) {
URLClassLoader ucl =
URLClassLoader.newInstance(
new URL[] {new URL("jar:" + lobbyURL + "/LobbyClient.jar!/")});
Class lobbyclass = ucl.loadClass("org.lobby.client.LobbyClientGUI");
// TODO: should be like this
// lobbyclass.newInstance();
final javax.swing.JPanel panel =
(javax.swing.JPanel)
lobbyclass
.getConstructor(new Class[] {URL.class})
.newInstance(new Object[] {new URL(lobbyURL)});
javax.swing.JFrame gui = new javax.swing.JFrame("yura.net Lobby");
gui.setContentPane(panel);
gui.setSize(800, 600);
gui.setVisible(true);
gui.addWindowListener(
new java.awt.event.WindowAdapter() {
public void windowClosing(java.awt.event.WindowEvent evt) {
panel.setVisible(false);
}
});
panel.setVisible(true);
}
// else if (lobbyAppletURL!=null) {
else {
// on older clients open URL
RiskUtil.openURL(new URL(lobbyAppletURL));
}
} catch (Exception e) {
risk.showMessageDialog("unable to run the lobby: " + e.toString());
}
}
@Override
protected void onUpdateHeader(BlockHeaderWidget header) {
Risk risk = getObject();
header.setDragHandle(risk.getReference());
}
public static void checkForUpdates(Risk risk) {
if (checkForNoSandbox()) {
try {
// try { Thread.sleep(5000); }
// catch(InterruptedException e) {}
URL url = new URL(RiskUtil.RISK_VERSION_URL);
BufferedReader bufferin = new BufferedReader(new InputStreamReader(url.openStream()));
Vector buffer = new Vector();
String input = bufferin.readLine();
while (input != null) {
buffer.add(input);
input = bufferin.readLine(); // get next line
}
String[] newversion = (String[]) buffer.toArray(new String[buffer.size()]);
if (newversion[0].startsWith("RISKOK ")) {
String v = newversion[0].substring(7, newversion[0].length());
if (!v.equals(RiskUtil.RISK_VERSION)) {
for (int c = 1; c < newversion.length; c++) {
v = v + "\n" + newversion[c];
}
ResourceBundle resb = TranslationBundle.getBundle();
v =
resb.getString("mainmenu.new-version.text")
.replaceAll("\\{0\\}", RiskUtil.GAME_NAME)
+ " "
+ v;
String link = getURL(v);
if (link != null) {
int result =
JOptionPane.showConfirmDialog(
null,
v,
resb.getString("mainmenu.new-version.title"),
JOptionPane.OK_CANCEL_OPTION);
if (result == JOptionPane.OK_OPTION) {
RiskUtil.streamOpener.openURL(new URL(link));
}
} else {
// do not use this, this is used for errors
risk.showMessageDialog(v);
}
}
}
} catch (Throwable e) {
}
try {
// check for map updates
MapUpdateService.getInstance().init(getFileList("map"), MapChooser.MAP_PAGE);
} catch (Throwable th) {
}
}
}
public ViewProject(int id) {
initComponents();
currentProject = new Project();
currentProject.setProjectID(id);
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/projectmanagementsystem?zeroDateTimeBehavior=convertToNull",
"root",
"password");
String query2 = "select * from project where idproject = ?";
PreparedStatement pst2 = con.prepareStatement(query2);
int projectid = id + 1;
pst2.setInt(1, projectid);
ResultSet rs = pst2.executeQuery();
if (rs.next()) {
projectname.setText(rs.getString("projectname"));
projectdescription.setText(rs.getString("projectdesc"));
}
String query3 = "select * from teammember where teammember_FK = ?";
PreparedStatement pst3 = con.prepareStatement(query3);
pst3.setInt(1, projectid);
ResultSet rs2 = pst3.executeQuery();
while (rs2.next()) {
Person p = new Person();
p.setFirstName(rs2.getString("firstname"));
p.setLastName(rs2.getString("lastname"));
p.setPosition(rs2.getString("position"));
p.setPersonID(rs2.getInt("idteammember"));
teammembers.add(p);
teammodel.addElement(p.getFirstName() + " " + p.getLastName() + " " + p.getPosition());
}
teamlist.setModel(teammodel);
String query4 = "select * from goal where goal_FK = ?";
PreparedStatement pst4 = con.prepareStatement(query4);
pst4.setInt(1, projectid);
ResultSet rs3 = pst4.executeQuery();
while (rs3.next()) {
Goal g = new Goal();
g.setGoalID(rs3.getInt("idgoal"));
g.setGoalDesc(rs3.getString("goaldesc"));
g.setGoalType(rs3.getString("goaltype"));
goals.add(g);
goalmodel.addElement(g.getGoalType() + " " + g.getGoalDesc());
}
goallist.setModel(goalmodel);
String query5 = "select * from requirement where requirement_FK = ?";
PreparedStatement pst5 = con.prepareStatement(query5);
pst5.setInt(1, projectid);
ResultSet rs4 = pst5.executeQuery();
while (rs4.next()) {
Requirement r = new Requirement();
String type;
r.setRequirementID(rs4.getInt("idrequirement"));
r.setRequirementDescription(rs4.getString("requirementdesc"));
if (rs4.getInt("isFunctionalRequirement") == 0) {
r.setIsFunctionalRequirement(false);
type = "Non-functional";
} else type = "Functional";
requirements.add(r);
requirementmodel.addElement(type + " " + r.getRequirementDescription());
}
requirementlist.setModel(requirementmodel);
String query6 = "select * from risk where risk_FK = ?";
PreparedStatement pst6 = con.prepareStatement(query6);
pst6.setInt(1, projectid);
ResultSet rs5 = pst6.executeQuery();
while (rs5.next()) {
Risk r = new Risk();
r.setRiskID(rs5.getInt("idrisk"));
r.setRiskName(rs5.getString("riskname"));
r.setRiskStatus(rs5.getString("riskstatus"));
risks.add(r);
riskmodel.addElement(r.getRiskStatus() + " " + r.getRiskName());
}
risklist.setModel(riskmodel);
String query7 =
"select * from effort join requirement on effort.effort_FK = requirement.idrequirement"
+ " where requirement.requirement_FK = ?";
PreparedStatement pst7 = con.prepareStatement(query7);
pst7.setInt(1, projectid);
ResultSet rs6 = pst7.executeQuery();
while (rs6.next()) {
Effort e = new Effort();
e.setEffortID(rs6.getInt("ideffort"));
e.setEffortDate(rs6.getString("effortdate"));
e.setEffortDevPhase(rs6.getString("effortdevphase"));
e.setEffortHours(rs6.getInt("efforthours"));
e.setRequirementID(rs6.getInt("effort_FK"));
e.setRequirementDesc(rs6.getString("requirementdesc"));
efforts.add(e);
effortmodel.addElement(
"For req: "
+ e.getRequirementDesc()
+ " "
+ e.getEffortDevPhase()
+ " "
+ e.getEffortDate()
+ " "
+ e.getEffortHours());
}
effortlist.setModel(effortmodel);
} catch (Exception e) {
System.out.println(e.toString());
}
}
private void addriskActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_addriskActionPerformed
// TODO add your handling code here:
String[] types = {"Minor", "Moderate", "Major", "Catastrophic"};
JComboBox typeList = new JComboBox(types);
typeList.setSelectedIndex(0);
JTextArea description = new JTextArea();
description.setRows(5);
description.setColumns(10);
description.setLineWrap(true);
JScrollPane pane = new JScrollPane(description);
Object[] message = {
"Risk Type:", typeList,
"Description:", pane,
};
int option =
JOptionPane.showConfirmDialog(
this, message, "Enter Risk Information", JOptionPane.OK_CANCEL_OPTION);
if (option == JOptionPane.OK_OPTION) {
Risk risk = new Risk();
risk.setRiskName(description.getText());
risk.setRiskStatus(typeList.getSelectedItem().toString());
currentProject.getRisks().add(risk);
riskmodel.addElement(typeList.getSelectedItem().toString() + " " + description.getText());
risklist.setModel(riskmodel);
}
} // GEN-LAST:event_addriskActionPerformed
