public StateBean getState()
{
StateBean st = new StateBean();
DBsinglton.bsinglton();Connection con = DBsinglton.connection();
try
{
this.pstmt = con.prepareStatement(this.query);
this.rs = this.pstmt.executeQuery();
while (this.rs.next())
{
this.str[this.i] = this.rs.getString("States");
this.i += 1;
}
}
catch (SQLException e)
{
e.printStackTrace();
}
st.setStates(this.str);
System.out.println("************** State DB ****************");
return st;
}