User Management System_Multi-conditional User Query Requirements!!!!!

Pu Zhibin · Posted on 3/27/2019 1:39:31 PM

Multi-conditional user query interface1. Basic information of the interface

parameter

value

remark

Interface address/tourBackManager?methodName=searchBackUser根据条件查询后台用户
Request methodpost
Submission methodAsynchronous commits2. Request parameter description【Request Parameters】

Parameter name

type

Whether it is necessary

illustrate

departmentStringN department
numStringN project number
usernameStringN username
phoneStringN phone number
emailStringN email

Successful inquiry:

[{
  "user_id":1,
  "department":"commodity department",
  "num":84383,
  "username":"Wang Dammer ",
  "password":"123321
  "phone":"188617954",
  "email":"10058995296@qq.com",
},{
  "user_id":2,
  "department":"sales department",
  "num":84383,
  "username":"Zhang Qiling",
  "password":"123321
  "phone":"188617954",
  "email":"10058995296@qq.com",
}]

Query failed:

{
"flag":false,
"errorMsg": "This user does not exist"
}

Bosses, tell me about your ideas!

Little scum · Posted on 3/27/2019 5:10:40 PM

I don't understand what you mean

You bring all the parameters of the post to judge whether the key has a value, and if there is, splice it

string sql="select * from user where 1=1"

Determine whether the username has a value, if there is, sql+="and username = "+value

If there is an ORM, there is no need to splice SQL, of course, it is unreasonable to splicing SQL in this way

[JavaEE] User Management System_Multi-conditional User Query Requirements!!!!!

Sections viewed