public CoreList count(String dept_name) throws SQLException { CoreList ch = new CoreList(); ch.clear(); PreparedStatement pst = null; ResultSet rs = null; DBConn conn = new DBConn(); con = conn.getConnection(); try { pst = con.prepareStatement( "select count(*) from employee_reg where dept_name='" + dept_name + "'"); System.out.println("chai"); rs = pst.executeQuery(); while (rs.next()) { EmployeeRegForm psf = new EmployeeRegForm(); psf.setCount(rs.getInt(1)); ch.add(psf); } } catch (Exception e) { con.close(); System.out.println("Connection Closed"); e.printStackTrace(); } return ch; }