Package dbManagement

Examples of dbManagement.dbManager.releaseConnection()

66
67
68
69
70
71
72
73
74
75
76
           
            //Stampa risultato ricerca
            if(request.getParameter("date")!=null){
                dbManager db = new dbManager();
                ResultSet r = db.getPreviousVaccinationsPatients(new Integer(seconds));
                db.releaseConnection();
                htmlPage += "<div class=\"content\">";
                htmlPage+="<form action=\"Conferma\" method=\"POST\">\n";
                htmlPage+="<p class=\"submit\"><input type=\"submit\" name=\"Conferma\" value=\"Conferma\" /></p>\n";
               
                //Prima riga della tabella
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
                    (LinkedList <Paziente>) request.getSession().getAttribute(arrayName);//recupero i pazienti dalla sessione
           
            HttpSession session = request.getSession();
            dbManager db = new dbManager();
            String date = db.getDBtime();
            db.releaseConnection();
            session.setAttribute("date", date);
            User doctor = (User) request.getSession().getAttribute("loggedUser");//recupero il profilo del medico
           
            String[] patientsList = request.getParameterValues(checkboxname);//recupero gli id passati per POST
           
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
            LinkedList <Paziente> chosenPatients = (LinkedList<Paziente>)session.getAttribute("chosenPatients");
              
            for(Paziente p : chosenPatients){
                dbManager db = new dbManager();
                db.doVaccinate(doctor.getId(),p.getId());
                db.releaseConnection();
            }
           
            String date = (String)request.getSession().getAttribute("date");
            String signature = doctor.getName()+" "+doctor.getSurname();
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
           
            //Stampa risultato ricerca
            if(request.getParameter("date")!=null){
                dbManager db = new dbManager();
                ResultSet r = db.getFollowingVaccinationsPatients(new Integer(seconds));
                db.releaseConnection();
                htmlPage += "<div class=\"content\">";
               
                //Prima riga della tabella
                htmlPage+="<TABLE>\n";
                htmlPage+="<tr>\n";
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
                   
                   
                    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");
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
                                int medId = res.getInt("doctor_id");
                                String date = res.getString("vaccination_date");
                               
                                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");
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
           
            if(request.getParameter("id")!=null){
                dbManager db = new dbManager();
                ResultSet r1 = db.getPatient(new Integer(request.getParameter("id")));
                ResultSet r2 = db.getPatientVaccinations(new Integer(request.getParameter("id")));
                db.releaseConnection();
               
                try {
                  
                htmlPage+=htmlIntro;
                htmlPage += "<div class=\"container\">";
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
                if(psw1.equals(psw2)){
                   
                    try {
                        dbManager db = new dbManager();
                        db.doRegister(usr, psw1);
                        db.releaseConnection();  
                        htmlPage += "Hai completato la registrazione<BR>";
                        htmlPage += "<a href=\"login.jsp\" title=\"login\">Effettua il login</a>";                    
                    } catch (NotInDBException ex) {
                        htmlPage+="Username errato!<BR>\n";
                        htmlPage+="<a href=\"registrati.jsp\" title=\"Registrati\">Torna alla registrazione</a>";
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.