dbo.doSearch("select repairLimit,(select nvl(isReport,0) from SYS_RENDERACCOUNT where code='"+userInfo.getUserUnitCode()+"') isReport from sys_parameter where iswork=1",serverName);
dosearch是別人寫的一個方法 意思是 dbo.doSearch("select repairLimit,(select nvl(isReport,0) from SYS_RENDERACCOUNT where code='"+userInfo.getUserUnitCode()+"') isReport from sys_parameter where iswork=1",serverName); ================================== 1.dosearch方法要傳3個參數 最后一個是servername前兩個是根據sql從數據庫里面取出來的 分別是repairlimit和isreportisreport的數據是根據 select nvl(isReport,0) from SYS_RENDERACCOUNT where code='"+userInfo.getUserUnitCode()+"'來取得的需要傳個userinfo.getuserunitcond()的方法獲得的值進去才行
意思是
dbo.doSearch("select repairLimit,(select nvl(isReport,0) from SYS_RENDERACCOUNT where code='"+userInfo.getUserUnitCode()+"') isReport from sys_parameter where iswork=1",serverName);
==================================
1.dosearch方法要傳3個參數
最后一個是servername前兩個是根據sql從數據庫里面取出來的
分別是repairlimit和isreportisreport的數據是根據
select nvl(isReport,0) from SYS_RENDERACCOUNT where code='"+userInfo.getUserUnitCode()+"'來取得的需要傳個userinfo.getuserunitcond()的方法獲得的值進去才行