public MutableMap<String, Object> queryForMap(Connection conn, String sql) { return MapAdapter.adapt(this.query(conn, sql, new MapHandler())); }
public MutableMap<String, Object> queryForMap(Connection conn, String sql) { return MapAdapter.adapt(this.query(conn, sql, new MapHandler())); }
/** * 根据sql查询一个map */ public static Map<String, Object> findMap(String sql, Object... params) { Map<String, Object> map; try { logger.debug("Sql:" + sql); logger.debug("Parameters:" + Arrays.toString(params)); map = getQueryRunner().query(getConn(), sql, new MapHandler(), params); } catch (SQLException e) { throw new QueryException(e); } return map; }
private Map<String, Object> executeQuery(String sql, InvokeContext context) { Connection connection = null; try { connection = getConnection(context); QueryRunner qr = new QueryRunner(); Map<String, Object> query = qr.query(connection, sql, new MapHandler()); if (query == null || query.isEmpty()) { query = new LinkedHashMap<>(); LOG.warn("Select Nothing By SQL:{}", sql); } return query; } catch (Exception e) { // } finally { closeClosable(connection); } return new LinkedHashMap<>(); }
public long add() throws Exception{ try { if (buildSql_Insert()) { Map<String, Object> result_insert = new QueryRunner().insert(conn, sql, new MapHandler(), param_data); long id=0; if(null!=result_insert && result_insert.containsKey("GENERATED_KEY")) { id = (long) result_insert.get("GENERATED_KEY"); } D.autoCloseConn(conn); return id; } } catch (Exception e) { D.autoCloseConn(conn); throw e; } return 0; }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<Map<String,Object>> h = new MapHandler(); Map<String,Object> results = h.handle(this.emptyResultSet); assertNull(results); }
public void testHandle() throws SQLException { ResultSetHandler<Map<String,Object>> h = new MapHandler(); Map<String,Object> results = h.handle(this.rs); assertNotNull(results); assertEquals(COLS, results.keySet().size()); assertEquals("1", results.get("ONE")); assertEquals("2", results.get("two")); assertEquals("THREE", results.get("Three")); }