public static List<Staff> executestaffdetailsQuery(String querystr) throws Exception {
Connection conn = null;
Statement stmt = null;
ResultSet rs;
List<Staff> staffList = new ArrayList<Staff>();
try {
conn = DBOperation.getConnection();
stmt = conn.createStatement();
// System.out.println("before execute");
rs = stmt.executeQuery(querystr);
// System.out.println("after execute");
// stmt = conn.createStatement();
// rs.absolute(2);
while (rs.next()) {
System.out.println("before query");
Staff staff = new Staff();
staff.setUser_id(rs.getInt("user_id"));
System.out.println("after query" + rs.getInt("user_id"));
staff.setF_name(rs.getString("f_name"));
staff.setL_name(rs.getString("l_name"));
staff.setPassword(rs.getString("password"));
staff.setEmail(rs.getString("email"));
staff.setAddress(rs.getString("address"));
staff.setCity(rs.getString("city"));
staff.setState(rs.getString("state"));
staff.setZipcode(rs.getString("zipcode"));
staff.setDob(rs.getString("dob"));
staff.setStaff_ssn(rs.getInt("staff_ssn"));
staff.setWork_desc(rs.getString("work_desc"));
staff.setPosition(rs.getString("position"));
staff.setHire_date(rs.getString("hire_date"));
// staff.setWork_desc(rs.getString("work_desc"));
staffList.add(staff);
}
} catch (Exception e) {
System.out.println("unable to execute customer details query" + querystr);
}
System.out.println("List length:: " + staffList.size());
return staffList;
}
