Paramerized SPARQL Query

[rana abaalkhail <ra...@hotmail.com>]

Hi

I want to code a parameterized SPARQL Query in Java Jena where one of the triple in query be injected

so in the code below I need to inject value as a string the pass to the class


However, the SPARQL query is correct so when I replace "value" with the class name I got the right result

I tried two code non of them worked No result  or run time error


the first code:



package ontology;







import org.apache.jena.iri.impl.Main;



import com.hp.hpl.jena.query.ParameterizedSparqlString;

import com.hp.hpl.jena.query.Query;

import com.hp.hpl.jena.query.QueryExecution;

import com.hp.hpl.jena.query.QueryExecutionFactory;

import com.hp.hpl.jena.query.QueryFactory;

import com.hp.hpl.jena.query.QuerySolution;

import com.hp.hpl.jena.query.ResultSet;

import com.hp.hpl.jena.rdf.model.Model;

import com.hp.hpl.jena.util.FileManager;



public class SPARQL {









        public static void sparqlTest( String str)

        {



FileManager.get().addLocatorClassLoader(Main.class.getClassLoader());

       Model model=FileManager.get().loadModel("ASO.owl");







       String queryString=



                     "PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>"+

                     "PREFIX rdf:< http://www.w3.org/1999/02/22-rdf-syntax-ns#>"+

                     "PREFIX HASO:< http://www.semanticweb.org/rabaa006/ontologies/2014/4/HASO#>"+





"SELECT  ?x  "+

              "WHERE"+

"      {?x rdfs:subClassOf  HASO:Affective_State}";





       ParameterizedSparqlString queryStr = new ParameterizedSparqlString(queryString);

       queryStr.setLiteral("value", str);



Query  query=QueryFactory.create(queryStr.toString());



QueryExecution qexec = QueryExecutionFactory.create(query,model);





try {



       ResultSet results = qexec.execSelect();





       while ( results.hasNext()){



              QuerySolution soln = results.nextSolution();

              String strg=soln.getResource("?x").toString();

              //System.out.println(strg);

                String number = strg.substring(strg.lastIndexOf("#") + 1);

                System.out.println(number);



       }}

finally{



qexec.close();}





}



}



The Second code:


package ontology;







import org.apache.jena.iri.impl.Main;



import com.hp.hpl.jena.query.ParameterizedSparqlString;

import com.hp.hpl.jena.query.Query;

import com.hp.hpl.jena.query.QueryExecution;

import com.hp.hpl.jena.query.QueryExecutionFactory;

import com.hp.hpl.jena.query.QueryFactory;

import com.hp.hpl.jena.query.QuerySolution;

import com.hp.hpl.jena.query.ResultSet;

import com.hp.hpl.jena.rdf.model.Model;

import com.hp.hpl.jena.util.FileManager;



public class SPARQL {









        public static void sparqlTest( String str)

        {



FileManager.get().addLocatorClassLoader(Main.class.getClassLoader());

       Model model=FileManager.get().loadModel("ASO.owl");







       ParameterizedSparqlString pss = new ParameterizedSparqlString();

       pss.setCommandText (

                           "PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>"+

                           "PREFIX rdf:< http://www.w3.org/1999/02/22-rdf-syntax-ns#>"+

                           "PREFIX HASO:< http://www.semanticweb.org/rabaa006/ontologies/2014/4/HASO#>"+





       "SELECT  ?x  "+

                     "WHERE"+

       "      {?x rdfs:subClassOf  HASO:valuee}");

       pss.setLiteral("value", str);







Query  query=QueryFactory.create(pss.toString());





       QueryExecution qexec = QueryExecutionFactory.create(query,model);





try {



       ResultSet results = qexec.execSelect();





       while ( results.hasNext()){



              QuerySolution soln = results.nextSolution();

              String strg=soln.getResource("?x").toString();

              //System.out.println(strg);

                String number = strg.substring(strg.lastIndexOf("#") + 1);

                System.out.println(number);



       }}

finally{



qexec.close();}





}



}