java中sql语句执行有错误，但是打印出语句后在sql管理中没有问题

2012-08-01 05:05:27 381 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

GB28181协议心跳机制：从标准解读到代码实现的保活策略本文深入解析GB28181协议中的心跳机制，从标准解读到代码实现，详细介绍了保活策略的核心价值和底层逻辑。通过实战案例和技术要点，帮助开发者优化心跳间隔、超时次数等参数配置，提升安防监控系统的可靠性和性能。文章还提供了代码实现的防坑指南和特殊场景处理建议，适用于各类网络环境下的设备在线状态管理。阅读详情

java中sql语句执行有错误，但是打印出语句后在sql管理中没有问题
java中代码如下：
String sqlview="if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[员工考勤卡号-按最新启用日期]') and OBJECTPROPERTY(id, N'IsView') = 1)"+
"drop view [dbo].[员工考勤卡号-按最新启用日期]" +
"\n"+"GO"+"\n"+
"SET QUOTED_IDENTIFIER ON"+
"\n"+"GO"+"\n"+
"SET ANSI_NULLS ON"+
"\n"+"GO"+"\n"+
"CREATE VIEW dbo.[员工考勤卡号-按最新启用日期]"+"\n"+
" AS "+"\n"+
"SELECT DISTINCT SMT_PersonnelID, SMT_CardSerial, SMT_DateTime, SMT_State"+"\n"+
"FROM dbo.Smart_Card ta"+"\n"+
"WHERE (SMT_DateTime ="+"\n"+
"(SELECT MAX(tb.SMT_DateTime) AS Expr1"+"\n"+
"FROM dbo.Smart_Card AS tb"+"\n"+
"WHERE (tb.SMT_PersonnelID = ta.SMT_PersonnelID)))"+
"\n"+"GO"+"\n"+
"SET QUOTED_IDENTIFIER OFF"+
"\n"+"GO"+"\n"+
"SET ANSI_NULLS ON"+
"\n"+"GO"+"\n"+
；
打印出的语句为：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[员工考勤卡号-按最新启用日期]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[员工考勤卡号-按最新启用日期]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.[员工考勤卡号-按最新启用日期]
AS
SELECT DISTINCT SMT_PersonnelID, SMT_CardSerial, SMT_DateTime, SMT_State
FROM dbo.Smart_Card ta
WHERE (SMT_DateTime =
(SELECT MAX(tb.SMT_DateTime) AS Expr1
FROM dbo.Smart_Card AS tb
WHERE (tb.SMT_PersonnelID = ta.SMT_PersonnelID)))
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

这个打印出来的语句直接复制到sqlserver management中是可以执行的没有问题
但是eclipse中直接报错：com.microsoft.sqlserver.jdbc.SQLServerException: 'GO' 附近有语法错误。

请大家分析下。。。。。。。。。

...全文