OA通过自定义函数，调用数据库，并返回对应的值

def bumen = param[0];
def ranliao = param[1];
def date = param[2];
def sqljdbc = "jdbc:sqlserver://IP:端口;databaseName=库";
def sqluser = "用户名";
def sqlpwd = "密码";
def sqldriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
def sqlStr = "select id from formmain_0788 WHERE field0001 IN (SELECT id FroM CTP_ENUM_ITEM WHERE  showvalue='${bumen}') AND field0006 IN (SELECT id FroM CTP_ENUM_ITEM WHERE  showvalue='${ranliao}') AND field0002='${date}' AND finishedflag<>0";
def findResult = groovy.sql.Sql.newInstance(sqljdbc,sqluser,sqlpwd,sqldriver).withCloseable {sql -> return sql.firstRow(sqlStr)};
return findResult ? findResult.toString() : '';

sqlstr= 所要查询表的值