Package com.mysql.jdbc

Examples of com.mysql.jdbc.ResultSet

19
20
21
22
23
24
25
26
27
28
29
    public void releaseConnection(){
        dbConn.closeConnection();
    }
   
    public ResultSet getPatient(int patientID){
        ResultSet res = null;
        try {
            String command;
            command = "SELECT * FROM patients WHERE id = "+ patientID;
            res = dbConn.executeQuery(command);
        } catch (Exception ex) {
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
        }
        return res;
    }

    public ResultSet getDoctor(int doctorID){
        ResultSet res = null;
        try {
            String command;
            command = "SELECT * FROM doctors WHERE id = "+ doctorID;
            res = dbConn.executeQuery(command);
        } catch (Exception ex) {
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
        return res;
    }

   
    public ResultSet getPatientVaccinations(int patientID){
        ResultSet res = null;
        try {
            String command;
            command = "SELECT * FROM (SELECT * FROM vaccinations LEFT JOIN doctors ON id = doctor_id ) AS X "
                    + "WHERE patient_id = " + patientID;
            res = dbConn.executeQuery(command);
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
        }
        return res;
    }

    public ResultSet getDoctorVaccinations(int doctorID) {
        ResultSet res = null;
        try {
            String command;
            command = "SELECT patient_id, vaccination_date FROM vaccinations WHERE doctor_id = " + doctorID;
            ResultSet set1 = dbConn.executeQuery(command);
            command = "SELECT name, surname FROM patients WHERE patient_id = " + set1.getString("patient_id");
            ResultSet set2 = dbConn.executeQuery(command);
            command = "SELECT name, surname, vaccination_date FROM " + set1.getCursorName() + " JOIN " + set2.getCursorName();
            res = dbConn.executeQuery(command);
            return res;
        } catch (SQLException ex) {
            Log4k.error(dbManager.class.getName(), ex.getMessage());
        }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
    public String getDBtime(){
        String res = null;
        try {
            String command = "SELECT NOW() AS N";
            ResultSet set = dbConn.executeQuery(command);
            set.next();
            res = set.getString("N");
        } catch (SQLException ex) {
            Log4k.error(dbManager.class.getName(), ex.getMessage());
        }
        return res;
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
    private String getDBdiffTime(int sec) {
        String res = null;
        try {
            String command = "SELECT NOW() - INTERVAL " + sec + " SECOND AS C";           
            ResultSet set = dbConn.executeQuery(command);
            set.next();
            res = set.getString("C");           
        } catch (SQLException ex) {
            Log4k.error(dbManager.class.getName(), ex.getMessage());
        }
        return res;
    }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
        }
        return res;
    }

    public ResultSet getPreviousVaccinationsPatients(int sec){
        ResultSet res = null;
        try {
            String command;
            /* Select the last vaccination of each vaccinated patient before sec seconds ago */
            String lastVaccinations = "SELECT DISTINCT MAX(vaccination_date) AS 'max', patient_id AS 'pid' FROM vaccinations GROUP BY patient_id";
            String JT1 = "SELECT * " +
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
        }
        return res;
    }
   
    public ResultSet getFollowingVaccinationsPatients(int sec){
        ResultSet res = null;
        try {
            String command;
            String lastVaccinations = "SELECT DISTINCT MAX(vaccination_date) AS 'max', patient_id AS 'pid' FROM vaccinations GROUP BY patient_id";
            String JT1 = "SELECT * " +
                    "FROM patients LEFT JOIN (" + lastVaccinations + ") AS last_vaccinations " +
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
    }
   
    public void doRegister(String username, String new_pwd) throws NotInDBException, YetRegisteredException{
        try {
            String command;
            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
188
189
190
191
192
193
194
195
196
197
198
            Log4k.error(dbManager.class.getName(), ex.getMessage());
        }
    }
   
    public ResultSet userMatches(String userName, String pwd, boolean isDoctor){
        ResultSet res;
        String userKind = ((isDoctor) ? "doctor" : "patient");
        String command = "SELECT * FROM " + userKind + "s WHERE "
                + "username = '" + userName + "' AND "
                + "password = '" + pwd + "' AND "
                + ((isDoctor) ? " TRUE" : "registered");
View Full Code Here
TOP

Related Classes of com.mysql.jdbc.ResultSet

  • com.mysql.jdbc.profiler.ProfilerEvent
  • com.vst.dao.hibernate.ConstructionDefectDaoHibernate
  • com.vst.dao.hibernate.ConstructionExampleDaoHibernate
  • com.vst.dao.hibernate.PipeLineElementDaoImpl
  • core.Login
  • core.Profilo
  • core.Richiamo
  • core.VaccinazioniPaziente
  • core.VisualizzaVaccinazioni
  • dbManagement.dbConnector
    • Copyright © 2018 www.massapicom. 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.