try{
ps = conn.prepareStatement("select * from funcionario");
rs = ps.executeQuery();
List<Funcionario> list = new ArrayList<Funcionario>();
while(rs.next()) {
list.add(new Funcionario(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getString(4), rs.getString(5), rs.getInt(6), rs.getString(7), rs.getString(8), rs.getInt(9), rs.getInt(10), rs.getLong(11), rs.getDate(12), rs.getLong(13), rs.getLong(14), rs.getString(15), rs.getLong(16), rs.getString(17), rs.getInt(18), rs.getInt(19), rs.getString(20), rs.getDate(21), rs.getString(22), rs.getString(23), rs.getString(24)));
}
return list;
} catch (Exception e) {
e.printStackTrace();
}