将变量插入SQL数据库
本文关键字:数据库 SQL 插入 变量 | 更新日期: 2023-09-27 18:30:12
我是Web服务和SQL的新手。我开发了一个插入SQL数据库的Web服务。下面是我的代码。
public class balanceEnquiry : System.Web.Services.WebService
{
[WebMethod(MessageName = "CheckBalance")]//To Check Balance......
[System.Web.Services.Protocols.SoapDocumentMethodAttribute(Action = "CheckBalance", RequestNamespace = "http://www.zain.com/", ResponseNamespace = "http://www.zain.com/", Use = System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
public string CheckBalance(string AccountNumber, string msisdn, string pin)
{
ValidationAPIClient client = new ValidationAPIClient();
//validate sub by pin
//fetch MAI by msisdn
//validate pin
我想将用户输入的msisdn插入到我的数据库中。而且合作伙伴API对我的Web服务的响应如下
return validateAccountResultItem.responseExtraData;
我想在我的数据库中插入2。我将如何撰写插入声明。以下是我一直在做的
cmd.CommandText = string.Format("INSERT INTO MSSG(REFERENCE_ID, TIMESTAMP, DEST_MSISDN, MESSAGE, TYPE, HOSTIP) VALUES ('1234567890', SYSDATE,'91976707759','TESTMESSAGE','0',(SELECT HOSTIP FROM SMPP_TRANSMITTER WHERE STATUS = 1 AND ROWNUM = 1))");
我不希望对DEST_MISDN和MESSAGE列进行硬编码,而是希望它们分别是用户和validateAccountResultItem.responseExtraData输入的字符串。
cmd.CommandText = string.Format("INSERT INTO MSSG(REFERENCE_ID, TIMESTAMP, DEST_MSISDN, MESSAGE, TYPE, HOSTIP) VALUES ('1234567890', SYSDATE,@DEST_MSISDN,@MESSAGE,'0',(SELECT HOSTIP FROM SMPP_TRANSMITTER WHERE STATUS = 1 AND ROWNUM = 1))");
String destMsisdn, message;
//**todo** here, retrieve user input in those two variables
cmd.Parameters.AddWithValue("@DEST_MSISDN", destMsisdn);
cmd.Parameters.AddWithValue("@MESSAGE", message);