Examples of com.mysql.jdbc.ResultSet.first()

com.mysql.jdbc.ResultSet.first()
JDBC 2.0
Moves to the first row in the result set.
@return true if on a valid row, false if no rows in the result set. @exception SQLException if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY.

            ResultSet resSet;
            
            { /* Check wheter a user is both present and already registered into the DB */
                command = "SELECT registered FROM patients WHERE username = '" + username + "'";
                resSet = dbConn.executeQuery(command);
                if (resSet.first()){
                    boolean isYetRegistered_str = resSet.getBoolean("registered");
                    if (isYetRegistered_str) throw new YetRegisteredException();
                } else {
                    throw new NotInDBException();
                }

View Full Code Here

                htmlPage+="<th>Seleziona</th>\n";
                htmlPage+="</tr>\n";
                
                try {
                    
                    if(r.first()){
                        while (!r.isAfterLast()) {
                            
                            Paziente p = new Paziente(r);
                            
                            if (!arrayPazienti.add(p))

View Full Code Here

                htmlPage+="<th>Medico</th>\n";
                htmlPage+="</tr>\n";
                
                try {
                    
                    if(r.first()){
                        while (!r.isAfterLast()) {
                            Paziente p = new Paziente(r);
                            
                            htmlPage+="<TR>\n";
                            htmlPage+="<TD>"+"<img src=\"photo/"+p.getPicture()+"\" height=\"50\" width=\"50\" alt=\"Foto Paziente\" /></TD>\n";

View Full Code Here

                    User paziente = loggedUser;
                    dbManager db = new dbManager();
                    ResultSet res = db.getPatientVaccinations(paziente.getId());
                    db.releaseConnection();
                    try{
                        if(res.first()){
                            while(!res.isAfterLast()){
                                int medId = res.getInt("doctor_id");
                                String date = res.getString("vaccination_date");
                                
                                dbManager dbMed = new dbManager();

View Full Code Here

                                dbManager dbMed = new dbManager();
                                ResultSet doctor = dbMed.getDoctor(medId);
                                dbMed.releaseConnection();
                                
                                String doctorName="";
                                if(doctor.first()){
                                    while(!doctor.isAfterLast()){
                                        doctorName = doctor.getString("name")+" "+doctor.getString("surname");
                                        doctor.next();
                                    }
                                }

View Full Code Here

            
            dbManager dbM = new dbManager();
            ResultSet res = dbM.userMatches(usr, psw, isDoc);
            dbM.releaseConnection();
            
            if (res.first()){
                HttpSession session = request.getSession();
                User loggedUser = (User) session.getAttribute("loggedUser");
                if (loggedUser == null){
                    loggedUser = new User(res, isDoc);
                    session.setAttribute("loggedUser", loggedUser);

View Full Code Here

                                htmlPage+="<th>Dr.</th>\n";
                                htmlPage+="<th></th>\n";
                                htmlPage+="<th>ID</th>\n";
                                htmlPage+="</TR>\n";
                                
                        if(r2.first()){
                            while (!r2.isAfterLast()) {
                                htmlPage+="<TR>\n";
                                htmlPage+="<TD>"+r2.getString("vaccination_date")+"</TD>\n";
                                htmlPage+="<TD>"+r2.getString("surname")+"</TD>\n";
                                htmlPage+="<TD>"+r2.getString("name")+"</TD>\n";

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.