OA表单重复校验---SQL方法

def bumen = param[0];
def ranliao = param[1];
def date = param[2];
def sqljdbc = "jdbc:sqlserver://IP：端口号;databaseName=OADB";
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?'已有数据':'';

此方式为 SQLSERVER

 有帮助的可以留言。看到会回