关于SQLServerException: '' 附近有语法错误。的问题

2015-12-05 02:42:43 1.5k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

android 运动目标检测_MindSpore应用案例：AI对篮球运动员目标的检测 MindSpore作为一个端边云协同的开源的全场景AI框架，今年3月份开源以来，受到了业界的广泛关注和应用，欢迎大家参与开源贡献、模型众智合作、行业创新与应用、学术合作等，贡献您在云侧、端侧 (HiMindSpore 应用程序)、边侧以及安全领域的应用案例。MindSpore与您在AI领域共同成长，让AI使能千行百业，释放出强大的生产力。本文讲述的是MindSpore对篮球运动员目标的检测应用，通... 阅读详情

我导出了段脚本，在sqlserver里面执行没有问题，但在代码里面执行就提示

，实在找不到，求救个位大神帮我看看，，
代码：
SQLExec sqlExec = new SQLExec();

// 设置数据库参数
sqlExec.setDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver");
sqlExec.setUrl(Tools.getCommonProp("Dbconnection") + ";DatabaseName=" + dbname);
sqlExec.setUserid(Tools.getCommonProp("Dbuser"));
sqlExec.setPassword(Tools.getCommonProp("Dbpwd"));
// 要执行的脚本
sqlExec.setSrc(new File(path));
// 有出错的语句该如何处理
sqlExec.setOnerror((SQLExec.OnError)(EnumeratedAttribute.getInstance(SQLExec.OnError.class, "abort")));

sqlExec.setPrint(false); // 设置是否输出
// 输出到文件 sql.out 中；不设置该属性，默认输出到控制台
//sqlExec.setOutput(new File("sql/sql.out"));
sqlExec.setProject(new Project()); // 要指定这个属性，不然会出错
sqlExec.execute();

sql脚本：

SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[picinfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[picinfo](
[id] [varchar](36) NOT NULL,
[piccode] [varchar](50) NULL,
[picpath] [varchar](5000) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_PICINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AreaInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AreaInfo](
[id] [varchar](36) NOT NULL,
[areacode] [varchar](50) NULL,
[areaname] [varchar](50) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_AREAINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BaseItemInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BaseItemInfo](
[id] [varchar](36) NOT NULL,
[goodname] [varchar](50) NULL,
[standardid] [varchar](36) NULL,
[barcode] [varchar](100) NULL,
[varietyid] [varchar](36) NULL,
[unitid] [varchar](36) NULL,
[producingarea] [varchar](500) NULL,
[produceddate] [datetime] NULL,
[expirationdate] [int] NULL,
[goodpicid] [varchar](36) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_BASEITEMINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BillDetailInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BillDetailInfo](
[id] [varchar](36) NOT NULL,
[goodsid] [varchar](36) NULL,
[articledescription] [decimal](18, 0) NULL,
[totalrent] [decimal](18, 0) NULL,
[count] [int] NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_BILLDETAILINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BillInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BillInfo](
[id] [varchar](36) NOT NULL,
[billno] [varchar](50) NULL,
[toid] [varchar](36) NULL,
[fromid] [varchar](36) NULL,
[billstatus] [int] NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[billdetailid] [varchar](36) NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_BILLINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClienteleInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClienteleInfo](
[id] [varchar](36) NOT NULL,
[clienteleno] [varchar](50) NULL,
[clientelename] [varchar](100) NULL,
[areaid] [varchar](36) NULL,
[contacts] [varchar](50) NULL,
[telphoneno] [varchar](50) NULL,
[varietyid] [varchar](36) NULL,
[address] [varchar](500) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[reamrk] [varchar](500) NULL,
CONSTRAINT [PK_CLIENTELEINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ItemVariety]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ItemVariety](
[id] [varchar](36) NOT NULL,
[varietyname] [varchar](50) NULL,
[varietycode] [varchar](100) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[remark] [varchar](500) NULL,
CONSTRAINT [PK_ITEMVARIETY] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MerchantInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[MerchantInfo](
[id] [varchar](36) NOT NULL,
[merchantNo] [varchar](50) NULL,
[merchantname] [varchar](100) NULL,
[areaid] [varchar](36) NULL,
[contacts] [varchar](50) NULL,
[telphoneno] [varchar](50) NULL,
[varietyid] [varchar](36) NULL,
[address] [varchar](500) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[reamrk] [varchar](500) NULL,
CONSTRAINT [PK_MERCHANTINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StandardInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[StandardInfo](
[id] [varchar](36) NOT NULL,
[standardcode] [varchar](50) NULL,
[standardname] [varchar](100) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[reamark] [varchar](500) NULL,
CONSTRAINT [PK_STANDARDINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
;
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UnitInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[UnitInfo](
[id] [varchar](36) NOT NULL,
[unitname] [varchar](50) NULL,
[createdate] [datetime] NULL,
[modifydate] [datetime] NULL,
[reamrk] [varchar](500) NULL,
CONSTRAINT [PK_UNITINFO] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

...全文