代码拉取完成,页面将自动刷新
从mssql获取数据时,如果有字段名为关键字如:convert,则会报错,能否在生成的语句中字段名加上括号[]
非常感谢!
下面是异常信息:
PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY DlyOrder) AS SQLSERVER_ROW_ID, * FROM (SELECT BillType, DlyOrder, Vchcode, Vchtype, BranchId, AtypeId, BtypeId, EtypeId, KtypeId, Dtypeid, PtypeId, Qty, Discount, DiscountPrice, VipCardId, VipDiscount, CostPrice, CostTotal, RetailPrice, Price, Total, Date, Period, Tax, TaxPrice, TaxTotal, Tax_Total, DiscountTotal, CostMode, Unit, ToQty, IsOver, ColorId, IfSupply, Convert, BargainTotal, SaleTrait, PackCode, PackRate, PackQty, Comment, RowOrderNew, RowOrder, CustValue1, CustValue2, CustValue3, CustValue4, CustValue5, CustValue6, OpID, UnitRate, SingleUnit, Phrows, NtfQty, BackQty, Tax_Price, DUQty FROM dbo.BakDlyOrder) S) A WHERE A.SQLSERVER_ROW_ID BETWEEN ? AND ?]; SQL state [S0001]; error code [102]; ',' 附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有语法错误。