Shulou(Shulou.com)06/02 Report--

This article mainly explains "how to realize dynamic query of jspXCMS page". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "how to realize dynamic query of jspXCMS page"!

The list page in the background of the system usually has query function, if it is very time-consuming to query by writing sql statement, especially in the case of many query conditions. If the query conditions change, you need to modify the sql statement, which is very troublesome.

Jspxcms uses page dynamic query to solve this problem, directly parsing the name of the query table to generate sql query conditions, as long as the page can be modified to achieve the query, without the need to modify java code and write sql statements.

/WEB-INF/views/plug/resume/resume_list.jsp (simplified):

Name: Position: Start Date: End Date: Search com.jspxcms.plug.domain.Resume;public class Resume { private Integer id; private Site site; private String name; private String post; private Date creationDate; private String gender; private Date birthDate; private String mobile; private String email; ...}

where search_CONTAIN_name search_CONTAIN_post search_GTE_creationDate_Date search_LTE_creationDate is the key content

search_is a prefix that indicates that this input box is used to construct search criteria.

CONTAIN GTE LTE is the query keyword. Equivalent to like >= = 'xxxx-xx-xx' and creationDate.

LT : stands for = in sql.

LTE : stands for sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.