Box boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("ID"));
txtID = new JTextArea();
txtID.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtID.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value != null)
rsRank.setId(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtID);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("shortPrefix"));
txtShortPrefix = new JTextArea();
txtShortPrefix.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtShortPrefix.getText();
try {
if((txt == null) || (txt.length() == 0))
rsRank.setShortPrefix(null);
else
rsRank.setShortPrefix(txt);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtShortPrefix);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("prefix"));
txtPrefix = new JTextArea();
txtPrefix.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtPrefix.getText();
try {
if((txt == null) || (txt.length() == 0))
rsRank.setPrefix(null);
else
rsRank.setPrefix(txt);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtPrefix);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("verbstr"));
txtVerbstr = new JTextArea();
txtVerbstr.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtVerbstr.getText();
try {
if((txt == null) || (txt.length() == 0))
rsRank.setVerbStr(null);
else
rsRank.setVerbStr(txt);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtVerbstr);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("greeting"));
txtGreeting = new JTextArea();
txtGreeting.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtGreeting.getText();
try {
if((txt == null) || (txt.length() == 0))
rsRank.setGreeting(null);
else
rsRank.setGreeting(txt);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtGreeting);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("expireDays"));
txtExpireDays = new JTextArea();
txtExpireDays.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtExpireDays.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setExpireDays(null);
else
rsRank.setExpireDays(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtExpireDays);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apDays"));
txtAPDays = new JTextArea();
txtAPDays.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPDays.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setApDays(null);
else
rsRank.setApDays(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtAPDays);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apRecruitScore"));
txtAPRS = new JTextArea();
txtAPRS.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPRS.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setApRecruitScore(null);
else
rsRank.setApRecruitScore(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtAPRS);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apWins"));
txtAPWins = new JTextArea();
txtAPWins.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPWins.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setApWins(null);
else
rsRank.setApWins(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtAPWins);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apD2Level"));
txtAPD2Level = new JTextArea();
txtAPD2Level.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPD2Level.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setApD2Level(null);
else
rsRank.setApD2Level(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtAPD2Level);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apW3Level"));
txtAPW3Level = new JTextArea();
txtAPW3Level.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPW3Level.getText();
Long value = null;
try {value = Long.parseLong(txt);} catch(Exception e) {}
try {
if(value == null)
rsRank.setApW3Level(null);
else
rsRank.setApW3Level(value);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
});
boxLine.add(txtAPW3Level);
}
majorRows.add(boxLine);
boxLine = new Box(BoxLayout.X_AXIS);
{
boxLine.add(new JLabel("apMail"));
txtAPMail = new JTextArea();
txtAPMail.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {}
public void focusLost(FocusEvent arg0) {
if(rsRank != null) {
String txt = txtAPMail.getText();
try {