/** * Creates a new database prepared statement. This statement will be * automatically released when the dao is released. * * @param sql * The statement to be created. * @return The newly created statement. */ protected PreparedStatement prepareStatement(String sql) { return statementContainer.add(dbCtx.prepareStatement(sql)); }
dbCtx.prepareStatement(nodeBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_NODE))); singleNodeStatement = statementContainer.add( dbCtx.prepareStatement(nodeBuilder.getSqlInsert(1))); bulkNodeTagStatement = statementContainer.add( dbCtx.prepareStatement(nodeTagBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_NODE_TAG))); singleNodeTagStatement = statementContainer.add( dbCtx.prepareStatement(nodeTagBuilder.getSqlInsert(1))); bulkWayStatement = statementContainer.add( dbCtx.prepareStatement(wayBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_WAY))); singleWayStatement = statementContainer.add( dbCtx.prepareStatement(wayBuilder.getSqlInsert(1))); bulkWayTagStatement = statementContainer.add( dbCtx.prepareStatement(wayTagBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_WAY_TAG))); singleWayTagStatement = statementContainer.add( dbCtx.prepareStatement(wayTagBuilder.getSqlInsert(1))); bulkWayNodeStatement = statementContainer.add( dbCtx.prepareStatement(wayNodeBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_WAY_NODE))); singleWayNodeStatement = statementContainer.add( dbCtx.prepareStatement(wayNodeBuilder.getSqlInsert(1))); bulkRelationStatement = statementContainer.add( dbCtx.prepareStatement(relationBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_RELATION))); singleRelationStatement = statementContainer.add( dbCtx.prepareStatement(relationBuilder.getSqlInsert(1))); bulkRelationTagStatement = statementContainer.add( dbCtx.prepareStatement(relationTagBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_RELATION_TAG))); singleRelationTagStatement = statementContainer.add( dbCtx.prepareStatement(relationTagBuilder.getSqlInsert(1))); bulkRelationMemberStatement = statementContainer.add( dbCtx.prepareStatement(relationMemberBuilder.getSqlInsert(INSERT_BULK_ROW_COUNT_RELATION_MEMBER)));
preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_node_list SELECT id FROM nodes WHERE (geom && ?)"); prmIndex = 1; preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_way_list " + "SELECT id FROM ways w where w.linestring && ?" preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_way_list " + "SELECT way_id FROM (" preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_way_list " + "SELECT wn.way_id FROM way_nodes wn INNER JOIN box_node_list n ON wn.node_id = n.id" preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_relation_list (" + "SELECT rm.relation_id AS relation_id FROM relation_members rm" preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_relation_list " + "SELECT rm.relation_id AS relation_id FROM relation_members rm" preparedStatement = dbCtx.prepareStatement( "INSERT INTO box_node_list " + "SELECT wn.node_id AS id FROM way_nodes wn INNER JOIN box_way_list bw ON wn.way_id = bw.id "