public void select() {
try {
con = DBConnect.openConnection();
Statement stmt = con.createStatement();
ResultSet rs =
stmt.executeQuery(
"SELECT sl_no, user_id, job_description, gross_salary, da, allowance, medical, servant, transport FROM basic_salary_details WHERE sl_no = '"
+ bean.getSlNo()
+ "'");
ArrayList<BasicSalaryDetailVo> basicSalaryDetailVo = new ArrayList<BasicSalaryDetailVo>();
while (rs.next()) {
BasicSalaryDetailVo vo =
new BasicSalaryDetailVo(
rs.getInt("sl_no"),
rs.getString("allowance"),
rs.getString("da"),
rs.getString("gross_salary"),
rs.getString("job_description"),
rs.getString("medical"),
rs.getString("servant"),
rs.getString("transport"),
rs.getString("user_id"));
basicSalaryDetailVo.add(vo);
}
bean.setBasicSalaryDetailVo(basicSalaryDetailVo);
DBConnect.closeConnection(con);
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
