java - SpringMVC, MySQL dynamic query -


how can make 1 dynamic query in spring mvc all parameters url? exemple:/example?parameter1=test&parameter2=apple;fruit&parameter3=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&parameter2=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