daoExecuteQuery

Related DAO Code

        connect();
        String preparedQuery = getQuery(app,queryLabel); ///// Get query from database

        conn.setAutoCommit(false);
        PreparedStatement pst = conn.prepareStatement(preparedQuery);

        if(params != null){ /// add parameters to the query (if any)
            int i=0;
            for(String param : params.keySet())
            {
                pst.setString(++i, params.get(param));
            }
        }

        boolean rs = pst.execute(); /// run query
        conn.setAutoCommit(true);
        
        disconnect();