DatabaseTool.java

Go to the documentation of this file.

package edu.tum.cs.util.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;

public class DatabaseTool {
        public static HashMap<String,String> resultSetRow2HashMap(ResultSet rs) throws Exception {
                HashMap<String,String> hm = new HashMap<String,String>();
                boolean erroneous = false;
                try {                   
                        ResultSetMetaData rsmd = rs.getMetaData();
                        int numCols = rsmd.getColumnCount();                    
                        if(rs.next()) {                         
                                for(int i = 1; i <= numCols; i++) {
                                        String val = rs.getString(i);
                                        if(val == null)
                                                erroneous = true;
                                        hm.put(rsmd.getColumnName(i), val);
                                }
                        }
                        else
                                return null;
                }
                catch(SQLException e) {
                        e.printStackTrace();
                }
                if(erroneous)
                        throw new Exception("Result set contains null entry!");
                return hm;
        }

        public static String queryResult(Connection conn, String query) throws SQLException {
                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery(query);
                rs.next();
                return rs.getString(1);
        }
}

---

mod_vis
Author(s): Moritz Tenorth, Jakob Engel
autogenerated on Fri Jan 11 09:54:14 2013