//START GET LEVEL of INSTITUTE BY KANIZ
public List<LookupMauzas> getLookupEducationLevelList() {
List<LookupMauzas> educatinLevelList = new ArrayList<LookupMauzas>();
String clobStr = "";
boolean fg = true;
con = dbc.connectDB();
if (con == null) {
fg = false;
}
if (fg) {
try {
st = con.createStatement();
String qty = "select education_level_id,education_level_name from lookup_education_levels";
System.out.println("Qry :" + qty);
rs = st.executeQuery(qty);
while (rs.next()) {
LookupMauzas lookupMauzas=new LookupMauzas();
lookupMauzas.setEducation_level_id(rs.getString("education_level_id"));
lookupMauzas.setEducation_level_name(rs.getString("education_level_name"));
lookupMauzas.setEducation_level_code(rs.getString("education_level_code"));
educatinLevelList.add(lookupMauzas);
}
} catch (SQLException sq) {
sq.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
return educatinLevelList;
}
public List<LookupMauzas> getLookupEducationLevelList() {
List<LookupMauzas> educatinLevelList = new ArrayList<LookupMauzas>();
String clobStr = "";
boolean fg = true;
con = dbc.connectDB();
if (con == null) {
fg = false;
}
if (fg) {
try {
st = con.createStatement();
String qty = "select education_level_id,education_level_name from lookup_education_levels";
System.out.println("Qry :" + qty);
rs = st.executeQuery(qty);
while (rs.next()) {
LookupMauzas lookupMauzas=new LookupMauzas();
lookupMauzas.setEducation_level_id(rs.getString("education_level_id"));
lookupMauzas.setEducation_level_name(rs.getString("education_level_name"));
lookupMauzas.setEducation_level_code(rs.getString("education_level_code"));
educatinLevelList.add(lookupMauzas);
}
} catch (SQLException sq) {
sq.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
return educatinLevelList;
}
No comments:
Post a Comment