java中调用存储过程的另类写法

 存储过程

CREATE   PROCEDURE  p_wapClickLog_cq 
@mid   varchar ( 20 ),
@miscid   varchar ( 20 ),
@ua   varchar ( 200 ),
@clientip   varchar ( 20 ),
@mobile   varchar ( 20 ),
@mobileip   varchar ( 20 )

  AS
declare   @flag   int
set   @flag = 0

if   not   exists  ( select   *   from  clickLog_cq  where  mobile = @mobile   and   datediff ( day ,addtime, getdate ()) = 0  ) 
begin
     insert   into  clickLog_cq(misc_mid,miscid,ua,clientip,mobile,mobileip,addtime)    values ( @mid , @miscid , @ua , @clientip , @mobile , @mobileip , getdate ())
     set   @flag   =   1
end

select   @flag
GO

java 代码

StringBuffer sendsql  =   new  StringBuffer( " exec p_wapClickLog_cq' " );
            sendsql.append(mid);
            sendsql.append( " ',' " );
            sendsql.append(miscid);
            sendsql.append( " ',' " );
            sendsql.append(ua);
            sendsql.append( " ',' " );
            sendsql.append(clientip);
            sendsql.append( " ',' " );
            sendsql.append(mobile);
            sendsql.append( " ',' " );
            sendsql.append(mobileIp);
            sendsql.append( " ' " );
                
            com.chinesewap.common.dao.CommonDao cd  =   new  com.chinesewap.common.dao.CommonDao( " dbname " );
             try   ... {
                    cd.exeuteQuery(sendsql.toString());
                    if (cd.rs.next()) ...{
                        isFlag = cd.rs.getInt(1);
                    }
                    else...{
                        isFlag = 0;
                    }
            }
             catch  (Exception ex)  ... {
                ex.printStackTrace();
            }
            cd.clear();

这里flag 相当于输出参数