how can make 1 dynamic query in spring mvc all parameters url? exemple:/example?parameter1=test¶meter2=apple;fruit¶meter3=park
for link want have query that: select * news parameter1 = test , parameter2 = apple , fruits , parameter3 = park
in in same time if have url /example?parameter1=test¶meter2=apple
i don't want create new query in 1 select * news parameter1 = test , parameter2 = apple;
more exactly, how can create dynamic query how change automatic in function of parameters url?
its not idea pass dynamic data query surely cause sql injection attacks.
you can use beanproprowmapper (http://www.mkyong.com/spring/spring-jdbctemplate-querying-examples/) , prepared statement kind of approach (named parameters http://www.studytrails.com/frameworks/spring/spring-jdbc-template-named-params.jsp) in spring jdbc achieve similar typed query. ( java bean getter , setter automatically called, query updated that)
don't write dynamic query ( keep strict typed)
Comments
Post a Comment