OpenJUMP
Scripting with BeanShell

StringBuffer sql = new StringBuffer();
sql.append("UPDATE systwodb_stns ");    
java.util.List setList = new java.util.ArrayList();

/ systwodb_stns
  Add a new set clause to setList for each updated attribute.
  Later, we will execute a single UPDATE statement to update
  all the changing columns.
 /

if (attrs.containsKey("ADDRS")) {
    setList.add(setDescr("String", "ADDRS", attrs.get("ADDRS")));
}
if (attrs.containsKey("AS_OF_REL")) {
    setList.add(setDescr("String", "AS_OF_REL", attrs.get("AS_OF_REL")));
}
if (attrs.containsKey("ATTEMPTS")) {
    setList.add(setDescr("String", "ATTEMPTS", attrs.get("ATTEMPTS")));
}
if (attrs.containsKey("BATCH_NO")) {
    setList.add(setDescr("String", "BATCH_NO", attrs.get("BATCH_NO")));
}
if (attrs.containsKey("BRANCH")) {
    setList.add(setDescr("String", "BRANCH", attrs.get("BRANCH")));
}
if (attrs.containsKey("CNFM_PRNTR")) {
    setList.add(setDescr("String", "CNFM_PRNTR", attrs.get("CNFM_PRNTR")));
}
if (attrs.containsKey("DBATCH_NO")) {
    setList.add(setDescr("String", "DBATCH_NO", attrs.get("DBATCH_NO")));
}
if (attrs.containsKey("DISABLED")) {
    setList.add(setDescr("String", "DISABLED", attrs.get("DISABLED")));
}
if (attrs.containsKey("MAINT")) {
    setList.add(setDescr("String", "MAINT", attrs.get("MAINT")));
}
if (attrs.containsKey("GLB_DTIME")) {
    setList.add(setDescr("String", "GLB_DTIME", attrs.get("GLB_DTIME")));
}
if (attrs.containsKey("NEWDATE")) {
    setList.add(setDescr("String", "NEWDATE", attrs.get("NEWDATE")));
}
if (attrs.containsKey("PRINTER_ID")) {
    setList.add(setDescr("String", "PRINTER_ID", attrs.get("PRINTER_ID")));
}
if (attrs.containsKey("PYMT_PRNTR")) {
    setList.add(setDescr("String", "PYMT_PRNTR", attrs.get("PYMT_PRNTR")));
}
if (attrs.containsKey("RBATCH_NO")) {
    setList.add(setDescr("String", "RBATCH_NO", attrs.get("RBATCH_NO")));
}
if (attrs.containsKey("STATPWORDE")) {
    setList.add(setDescr("String", "STATPWORDE", attrs.get("STATPWORDE")));
}
if (attrs.containsKey("SYS_STATUS")) {
    setList.add(setDescr("String", "SYS_STATUS", attrs.get("SYS_STATUS")));
}
if (attrs.containsKey("USERCODE")) {
    setList.add(setDescr("String", "USERCODE", attrs.get("USERCODE")));
}

if (setList.size() > 0) {
    /
      At least one column is being updated, so update the SQL
      and set the parameters appropriately to acccomplish
      the update.
     /
    sql.append(getSQLSetStrings(setList));
    sql.append(" WHERE STATIONID = ?");
    st = conn.prepareStatement(sql.toString());
    int nextIndex = setParameters(st, setList, 1);
    st.setString(nextIndex, id);
    st.executeUpdate();
}

/
  This is a lazy and inefficient way to update the user_autorizacija table
 /

String sqlStr = "DELETE FROM user_autorizacija WHERE USERCODE = ?";
st = conn.prepareStatement(sqlStr);
st.setString(1, id);
st.execute();

java.util.List autorList = null;
Object autors = attrs.get("autorizacije");

if (autorsIds != null) {
  if (autorsIds instanceof String) {
    autorList = new java.util.ArrayList();
    autorList.add(autorsIds);
  }
  else if ( autorsIds instanceof java.util.List) {
    autorList = autorsIds;
  }
}

if (autorList != null) {
  for(int i =0; i @lt autorList.size(); i++) {
    String myautor = (String)autorList.get(i);
    String[] autor = {myautor.split('|')};
}

/ Insert new row into user_autorizacija table /
  sqlStr = "INSERT INTO user_autorizacija (USERCODE,APLIKACIJA,GRUPA_EKR,PRISTUP,POSAO,PRIVILEGIJA) VALUES(?,?,?,?,?,?)";
  st = conn.prepareStatement(sqlStr);
  st.setString(1, id);
}

for(int j=2; j<7; j++) {
  if (autor[j-2] != null) {
    st.setString(j, autorizacija[j-2]);
  }
  else {
    st.setString(j, " ");  
  }
}
st.execute();

/
  This is a lazy and inefficient way to update the user_secur table
 /
String sqlStr = "DELETE FROM user_secur WHERE USERCODE = ?";
st = conn.prepareStatement(sqlStr);
st.setString(1, id);
st.execute();

java.util.List securList = null;
Object secureIds = attrs.get("secure");

if (secureIds != null) {
  if (secureIds instanceof String) {
    securList = new java.util.ArrayList();
    securList.add(secureIds);
  }
  else if ( secureIds instanceof java.util.List) {
    securList = secureIds;
  }
}

if (securList != null) {
  for(int i =0; i @lt securList.size(); i++) {
    String mysecur = (String)securList.get(i);
    String[] secur = mysecur.split('|');
}

/ Insert new row into user_secur table /
  sqlStr = "INSERT INTO user_secur (USERCODE,APLIKACIJA,GRUPA_EKR,PRISTUP) VALUES(?,?,?,?)";
  st = conn.prepareStatement(sqlStr);
  st.setString(1, id);
}

for(int j=2; j<5; j++) {
  if (secur[j-2] != null) {
    st.setString(j, secur[j-2]);
  }
  else {
    st.setString(j, " ");  
  }
}
st.execute();

/ Now commit all changes */
conn.commit();
} finally {
if (st != null)
  st.close();
}