Trouble getting result sets from multiple queries

Trouble getting result sets from multiple queries

Trying to get the adminnum from the db but wont let me get multiple
peoples adminnum, throws null pointer exceptions :(
In the beginning i'm getting the firstname to initialize the query, it
works for the first one but then doesn't work for any others.
String HeadBoy = (String) ComboHBoy.getSelectedItem();
System.out.println("Head boy:" +HeadBoy);
String[] SplitHB = HeadBoy.split(" ");
String HBFirstname = SplitHB[0];
System.out.println(HBFirstname);
String HeadGirl = (String) ComboHGirl.getSelectedItem();
System.out.println("Head girl:" +HeadGirl);
String[] SplitHG = HeadGirl.split(" ");
String HGFirstname = SplitHG[0];
System.out.println(HGFirstname);
String DHeadBoy = (String) ComboDHBoy.getSelectedItem();
System.out.println("Head deputy boy:" +DHeadBoy);
String[] SplitDHB = DHeadBoy.split(" ");
String DHBFirstname = SplitDHB[0];
System.out.println(DHBFirstname);
String DHeadGirl = (String) ComboDHGirl.getSelectedItem();
System.out.println("Head deputy girl:" +DHeadGirl);
String[] SplitDHG = DHeadGirl.split(" ");
String DHGFirstname = SplitDHG[0];
System.out.println(DHGFirstname);
ResultSet rs1;
String sqlHB = "SELECT adminnum from tblCandidate WHERE firstname =
'"+HBFirstname+"'";
System.out.println(sqlHB);
rs1 = parent.db.query(sqlHB);
try {
rs1.next();
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
String HBadminnum = null;
try {
HBadminnum = rs1.getString("adminnum");
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(HBadminnum);
String sqlHG = "SELECT addminum from tblCandidate WHERE firstname =
'"+HGFirstname+"'";
System.out.println(sqlHG);
rs1 = parent.db.query(sqlHG);
try {
rs1.next();
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
String HGadminnum = null;
try {
HGadminnum = rs1.getString("adminnum");
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(HGadminnum);
String sqlDHB = "SELECT addminum from tblCandidate WHERE firstname =
'"+DHBFirstname+"'";
System.out.println(sqlDHB);
rs1 = parent.db.query(sqlDHB);
try {
rs1.next();
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
String DHBadminnum = null;
try {
DHBadminnum = rs1.getString("adminnum");
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(DHBadminnum);
String sqlDHG = "SELECT addminum from tblCandidate WHERE firstname =
'"+DHGFirstname+"'";
System.out.println(sqlDHG);
rs1 = parent.db.query(sqlDHG);
try {
rs1.next();
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
String DHGadminnum = null;
try {
DHGadminnum = rs1.getString("adminnum");
} catch (SQLException ex) {
Logger.getLogger(Vote.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(DHGadminnum);