Underlying data writing for conditional queries

Source: Internet
Author: User
At the underlying layer of a query written a few days ago, seven parameters, four field parameters, and three paging parameters were used.
A write parameter query is a query that meets the query conditions. In the previous console, the query is performed based on the selected operation.
When writing data layers, you must query them according to the conditions.
When writing parameters for SQL statements, add the following judgment:
If the field is a string:

If (sparam! = NULL & sparam! = "")
Sbmsg. appand ("and database field =" + sparam + "");

If the database field is int type:

If (iparam> 0)
Sbmsg. appand ("and database field =" + iparam + "");

That is to say, during data query, these SQL statements can be executed when the value assigned to the parameter meets these conditions.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.