Examples of com.mysql.jdbc.ResultSet

com.mysql.jdbc.ResultSet
A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order.
A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.

The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are numbered from 1.

For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.

For the getXXX methods, the JDBC driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. See the JDBC specification for allowable mappings from SQL types to Java types with the ResultSet getXXX methods.

Column names used as input to getXXX methods are case insenstive. When performing a getXXX using a column name, if several columns have the same name, then the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL Query. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names were used there is no way for the programmer to guarentee that they actually refer to the intended columns.

A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet's columns are provided by the ResultSetMetaData object returned by the getMetaData method.
@author Mark Matthews @version $Id: ResultSet.java 20 2008-01-17 12:47:41Z gnovelli $ @see ResultSetMetaData @see java.sql.ResultSet

            htmlPage += "</div>";  //div header end
            
            //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
                htmlPage+="<TABLE>\n";
                htmlPage+="<tr>\n";
                htmlPage+="<th></th>\n";
                htmlPage+="<th>Nome</th>\n";
                htmlPage+="<th>Cognome</th>\n";
                htmlPage+="<th>M/F</th>\n";
                htmlPage+="<th>Data di vaccinazione</th>\n";
                htmlPage+="<th>Medico</th>\n";
                htmlPage+="<th>Seleziona</th>\n";
                htmlPage+="</tr>\n";
                
                try {
                    
                    if(r.first()){
                        while (!r.isAfterLast()) {
                            
                            Paziente p = new Paziente(r);
                            
                            if (!arrayPazienti.add(p))
                                Log4k.warn(Richiamo.class.getName(), "il paziente non e` stato inserito nel'array");
                            
                            htmlPage+="<TR>\n";
                            htmlPage+="<TD><img src=\"photo/"+p.getPicture()+"\" height=\"50\" width=\"50\" alt=\"Foto Paziente\" /></TD>\n";
                            htmlPage+="<TD>"+p.getName()+"</TD>\n";
                            htmlPage+="<TD>"+p.getSurname()+"</TD\n>";
                            htmlPage+="<TD>"+p.getGender()+"</TD>\n";
                            htmlPage+="<TD>"+p.getVaccination_date()+"</TD>\n";
                            htmlPage+="<TD>"+p.getDoctor_id()+"</TD>\n";
                            htmlPage+="<TD><input type=\"checkbox\" name=\""+checkboxname+"\" value=\""+p.getId()+"\" /></TD>\n";
                            htmlPage+="</TR>\n";
                            r.next();
                        }
                    }
                } catch (SQLException ex) {
                    htmlPage+="</div></div></BODY></HTML>\n";
                    Log4k.error(Richiamo.class.getName(), ex.getMessage());

View Full Code Here

            htmlPage += "</div>";  //div header end
            
            //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";
                htmlPage+="<th></th>\n";
                htmlPage+="<th>Nome e Cognome</th>\n";
                htmlPage+="<th>M/F</th>\n";
                htmlPage+="<th>Data di vaccinazione</th>\n";
                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";
                            htmlPage+="<TD><a href=\"Profilo?id="+p.getId()+"\">"+p.getName()+" "+p.getSurname()+"</a></TD>\n";
                            htmlPage+="<TD>"+p.getGender()+"</TD>\n";
                            htmlPage+="<TD>"+p.getVaccination_date()+"</TD>\n";
                            htmlPage+="<TD>"+p.getDoctor_id()+"</TD>\n";
                            htmlPage+="</TR>\n";
                            r.next();
                        }
                    }
                } catch (SQLException ex) {
                    htmlPage+="</div></div></BODY></HTML>\n";
                    Log4k.error(Richiamo.class.getName(), ex.getMessage());

View Full Code Here

                    ex.getMessage() + "\n\tcommand was " + command);
        }
    }
    
    ResultSet executeQuery(String query){
        ResultSet res = null;
        try {
            Statement statement = (Statement) conn.createStatement();
            res = (ResultSet) statement.executeQuery(query);
            /* we must not close the statement here, otherwise res drops */
        } catch (SQLException ex) {

View Full Code Here

                    htmlPage+="</TR>";
                    
                    
                    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();
                                ResultSet doctor = dbMed.getDoctor(medId);
                                dbMed.releaseConnection();
                                
                                String doctorName="";
                                if(doctor.first()){
                                    while(!doctor.isAfterLast()){
                                        doctorName = doctor.getString("name")+" "+doctor.getString("surname");
                                        doctor.next();
                                    }
                                }
                                
                                htmlPage+="<TR>\n";
                                htmlPage+="<TD>"+doctorName+"</TD>\n";

View Full Code Here

            String usr = request.getParameter("user");
            String psw = request.getParameter("password");
            boolean isDoc = request.getParameter("type").equals("medico");
            
            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

                    + "</HEAD><BODY>";
                String htmlOutro = "</BODY></HTML>";
            
            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\">";
                htmlPage += "<div class=\"header\">";
                                 
                    if(r1!=null && r2!=null){
                        if(r1.first()){
                            User p = new User(r1, false);
                            htmlPage += "<img id=\"welcomeImage\" src=\"" + Macro.BASE + "photo/"+p.getPicture()+"\" />";
                            htmlPage += "<p class=\"headerInfo\">Paziente: "+p.getName()+" "+p.getSurname()+"</p>";
                            htmlPage += "<p class=\"headerInfo\">Data di nascita: "+p.getBirthdate()+"<br />";
                            htmlPage += "Sesso: "+p.getGender()+"</p>";
                            htmlPage += "<p class=\"headerInfo\"><a href=\"" + Macro.BASE + "\" title=\"Home\">Torna alla Home</a></p>\n";
                        }
                        
                    htmlPage += "</div>";  //div header end
                    htmlPage += "<div class=\"content\">";
                    htmlPage+="<TABLE>\n";
                                htmlPage+="<TR>\n";
                                htmlPage+="<th>Data di Vaccinazione</th>\n";
                                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";
                                htmlPage+="<TD>"+r2.getString("doctor_id")+"</TD>\n";
                                htmlPage+="</TR>\n";
                                r2.next();
                            }
                            } else {
                                htmlPage+="<TR>\n";
                                htmlPage+="<TD> Mai Vaccinato </TD>\n";
                                htmlPage+="<TD> - </TD>\n";

View Full Code Here


    public List getPipeLineListByObjectInspectionId(Integer id, Properties props) throws SQLException {


        Connection dbConn = getConnection(props);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select * from pipeLineElement where objectId=" + id);
        List plList = setValues(rs);
        rs.close();
        return plList;




    }

View Full Code Here

    public List getPipeLineListByObjectInspectionAndDetailType(Integer typeId, Integer objectId, Properties props) throws SQLException {




        Connection dbConn = getConnection(props);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select * from pipeLineElement where objectId=" + objectId + " and detailTypeId=" + typeId);
        List plList = setValues(rs);
        rs.close();


        return plList;
    }

View Full Code Here

    public List getConstructionDefectZonesByConstrType(String typeId,  String buildingObjectId,Properties props) throws SQLException {




        Connection dbConn = getConnection(props);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select constructionDefectsZone.constructionDefectId from constructionExamples, constructionDefectsZone where constructionExamples.buildObjectId="+buildingObjectId+" and constructionExamples.exampleId=constructionDefectsZone.exampleId and constructionDefectsZone.constructionTypeId="+typeId+" group by uniqueForExamples");
        List plList = setValues(rs);
        rs.close();


        return plList;
    }

View Full Code Here

    }


    public List getExamplesByDefect(String unique,Properties properties) throws SQLException {
        Connection dbConn = getConnection(properties);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select exampleId from constructionDefectsZone where uniqueForExamples="+unique);
        List list=new ArrayList();
        while (rs.next()) {
              list.add(rs.getString(1));
        }
        rs.close();
        return list;
    }

View Full Code Here

0 1 2

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

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.