sql进行判断配置校验

1、用sql判断传进来的年龄是否在范围内

select
  case when (age>=18 and age<65) then 1 else 0 end  as age 
 from (select 15 as age from dual)a;

返回0表示不在 1表示在

2、sql判断字段是否为空

select case when age is null then '年龄不能为空' else '' end age，
       case when person_name is null then '姓名不能为空' else '' end person_name

from (

     select '' age, '' person_name from dual
)

 

可以将sql配置进数据库中，值进行动态替换

select case when age is null then '年龄不能为空' else '' end age，
       case when person_name is null then '姓名不能为空' else '' end person_name

from (

     select '${AGE}$' age, '${AGE}$' person_name from dual
)