UC知道Java JDBC拼串 我在等待....
来源：百度知道 编辑：UC知道 时间：2024/06/02 02:00:16
这是SQL原语句:
exec proc_transMoney_cardInfo_in
@cardID='1010 3576 8295 9544',@transMoney=1.0032,@remark=''
我现在需要把这几个参数放进去:
int getinMoney,int cardID1,int cardID2,int cardID3,int cardID4,String getInfo
cardID是我把ID拆成4个Text来接收的.
exec proc_transMoney_cardInfo_in
@cardID='1010 3576 8295 9544',@transMoney=1.0032,@remark=''
我现在需要把这几个参数放进去:
int getinMoney,int cardID1,int cardID2,int cardID3,int cardID4,String getInfo
cardID是我把ID拆成4个Text来接收的.
String sql = "exec proc_transMoney_cardInfo_in @cardID='"+getCardID1+"+' '+"+getCardID2+"+' '+"+getCardID3+"+' '+"+getCardID4+"',@transMoney='"+transMoney+"',@remark='"+getInfo+"'";
String sql;
sql = "exec proc_transMoney_cardInfo_in " +
"@cardID='" + cardID1 + " " + cardID2 + " " + cardID3 + " " + cardID4 +
"',@transMoney=" + getinMoney + ",@remark='" + getInfo + "'";