/** update a field */
public void update(Field field) {
PreparedStatement stmt = null;
try {
String sql =
"update Fields "
+ "set XCoord = ?, Width = ?, HelpHTML = ?, "
+ "KnownData = ?, ProjectID = ?, Title = ? "
+ "where FieldID = ?";
stmt = db.getConnection().prepareStatement(sql);
stmt.setInt(1, field.getxCoord());
stmt.setInt(2, field.getWidth());
stmt.setString(3, field.getHelpHTML());
stmt.setString(4, field.getKnownData());
stmt.setInt(5, field.getProjectID());
stmt.setInt(7, field.getFieldID());
stmt.setString(6, field.getTitle());
if (stmt.executeUpdate() == 1) {
System.out.println("Update success");
} else {
System.out.println("Update fail");
}
} catch (SQLException e) {
System.out.println("Can't execute update");
e.printStackTrace();
} finally {
try {
if (stmt != null) stmt.close();
} catch (SQLException e) {
System.out.println("Can't execute connect");
e.printStackTrace();
}
}
}
/** add a field */
public void add(Field field) {
PreparedStatement stmt = null;
Statement keyStmt = null;
ResultSet keyRS = null;
try {
String sql =
"insert into Fields (XCoord, Title, Width, HelpHTML, "
+ "KnownData, ProjectID) values (?, ?, ?, ?, ?, ?)";
stmt = db.getConnection().prepareStatement(sql);
stmt.setInt(1, field.getxCoord());
stmt.setInt(3, field.getWidth());
stmt.setString(4, field.getHelpHTML());
stmt.setString(5, field.getKnownData());
stmt.setInt(6, field.getProjectID());
stmt.setString(2, field.getTitle());
if (stmt.executeUpdate() == 1) {
keyStmt = db.getConnection().createStatement();
keyRS = keyStmt.executeQuery("select last_insert_rowid()");
keyRS.next();
int id = keyRS.getInt(1);
field.setFieldID(id);
} else {
System.out.println("Add fail");
}
} catch (SQLException e) {
System.out.println("Can't execute add");
e.printStackTrace();
} finally {
try {
if (keyRS != null) keyRS.close();
if (stmt != null) stmt.close();
if (keyStmt != null) keyStmt.close();
} catch (SQLException e) {
System.out.println("Can't execute connect");
e.printStackTrace();
}
}
}