Check the JDBC driver: https://github.com/neo4j-contrib/neo4j-jdbc/#minimum-viable-snippet
> Am 01.02.2015 um 11:30 schrieb FERHAT Ilyes <[email protected]>: > > hi all > > i'm writing this code in java using a relational database: > > public static int networks_followers_tweets(long id_principal, Twitter t, > int compteur_follower) throws SQLException, InterruptedException { > try { > ResultSet rs; > String sql = "Select id_follower from follower a , comptes b > where a.id_compte =" + id_principal + "and b.tweets_check=0 and > b.id_compte=a.id_follower "; > rs = DataBase.Select(sql); > while (rs.next()) { > long id_follower = rs.getLong(1); > compteur_follower = Get_tweets(id_follower, t, > compteur_follower); > } > } catch (Exception E) { > System.out.println("Message d'erreur network_tweets"); > } > return compteur_follower; > } > > > actually, i want to write the same code but by using a graph database!! i > tried to write the following code but i was totaly lost!! how can i send a > cypher query and then put the result in a variable in order to use it later?!! > i tried to write the following lines but i'm not really sure: > > public static int networks_followers_tweets(long id_principal, Twitter t, int > compteur_follower) throws SQLException, InterruptedException { > try { > URI rs; > String query = "match(a:FOLLOWERS), (b:COMPTES) > where(a.id_compte =" + id_principal + " AND (b.tweets_check=0) AND > (b.id_compte=a.id_follower) return a.id_follower "; > rs = DataBase.sendTransactionalCypherQuery(query); > ....... > > > > > the DataBase classe is like the following: > > public class DataBase { > > private static final String SERVER_ROOT_URI = > "http://localhost:7474/db/data/";; > > > public DataBase() > { > > } > > public static URI sendTransactionalCypherQuery(String query) { > // START SNIPPET: queryAllNodes > final String txUri = SERVER_ROOT_URI + "transaction/commit"; > WebResource resource = Client.create().resource( txUri ); > > String payload = "{\"statements\" : [ {\"statement\" : \"" +query + > "\"} ]}"; > ClientResponse response = resource > .accept( MediaType.APPLICATION_JSON ) > .type( MediaType.APPLICATION_JSON ) > .entity( payload ) > .post( ClientResponse.class ); > > System.out.println( String.format( > "POST [%s] to [%s], status code [%d], returned data: " > + System.getProperty( "line.separator" ) + "%s", > payload, txUri, response.getStatus(), > response.getEntity( String.class ) ) ); > > response.close(); > return response.getLocation() ; > > } > } > > > thank you. > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
