T_SQL-查詢條件語法 - 春羽閣- 點部落
T_SQL-查詢條件語法 String sql ="select * from 資料表"; sql+ = "where 1=1 "; //where 條件恆成立 if (條件欄位!= null && 條件欄位 != "") sql += "and company_id='" + conditionCompanyID+"'"; if... String sql = "select cell_phone,backup_mail,apply ......