当前位置: 技术问答>java相关
请问Java可否调用MsSQL的存储过程,如何调用?
来源: 互联网 发布时间:2015-02-01
本文导语: | 給一個我調的給你看看: Connection conn = null; Statement stmt = null; String[][] strReturn = null; conn = DataConnection.getConnection("lh.order.server.dba.report.ordershipmentweekly.DBA_OrderShipmentWeekly.dealWithData()", ...
|
給一個我調的給你看看:
Connection conn = null;
Statement stmt = null;
String[][] strReturn = null;
conn = DataConnection.getConnection("lh.order.server.dba.report.ordershipmentweekly.DBA_OrderShipmentWeekly.dealWithData()",
dbInfo);
stmt = conn.createStatement();
String strDateCon = GClass.getFieldCompareStr(args[2], args[3],"TRANS_DATE", 1);
String strCustomerNoCon = GClass.getFieldCompareStr(args[0], args[1],"TYPE_NO", 1);
String strSaleBillCon = GClass.getFieldCompareStr(args[4], args[5],"TYPE_NO", 1);
String strSql = " exec ordershipmentweekly "
+ GClass.getSqlString(strCompId)+","
+ GClass.getSqlString(strDateCon) + ","
+ GClass.getSqlString(strCustomerNoCon) + ","
+ GClass.getSqlString(strSaleBillCon) + ","
+ GClass.getSqlString(args[6]) + ","
+ GClass.getSqlString(args[7]);
stmt.execute(strSql);
ResultSet reset = stmt.getResultSet();
if(reset==null||!reset.last())
return strReturn;
int nRows = reset.getRow();
int nMasterColumns = COL_AMOUNT;
strReturn = new String[nRows][nMasterColumns];
reset.beforeFirst();
int nIndex = 0;
while(reset.next())
{
for(int i = 0;i
Connection conn = null;
Statement stmt = null;
String[][] strReturn = null;
conn = DataConnection.getConnection("lh.order.server.dba.report.ordershipmentweekly.DBA_OrderShipmentWeekly.dealWithData()",
dbInfo);
stmt = conn.createStatement();
String strDateCon = GClass.getFieldCompareStr(args[2], args[3],"TRANS_DATE", 1);
String strCustomerNoCon = GClass.getFieldCompareStr(args[0], args[1],"TYPE_NO", 1);
String strSaleBillCon = GClass.getFieldCompareStr(args[4], args[5],"TYPE_NO", 1);
String strSql = " exec ordershipmentweekly "
+ GClass.getSqlString(strCompId)+","
+ GClass.getSqlString(strDateCon) + ","
+ GClass.getSqlString(strCustomerNoCon) + ","
+ GClass.getSqlString(strSaleBillCon) + ","
+ GClass.getSqlString(args[6]) + ","
+ GClass.getSqlString(args[7]);
stmt.execute(strSql);
ResultSet reset = stmt.getResultSet();
if(reset==null||!reset.last())
return strReturn;
int nRows = reset.getRow();
int nMasterColumns = COL_AMOUNT;
strReturn = new String[nRows][nMasterColumns];
reset.beforeFirst();
int nIndex = 0;
while(reset.next())
{
for(int i = 0;i
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。
站内导航:
特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!