用asp怎么对表每个记录里面的价格进行求和？_course

name字段 价格字段 id aaa 1420 1 aaa 1200 2 aaa 1000 3 aaa 1800 4 我怎么用ASP对上面的4条记录进行把那个价格字段给求和相加起来？请赐代码……急

ASP查询结果求和，请赐教 _course

SQL数据库中有两张表，表A 和表B ，表A 有两列数据A1 和A2, 表B有两列数据B1 和B2,如下所示： 表A 表B A1 A2 B1 B2 5 6 15 20 4 4 20 30 查询输出到表

ASP 数据库求和_course

先看一个这个数据库结构 表1 bianhao shourujine youxiao bianhao是自动编号 shourujine和youxiao是文本 <% exec="select sum(sho

部分重复记录求和_course

表A，Feild有B1/B2/B3/B4/B5,共有2000条记录， 当其中某些N条记录B1＝B1，B2＝B2时，合并这些记录，即求SUM（B3）、SUM（B4），B5虽然不同，但赋值成N个B5之字串

一条sql语句，把重复记录的字段的值相加_course

access表，把重复记录的字段的值相加。 当姓名、年级、学校三个字段相同时，把缴费记录、欠费金额 的值相加。地址保留其中一个值就可以了 姓名 年级 学校 地址 缴费记录 欠费金额 小明 一 一小 广

安装SQL Server2017时安装到数据库引擎、SQL客户端连接、SQL客户端连接SDK报错_course

之前有安装过SQL Server 2017，但是出现了点错误又卸载了。 第二次安装SQL Server 2017时安装到数据库引擎、SQL客户端连接、SQL客户端连接SDK报错 安装日志的Summary日志为下图 Detailed results: Feature: 数据库引擎服务 Status: 失败 Reason for failure: 该功能的某个依赖项出错，导致该功能的安装过程失败。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server Native Client 访问组件 Component error code: -2147483648 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20181019_230201\sqlncli_Cpu64_1.log Error description: 以前的某个安装需要重新引导计算机以便使更改生效。若要继续，请重新启动计算机，然后再次运行安装程序。 Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sqlncli.msi%40CA_ErrorPendingReboot%40-2147483648 Feature: SQL Browser Status: 已通过 Feature: SQL 编写器 Status: 已通过 Feature: SQL 客户端连接 Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server Native Client 访问组件 Component error code: -2147483648 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20181019_230201\sqlncli_Cpu64_1.log Error description: 以前的某个安装需要重新引导计算机以便使更改生效。若要继续，请重新启动计算机，然后再次运行安装程序。 Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sqlncli.msi%40CA_ErrorPendingReboot%40-2147483648 Feature: SQL 客户端连接 SDK Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server Native Client 访问组件 Component error code: -2147483648 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20181019_230201\sqlncli_Cpu64_1.log Error description: 以前的某个安装需要重新引导计算机以便使更改生效。若要继续，请重新启动计算机，然后再次运行安装程序。 Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sqlncli.msi%40CA_ErrorPendingReboot%40-2147483648

centos7 使用安装了 Microsoft ODBC Driver 13 for SQL Server 驱动后，使用sqlcmd连接不上sqlserver。_course

 提示的信息截图，其实不单单是13 ,安装了17 也是提示这个信息。不知道 是什么原因，Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection because an error was encountered during handshakes before login. sqlserver:是window 2008R sqlserver服务器防火墙已经关闭。 关于sqlserver自己是新手，自己觉的是哪块配置没弄明白。希望大神帮帮搞定。感激不尽~ 我的qq:3294364783 ，请加详细聊。必有感谢。。

sql语句报错，解决不了，请大神看看啊 。。。急急急。。_course

非常着急 请大神速速看看，万分感谢。。 我的sql语句 ``` <update id="updateByPrimaryKeySelective" parameterType="java.util.List"> <foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";"> update TSM_CAS_R001 <set > <if test="item.casNo != null"> cas_no = #{item.casNo,jdbcType=VARCHAR}, </if> <if test="item.chDic != null"> ch_dic = #{item.chDic,jdbcType=VARCHAR}, </if> <if test="item.cSeqid != null"> c_seqid = #{item.cSeqid,jdbcType=VARCHAR}, </if> <if test="item.srNo != null"> sr_no = #{item.srNo,jdbcType=VARCHAR}, </if> <if test="item.casArbegdtime != null"> cas_arbegdtime = #{item.casArbegdtime,jdbcType=VARCHAR}, </if> <if test="item.casArenddtime != null"> cas_arenddtime = #{item.casArenddtime,jdbcType=VARCHAR}, </if> <if test="item.casArintime != null"> cas_arintime = #{item.casArintime,jdbcType=VARCHAR}, </if> <if test="item.casArouttime != null"> cas_arouttime = #{item.casArouttime,jdbcType=VARCHAR}, </if> <if test="item.casNcarouttime != null"> cas_ncarouttime = #{item.casNcarouttime,jdbcType=DECIMAL}, </if> <if test="item.casSmsartime != null"> cas_smsartime = #{item.casSmsartime,jdbcType=VARCHAR}, </if> <if test="item.casOnldartime != null"> cas_onldartime = #{item.casOnldartime,jdbcType=VARCHAR}, </if> <if test="item.casCastmp1 != null"> cas_castmp1 = #{item.casCastmp1,jdbcType=DECIMAL}, </if> <if test="item.casCastmp1time != null"> cas_castmp1time = #{item.casCastmp1time,jdbcType=VARCHAR}, </if> <if test="item.casCastmp2 != null"> cas_castmp2 = #{item.casCastmp2,jdbcType=DECIMAL}, </if> <if test="item.casCastmp2time != null"> cas_castmp2time = #{item.casCastmp2time,jdbcType=VARCHAR}, </if> <if test="item.casCastmp3 != null"> cas_castmp3 = #{item.casCastmp3,jdbcType=DECIMAL}, </if> <if test="item.casCastmp3time != null"> cas_castmp3time = #{item.casCastmp3time,jdbcType=VARCHAR}, </if> <if test="item.casArmaxwgt != null"> cas_armaxwgt = #{item.casArmaxwgt,jdbcType=DECIMAL}, </if> <if test="item.casArminwgt != null"> cas_arminwgt = #{item.casArminwgt,jdbcType=DECIMAL}, </if> <if test="item.casAravgwgt != null"> cas_aravgwgt = #{item.casAravgwgt,jdbcType=DECIMAL}, </if> <if test="item.casArmaxpres != null"> cas_armaxpres = #{item.casArmaxpres,jdbcType=DECIMAL}, </if> <if test="item.casArminpres != null"> cas_arminpres = #{item.casArminpres,jdbcType=DECIMAL}, </if> <if test="item.casAravgpres != null"> cas_aravgpres = #{item.casAravgpres,jdbcType=DECIMAL}, </if> <if test="item.casArvtmp != null"> cas_arvtmp = #{item.casArvtmp,jdbcType=DECIMAL}, </if> <if test="item.casDeptmp != null"> cas_deptmp = #{item.casDeptmp,jdbcType=DECIMAL}, </if> <if test="item.casQmessage != null"> cas_qmessage = #{item.casQmessage,jdbcType=VARCHAR}, </if> <if test="item.casQtime != null"> cas_qtime = #{item.casQtime,jdbcType=VARCHAR}, </if> <if test="item.casTimedf != null"> cas_timedf = #{item.casTimedf,jdbcType=VARCHAR}, </if> <if test="item.casAttdate != null"> cas_attdate = #{item.casAttdate,jdbcType=VARCHAR}, </if> <if test="item.casAccdate != null"> cas_accdate = #{item.casAccdate,jdbcType=VARCHAR}, </if> <if test="item.wkGroup != null"> wk_group = #{item.wkGroup,jdbcType=VARCHAR}, </if> <if test="item.wkShift != null"> wk_shift = #{item.wkShift,jdbcType=VARCHAR}, </if> <if test="item.cCreater != null"> c_creater = #{item.cCreater,jdbcType=VARCHAR}, </if> <if test="item.dCreatedate != null"> d_createdate = #{item.dCreatedate,jdbcType=VARCHAR}, </if> <if test="item.delFlag != null"> del_flag = #{item.delFlag,jdbcType=VARCHAR}, </if> <if test="item.cTimestamp != null"> c_timestamp = #{item.cTimestamp,jdbcType=TIMESTAMP}, </if> <if test="item.cSw01 != null"> c_sw01 = #{item.cSw01,jdbcType=VARCHAR}, </if> <if test="item.cSw02 != null"> c_sw02 = #{item.cSw02,jdbcType=VARCHAR}, </if> <if test="item.cSw03 != null"> c_sw03 = #{item.cSw03,jdbcType=VARCHAR}, </if> <if test="item.cSw04 != null"> c_sw04 = #{item.cSw04,jdbcType=VARCHAR}, </if> <if test="item.cSw05 != null"> c_sw05 = #{item.cSw05,jdbcType=VARCHAR}, </if> <if test="item.cSw06 != null"> c_sw06 = #{item.cSw06,jdbcType=VARCHAR}, </if> <if test="item.cSw07 != null"> c_sw07 = #{item.cSw07,jdbcType=VARCHAR}, </if> <if test="item.cSw08 != null"> c_sw08 = #{item.cSw08,jdbcType=VARCHAR}, </if> <if test="item.cSw09 != null"> c_sw09 = #{item.cSw09,jdbcType=VARCHAR}, </if> <if test="item.cSw10 != null"> c_sw10 = #{item.cSw10,jdbcType=VARCHAR}, </if> <if test="item.cSw11 != null"> c_sw11 = #{item.cSw11,jdbcType=VARCHAR}, </if> <if test="item.cSw12 != null"> c_sw12 = #{item.cSw12,jdbcType=VARCHAR}, </if> <if test="item.cSw13 != null"> c_sw13 = #{item.cSw13,jdbcType=VARCHAR}, </if> <if test="item.cSw14 != null"> c_sw14 = #{item.cSw14,jdbcType=VARCHAR}, </if> <if test="item.cSw15 != null"> c_sw15 = #{item.cSw15,jdbcType=VARCHAR}, </if> <if test="item.cStirstate != null"> c_stirstate = #{item.cStirstate,jdbcType=VARCHAR}, </if> </set> where sk_no = #{item.skNo,jdbcType=VARCHAR} </foreach> </update> ``` 报的异常如下： SEVERE: Servlet.service() for servlet [MES] in context with path [/MES] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLException: ORA-06550: 第 4 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 2 行, 第 5 列: PL/SQL: SQL Statement ignored ORA-06550: 第 8 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 6 行, 第 5 列: PL/SQL: SQL Statement ignored ### The error may involve td.young.smp.sm.bof.dao.TSM_CAS_R001Mapper.updateByPrimaryKeySelective-Inline ### The error occurred while setting parameters ### SQL: begin update TSM_CAS_R001 where sk_no = ? ; update TSM_CAS_R001 where sk_no = ? ;end; ### Cause: java.sql.SQLException: ORA-06550: 第 4 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 2 行, 第 5 列: PL/SQL: SQL Statement ignored ORA-06550: 第 8 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 6 行, 第 5 列: PL/SQL: SQL Statement ignored ; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-06550: 第 4 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 2 行, 第 5 列: PL/SQL: SQL Statement ignored ORA-06550: 第 8 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 6 行, 第 5 列: PL/SQL: SQL Statement ignored ] with root cause java.sql.SQLException: ORA-06550: 第 4 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 2 行, 第 5 列: PL/SQL: SQL Statement ignored ORA-06550: 第 8 行, 第 7 列: PL/SQL: ORA-00971: 缺失 SET 关键字 ORA-06550: 第 6 行, 第 5 列: PL/SQL: SQL Statement ignored 这是怎么回事？请大神看看。。我解决了半天感觉是一点问题没有啊？问什么老是报 这个异常呢？实在是解决不了啊。。。

请问下面的sql怎么拼接成一句sql_course

set @i = -1; set @sql = repeat(" select 1 union all",-datediff('2021-01-01','2030-12-31')+1); set @sql = left(@sql,length(@sql)-length(" union all")); set @sql = concat("select date_add('2021-01-01',interval @i:=@i+1 day) as date from (",@sql,") as tmp"); prepare stmt from @sql; execute stmt 比如说我想拼接成这个样子，怎么拼接啊 select * from (select date_add('2012-09-01',interval @i:=@i+1 day) as date from ( select 1 union all select 1 union all select 1 union all select 1 union all select 1) as tmp, (select @i:= -1) t) a

SQL server 2008R2配置服务器下SQL server服务远程过程调用失败_course

win7系统，之前下过SQL server更高的版本，环境稍微有点变化就用不了，太糟心就卸了。 这次因为需要用sql,小心翼翼用Windows install clean up清理了一下，安装好后还是用不了。 打开配置管理器，SQL server 服务下只有远程过程调用失败。 各种查，试过找到的几种方法，比如删除Microsoft SQL server 2012 Express LocalDB。 可是我在装之前把所有和SQL有关的东西都删了，不管是2012还是2014或者2016， 都找不到LocalDB这种文件。 实在找不到问题在哪了，但是我又急需SQL,心好累……TAT…… 有大佬能帮帮我吗？

access数据查询列出不重复项_course

access有张表:test 字段： ID B 以下为数据 1 k 1 o 3 k 3 p 现需要查询出ID=1和ID=3时去掉字段B重复的数据的结果： 1 o 3 p 去掉了： 1 k 3 k 请问

如何能让asp 把相同字段求和？_course

能否只写一条select语句，并且尽量减少代码的循环次数

springboot集成mybatis在日志中打印完整的sql语句(sql中不带有问号的那种)_course

我创建了一个springboot项目，集成了mybatis，和logback，可以打印日志也有sql，如下图：  这个打印的sql里带有问号，下面是对应的参数，但我不想要这种的sql，我想要完整的sql，就是把下面的参数填到对应的问号中去，这样只要把sql复制下来就可以执行在数据库中运行的那种，有没有办法，各位大佬

安装sql server2012出现问题_course

有关调用实时(JIT)调试而不是此对话框的详细信息， 请参见此消息的结尾。 ************** 异常文本 ************** System.Configuration.ConfigurationErrorsException: 创建 userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings 的配置节处理程序时出错: 未能加载文件或程序集“System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”或它的某一个依赖项。系统找不到指定的文件。 (C:\Users\海\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0\user.config line 5) ---> System.IO.FileNotFoundException: 未能加载文件或程序集“System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”或它的某一个依赖项。系统找不到指定的文件。 文件名:“System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089” 在 System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError) 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) 在 System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory..ctor(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) 在 System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord) 在 System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere) 警告: 程序集绑定日志记录被关闭。 要启用程序集绑定失败日志记录，请将注册表值 [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD)设置为 1。 注意: 会有一些与程序集绑定失败日志记录关联的性能损失。 要关闭此功能，请移除注册表值 [HKLM\Software\Microsoft\Fusion!EnableLog]。 --- 内部异常堆栈跟踪的结尾 --- 在 System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere) 在 System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) 在 System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission) 在 System.Configuration.BaseConfigurationRecord.GetSection(String configKey) 在 System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName) 在 System.Configuration.ConfigurationManager.GetSection(String sectionName) 在 System.Configuration.ClientSettingsStore.ReadSettings(String sectionName, Boolean isUserScoped) 在 System.Configuration.LocalFileSettingsProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties) 在 System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) 在 System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) 在 System.Configuration.SettingsBase.get_Item(String propertyName) 在 System.Configuration.ApplicationSettingsBase.GetPropertyValue(String propertyName) 在 System.Configuration.ApplicationSettingsBase.get_Item(String propertyName) 在 Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings.get_WindowPlacement() 在 Microsoft.SqlServer.Configuration.LandingPage.LandingPageForm.OnLoad(EventArgs e) 在 System.Windows.Forms.Form.OnCreateControl() 在 System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) 在 System.Windows.Forms.Control.CreateControl() 在 System.Windows.Forms.Control.WmShowWindow(Message& m) 在 System.Windows.Forms.Control.WndProc(Message& m) 在 System.Windows.Forms.ScrollableControl.WndProc(Message& m) 在 System.Windows.Forms.ContainerControl.WndProc(Message& m) 在 System.Windows.Forms.Form.WmShowWindow(Message& m) 在 System.Windows.Forms.Form.WndProc(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) 在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) 在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** 已加载的程序集 ************** mscorlib 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6413 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- mscorlib.resources 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6413 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- LandingPage 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/LandingPage.exe ---------------------------------------- System.Windows.Forms 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6402 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6401 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6401 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Microsoft.SqlServer.Configuration.Sco 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/Microsoft.SqlServer.Configuration.Sco.DLL ---------------------------------------- LandingPage.resources 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/zh-CHS/LandingPage.resources.DLL ---------------------------------------- Microsoft.SqlServer.Chainer.Infrastructure 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/Microsoft.SqlServer.Chainer.Infrastructure.DLL ---------------------------------------- Microsoft.SqlServer.Deployment 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/Microsoft.SqlServer.Deployment.DLL ---------------------------------------- System.Xml 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6411 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- Accessibility 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6387 (Win8RTM.050727-6300) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- Microsoft.SqlServer.Management.Controls 程序集版本: 11.0.0.0 Win32 版本: 11.0.2100.60 ((SQL11_RTM).120210-1846 ) 基本代码: file:///D:/TDDOWNLOAD/cn_sql_server_2012_standard_edition_x86_x64_dvd_813404/x86/Microsoft.SqlServer.Management.Controls.DLL ---------------------------------------- System.Configuration 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6411 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- system.configuration.resources 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6400 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration.resources/2.0.0.0_zh-CHS_b03f5f7f11d50a3a/System.Configuration.resources.dll ---------------------------------------- System.Windows.Forms.resources 程序集版本: 2.0.0.0 Win32 版本: 2.0.50727.6400 (Win8RTMGDR.050727-6400) 基本代码: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_zh-CHS_b77a5c561934e089/System.Windows.Forms.resources.dll ---------------------------------------- ************** JIT 调试 ************** 要启用实时(JIT)调试， 该应用程序或计算机的 .config 文件(machine.config)的 system.windows.forms 节中必须设置 jitDebugging 值。 编译应用程序时还必须启用 调试。 例如: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> 启用 JIT 调试后，任何无法处理的异常 都将被发送到在此计算机上注册的 JIT 调试器， 而不是由此对话框处理。

oracle mybatis一次执行多条sql，提示SQL命令未正确结束_course

每条sql结尾带分号就报同样错误，单条sql的也是，不单是insert，该问题不针对insert ``` ### The error occurred while setting parameters ### SQL: alter session force parallel query parallel 8;select * from c_tbtranslateconfig where intdel=0;alter session disable parallel query; ### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束 mybaits: mybatis-spring-boot-starter:1.3.2 oracle驱动包：com.oracle.ojdbc6:11.2.0.4 ```

Navicat连接SqlServer数据库失败？_course

原来安装过SqlServer，后来不用卸载了，然后一直连接远程数据库的SqlServer使用（Navicat连接）。 昨天在本地安装之后，通过SqlServer management studio可以连接，但是Navicat连接报错，求助是什么问题？  [通过SqlServer studio连接正常]  [通过Navicat连接SqlServer报错] [连接MySQL正常] [08001] [Microsoft][SQL Server Native Client 11.0]Registry information is corrupt or missing. Make sure the provider is installed andregistered correctly. (27) [08001] [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection (27) [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured toallow remote connections. For more information see SQL Server Books Online. (0)

关于oracle中的SQL语句转化为sqlserver中的SQl语句的问题 _course

select * from (select rownum as r,t.* from                                (select emp.* from emp order by hiredate desc) t where rownum<=10)                                         where r>5; 谁能把这句话转化为sql server中可以运行的sql语句

SQL2000，无法远程访问SQL2008数据库问题_course

1、我的SQL2008,远程端口是1433 2、在SQL2008的服务器上，可以通过“192.168.1.2\SQL2008”或者域名“XXX.XX.XXX”直接连接数据库，都能成功连接； 3、在服务器的局域网上，用SQL2000查询分析器，可以通过“192.168.1.2\SQL2008”成功连接，但是通过域名“XXX.XX.XXX”就是不能连接成功，提示：“服务器消息14 级别16 状态1，无效的连接”； 4、在互联网的另一端，用SQL2000查询分析器，远程连接这个SQL2008服务器，通过域名“XXX.XX.XXX”连接提示“服务器消息14 级别16 状态1，无效的连接”；通过实例名“XXX.XX.XXX\sql2008”连接，“提示服务器消息17 级别16 状态1，不存在或访问被拒绝” 我的问题是，目前我的设置存在哪些问题，应该如何设置，可以实现SQL2000远程访问SQL2008数据库。

关于不能重新安装SQLServer2017_course

上午安装了sqlserver2017，完全正常，脑子一抽删除了介质文件不能用了，之后不管怎么安装都安装不了，网上搜的各种方法，清理注册表，删除sql文件夹什么的都试过了，再安装总是显示无效的命令行参数，搞了一天还没搞好头都大了，问下有没有大神懂怎么完全清除sqlserver和旧实例啊 ``` Overall summary: Final result: 失败: 请查看下面的详细信息 Exit code (Decimal): -2068052377 Start time: 2019-07-12 17:01:23 End time: 2019-07-12 17:02:01 Requested action: Install Setup completed with required actions for features. Troubleshooting information for those features: Next step for SQLEngine: 使用以下信息解决错误，然后再次尝试运行安装过程。 Machine Properties: Machine name: LEIDIO Machine processor count: 8 OS version: Microsoft Windows 10 专业版 (10.0.18362) OS service pack: OS region: 中国 OS language: 中文(中国) OS architecture: x64 Process architecture: 64 位 OS clustered: 否 Product features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Configured Package properties: Description: Microsoft SQL Server 2017 ProductName: SQL Server 2017 Type: RTM Version: 14 SPLevel: 0 Installation location: D:\SQLServer2017Media\Developer_CHS\x64\setup\ Installation edition: Developer Product Update Status: 用户已选择不包括产品更新。 用户输入设置: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT Service\SQLSERVERAGENT AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: TABULAR ASSVCACCOUNT: <空> ASSVCPASSWORD: <空> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: <空> ASTELSVCACCT: <空> ASTELSVCPASSWORD: <空> ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <空> CLTRESULTDIR: <空> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <空> CLTSVCPASSWORD: <空> CLTWORKINGDIR: <空> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190712_170122\ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <空> CTLRSVCPASSWORD: <空> CTLRUSERS: <空> ENABLERANU: false ENU: false EXTSVCACCOUNT: <空> EXTSVCPASSWORD: <空> FEATURES: SQLENGINE FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <空> FTSVCACCOUNT: <空> FTSVCPASSWORD: <空> HELP: false IACCEPTPYTHONLICENSETERMS: false IACCEPTROPENLICENSETERMS: false IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS: true INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <空> INSTANCEDIR: D:\SQLServer2017 INSTANCEID: MSSQLSERVER INSTANCENAME: MSSQLSERVER ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service ISMASTERSVCPASSWORD: <空> ISMASTERSVCPORT: 8391 ISMASTERSVCSSLCERTCN: <空> ISMASTERSVCSTARTUPTYPE: Automatic ISMASTERSVCTHUMBPRINT: <空> ISSVCACCOUNT: NT AUTHORITY\Network Service ISSVCPASSWORD: <空> ISSVCSTARTUPTYPE: Automatic ISTELSVCACCT: <空> ISTELSVCPASSWORD: <空> ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service ISWORKERSVCCERT: <空> ISWORKERSVCMASTER: <空> ISWORKERSVCPASSWORD: <空> ISWORKERSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: <空> MATRIXNAME: <空> MRCACHEDIRECTORY: NPENABLED: 0 PBDMSSVCACCOUNT: <空> PBDMSSVCPASSWORD: <空> PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT: <空> PBENGSVCPASSWORD: <空> PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE: <空> PBSCALEOUT: false PID: ***** QUIET: true QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT: <空> RSSVCPASSWORD: <空> RSSVCSTARTUPTYPE: Automatic SAPWD: <空> SECURITYMODE: <空> SQLBACKUPDIR: <空> SQLCOLLATION: Chinese_PRC_CI_AS SQLSVCACCOUNT: NT Service\MSSQLSERVER SQLSVCINSTANTFILEINIT: true SQLSVCPASSWORD: <空> SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: LEIDIO\0yang SQLTELSVCACCT: NT Service\SQLTELEMETRY SQLTELSVCPASSWORD: <空> SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR: <空> SQLTEMPDBFILECOUNT: 8 SQLTEMPDBFILEGROWTH: 64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR: <空> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE: 8 SQLUSERDBDIR: <空> SQLUSERDBLOGDIR: <空> SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: false UpdateSource: MU USEMICROSOFTUPDATE: false X86: false Configuration file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190712_170122\ConfigurationFile.ini Detailed results: Feature: 数据库引擎服务 Status: 失败 Reason for failure: 在此功能的安装过程中出错。 Next Step: 使用以下信息解决错误，然后再次尝试运行安装过程。 Component name: SQL Server 数据库引擎服务实例功能 Component error code: 1639 Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190712_170122\sql_engine_core_inst_Cpu64_1.log Error description: 无效的命令行参数。有关详细的命令行帮助，请查阅 Windows Installer 的 SDK。 Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639 Feature: SQL Browser Status: 已通过 Feature: SQL 编写器 Status: 已通过 Feature: SQL 客户端连接 Status: 已通过 Feature: SQL 客户端连接 SDK Status: 已通过 Feature: 安装程序支持文件 Status: 已通过 Rules with failures: Global rules: Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190712_170122\SystemConfigurationCheck_Report.htm ```

SQL语句怎么写成存储过程_course

StringBuilder strSql = new StringBuilder(); StringBuilder strsql2005 = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); StringBuilder sqlwhere = new StringBuilder(); sqlcount.Append("select count(1) "); sqlwhere.Append(" SELECT C.XMMC AS XBMC,A.SFZH,A.LXDH,H.LXRDH,H.YLJGBH, ");//需要查询的列 if (strLX == "4" || strLX == "5") { sqlwhere.Append(" H.HXDABH,H.JTCYBH,H.DCZ,H.DCRQ,H.CJRQ,H.CJRBH,H.CJR,A.MZBH, YLJGMC,A.GRDABH,A.XM,A.CSNYR,A.JMJKDAH,A.DAZT,H.XXDZ,A.CZLX,Z.XMMC+'-'+W.XMMC AS CZMC,H.SFHG ,X.QZSJ,AZ.JBMC,H.JKJDZT ");//,T.ZZDAH ");//需要查询的列 X.QZSJ,AZ.JBMC } else { sqlwhere.Append(" H.HXDABH,H.JTCYBH,H.DCZ,H.DCRQ,H.CJRQ,H.CJRBH,H.CJR,A.MZBH, YLJGMC,A.GRDABH,A.XM,A.CSNYR,A.JMJKDAH,A.DAZT,H.XXDZ,A.CZLX,Z.XMMC+'-'+W.XMMC AS CZMC,H.SFHG,A.CSNYR as QZSJ,A.XM as JBMC,H.JKJDZT ");//,T.ZZDAH "); } sqlwhere.Append(" FROM JMDA_HXDA_JBQK H with(nolock) JOIN JMDA_JTCY A with(nolock) ON A.JTCYBH = H.JTCYBH "); sqlwhere.Append(" INNER JOIN SKJBXX_SJZDMX C with(nolock) ON C.FLBH = 'S101-01' AND A.XB = C.XMBH "); sqlwhere.Append(" INNER JOIN SKJBXX_YLJG JG with(nolock) ON JG.YLJGBH=H.YLJGBH ");//社康基本信息_医疗机构表 sqlwhere.Append(" LEFT JOIN SKJBXX_SJZDMX Z with(nolock) ON Z.FLBH = 'JTCY_CZLX' AND A.CZLX =Z.XMBH "); sqlwhere.Append("LEFT JOIN SKJBXX_SJZDMX W with(nolock) ON W.FLBH='JTCY_CZHK' AND A.CZHK=W.XMBH"); if (strLX == "3") { sqlwhere.Append(" LEFT join FNWCQBJ_JBQK F with(nolock) ON A.JTCYBH = F.JMJKDAH And F.DQZT='0' "); } else if (strLX == "4" || strLX == "5") { sqlwhere.Append(" LEFT JOIN MBGL_JBQKB M with(nolock) ON A.JTCYBH = M.JTCYBH AND M.DAZT='1' "); sqlwhere.Append(" LEFT JOIN MBGL_JWS X with(nolock) ON M.MBDAH=X.MBDAH "); sqlwhere.Append("LEFT JOIN SKJBXX_JBXXB AS AZ with(nolock) ON X.JBBH=AZ.JBBH "); } else if (strLX == "6") { sqlwhere.Append(" LEFT JOIN JSB_JBQK J with(nolock) ON A.JTCYBH = J.JTCYBH AND J.DAZT='1' "); } sqlwhere.Append(" WHERE 1=1 ");//档案状态 if (SFZH != "") { sqlwhere.Append(" AND A.SFZH = @SFZH "); } else { if (strJMJKDAH != "")//当个人档案编号不为空时，只根据这个来查询。 { sqlwhere.Append(" AND A.GRDABH=@GRDABH "); } else { if (lag == "0") { sqlwhere.Append(" AND A.YLJGID = @YLJGBH "); if (YHBH != "") { sqlwhere.Append(" AND H.CJRBH = @CJRBH "); } } else if (lag == "1") { sqlwhere.Append(" AND A.YLJGID LIKE @YLJGBH "); } else if (lag == "2") { } if (strXM != "") { sqlwhere.Append(" AND A.XM like @XM "); } if (BeginDate != Convert.ToDateTime("9999-12-31") && EndDate != Convert.ToDateTime("9999-12-31")) { sqlwhere.Append(" AND H.DCRQ >= @FCJRQ AND H.DCRQ <= @TCJRQ"); } if (CSRQ != Convert.ToDateTime("9999-12-31")) { sqlwhere.Append(" AND A.CSNYR >= @CSNYR "); } if (CSRQE != Convert.ToDateTime("9999-12-31")) { sqlwhere.Append(" AND A.CSNYR <= @CSNYRE "); } if (strXb != "") { sqlwhere.Append(" AND A.XB = @XB "); } if (strHJDZ != null && strHJDZ != "") { sqlwhere.Append(" AND H.XXDZ like @HJDZ "); } if (strXZQ != "") { sqlwhere.Append(" AND A.XZQBH like @XZQ"); } if (strGZDW != "") { sqlwhere.Append(" and H.GZDW = @strGZDW"); } if (CZLX != "0" && CZLX != "") { sqlwhere.Append(" and A.CZLX = @CZLX"); } if (CZHK != "0" && CZHK!="") { if (CZHK == "1") sqlwhere.Append(" and A.CZHK='1'"); else sqlwhere.Append(" and A.CZHK='0'"); } } sqlwhere.Append(" AND A.DAZT = 1 "); switch (strLX) { case "1": sqlwhere.Append(" and datediff(Year,A.CSNYR ,getdate())>=0 and datediff(Year,A.CSNYR ,getdate())<=6 "); //0-6岁儿童档案查询 条件 break; case "2": sqlwhere.Append(" and datediff(Year,A.CSNYR ,getdate())>=65 ");//65岁以上老年人档案查询 条件 break; case "3": sqlwhere.Append(" and F.BJSCBH != '' ");//孕产妇查询条件 break; case "4": sqlwhere.Append(" and X.JBBH='1' "); //慢病高血压 查询条件 break; case "5": sqlwhere.Append(" and X.JBBH='2' ");//慢病糖尿病查询条件 break; case "6": sqlwhere.Append(" and J.JSBDABH!='' ");//重性精神病查询条件 break; default: break; } } sqlwhere.Append(" AND A.DAZT = 1 "); strSql.Append(sqlwhere.ToString()); if (strPX == "1") { strSql.Append(" ORDER BY H.CJRQ DESC,A.XM asc "); } else if (strPX == "2") { strSql.Append(" ORDER BY A.GRDABH DESC "); } else if (strPX == "3") { strSql.Append(" ORDER BY csnyr asc "); } SqlParameter[] parameters = { new SqlParameter("@GRDABH", SqlDbType.VarChar,20), //居民健康档案号 new SqlParameter("@YLJGBH", SqlDbType.VarChar,12), //医疗机构号 new SqlParameter("@XM", SqlDbType.VarChar,40),//姓名 new SqlParameter("@CSNYR", SqlDbType.DateTime),//出生日期 new SqlParameter("@CSNYRE", SqlDbType.DateTime),//出生日期搜索结束时间 new SqlParameter("@FCJRQ", SqlDbType.DateTime),//起始日期 new SqlParameter("@TCJRQ", SqlDbType.DateTime),//结束日期 new SqlParameter("@CJRBH", SqlDbType.VarChar,20),//用户编号 new SqlParameter("@SFZH", SqlDbType.VarChar, 20), //身份证号 new SqlParameter("@HJDZ", SqlDbType.VarChar,100),//详细地址 new SqlParameter("@XZQ",SqlDbType.VarChar,10),//行政区 new SqlParameter("@strGZDW",SqlDbType.VarChar,60), //工作单位 new SqlParameter("@XB",SqlDbType.VarChar,10),//性别 new SqlParameter("@CZLX",SqlDbType.Char,1), //户籍类型 new SqlParameter("@PageIndex",SqlDbType.Int,4), new SqlParameter("@PageSize",SqlDbType.Int ,4) }; parameters[0].Value = strJMJKDAH; //居民健康档案号 if (lag == "1") { parameters[1].Value = strYLJGBH + "%";//医疗机构号 } else { parameters[1].Value = strYLJGBH;//医疗机构号 } parameters[2].Value = strXM + "%"; //姓名 parameters[3].Value = CSRQ;//出生日期 parameters[4].Value = CSRQE;//出生日期搜索结束时间 parameters[5].Value = BeginDate; //起始日期 parameters[6].Value = EndDate;//结束日期 parameters[7].Value = YHBH;//用户编号 parameters[8].Value = SFZH;//身份证号码 parameters[9].Value = "%" + strHJDZ + "%";//详细地址 parameters[10].Value = strXZQ + "%"; parameters[11].Value = strGZDW; //工作单位 parameters[12].Value = strXb; parameters[13].Value = CZLX; //户籍类型 parameters[14].Value = PageIndex; parameters[15].Value = PageSize; strsql2005.Append(sqlwhere.ToString()); sqlcount.Append(sqlwhere.ToString()); object intcount = DbHelperSQL.GetSingle(sqlcount.ToString(), parameters); if (intcount == null) RecordCount = 0; else RecordCount = int.Parse(intcount.ToString()); return DbHelperSQL.Query(strSql.ToString(), PageSize, PageIndex, parameters);

sql server无法连接服务器，sql server网络配置里面没有任何协议_course

sql server无法连接服务器，sql server网络配置里面没有任何协议，该如何解决，才能连接上服务器？ 之前装的2008版的就是这样，百度看有人说2012版的会带协议的，就又装了2012版的，然而还是不能解决 

jdbc连接SQL server连不上_course

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1195) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at javaapplication3.JavaApplication3.JDBCon(JavaApplication3.java:27) at javaapplication3.JavaApplication3.main(JavaApplication3.java:18)

application.yml 配置sqlserver出错_course

<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>sqljdbc4</artifactId> </dependency> application.yml 配置 datasource: driver-class-name: com.**microsoft.sqlserver.jdbc.SQLServerDriver** url: jdbc:sqlserver://localhost:1433;DatabaseName=KEM username: sa password: ErpUiot7890 问题： driver-class-name: com.**microsoft.sqlserver.jdbc.SQLServerDriver** com.后面飘红。 请大神解决下

java的sql预处理语句问题_course

我的sql语句如下,如果把第一个占位符换成具体的列名,则正常,如下则返回空值,请问哪里出问题? ``` sql="select * from fruit where ?=? order by fruit_id"; rs=executeQuery(sql, new Object[]{column,keyword}); ``` 被调用的方法代码如下 ``` public ResultSet executeQuery(String sql,Object...params) throws SQLException{ pstmt=connection.prepareStatement(sql); if(null!=params){ for(int i=0;i<params.length;i++){ pstmt.setObject(i+1, params[i]); } } return pstmt.executeQuery(); } ```

尝试写了一个 JDBC 操作 SQLServer 的工具类，但是好像有问题，求大神帮忙指正_course

java新人，尝试写了一个 JDBC 操作 SQLServer 的工具类，但是好像有问题，调用 insert 指令没问题，而 select 指令出现如下报错： com.microsoft.sqlserver.jdbc.SQLServerException: ')' 附近有语法错误。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616) at com.javaee.servletxm.comm.MSSQLJDBC.select(MSSQLJDBC.java:160) at com.javaee.servletxm.comm.MSSQLJDBC.select(MSSQLJDBC.java:195) at com.javaee.servletxm.comm.MSSQLJDBC.selectFirstValue(MSSQLJDBC.java:172) at com.javaee.servletxm.comm.MSSQLJDBC.getPageNumber(MSSQLJDBC.java:221) at com.javaee.servletxm.comm.MSSQLJDBC.selectByFY(MSSQLJDBC.java:259) at com.javaee.servletxm.kqgl.KqManager.getAllKqxx(KqManager.java:38) at com.javaee.servletxm.kqgl.Kqwh.doGet(Kqwh.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1760) at java.lang.Thread.run(Thread.java:724) 这是具体的代码，求大神帮忙指正 package com.javaee.servletxm.comm; /** * jdbc下 SQL Server 2005 数据库的封装类 */ import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.List; import java.util.Properties; public class MSSQLJDBC { // 配置文件名称 private String iniFileName = MSSQLJDBC.class.getClassLoader().getResource("/com/javaee/servletxm/comm").getPath()+ "mssql.properties"; // 连接数据库 private String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private String url = "jdbc:sqlserver://localhost;DatabaseName=jdms"; private String user = "sa"; private String password = ""; // 定义连接属性 private Connection connect = null; // 与连接有关三个通道 private Statement stmt = null; private PreparedStatement pstmt = null; private CallableStatement cstmt = null; public static final String stmtType = "stmt"; public static final String pstmtType = "pstmt"; public static final String cstmtType = "cstmt"; // 定义参数类型的静态常量值 public static final String varCharType = "varchar"; public static final String intType = "int"; public static final String doubleType = "decimal"; public static final String dateType = "datetime"; public static final String timeType = "timestamp"; // 定义全局的结果集 private ResultSet rs = null; // 在构造方法中对属性进行初始化赋值操作 public MSSQLJDBC() { // 读取配置文件 readIni(); // 初始化连接 initConnect(); } // 可配置文件 .properties // 读取配置文件 private void readIni() { File file = new File(iniFileName); if (!file.exists()) { // 创建一个文件 try { file.createNewFile(); } catch (IOException e) { e.printStackTrace(); } } // 判断文件是否有值 if (file.length() == 0) {// 说明是一个空文件 // 初始化值 try { Properties p = new Properties(); p.put("driver", driver); p.put("url", url); p.put("user", user); p.put("password", password); FileOutputStream fos = new FileOutputStream(file); p.store(fos, "配置文件信息"); fos.close(); } catch (IOException e) { e.printStackTrace(); } } else {// 如果有值 // 将信息读取出来 try { FileInputStream fis = new FileInputStream(file); Properties p = new Properties(); p.load(fis); this.driver = p.getProperty("driver"); this.url = p.getProperty("url"); this.user = p.getProperty("user"); this.password = p.getProperty("password"); fis.close(); } catch (IOException e) { e.printStackTrace(); } } } // 建立连接 private void initConnect() { try { Class.forName(driver); this.connect = DriverManager.getConnection(url, user, password); this.connect.setAutoCommit(false);// 设置手动提交事务 this.stmt = connect.createStatement(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } /*/ 从tomcat缓冲池获取连接 private void initConnectFromDataSource() { try { InitialContext ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/oracleds"); this.connect = ds.getConnection(); this.connect.setAutoCommit(false); this.stmt = connect.createStatement(); } catch (NamingException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } }*/ // 需要调用者控制事务的两个方法 // 提交方法 private void commit() { try { this.connect.commit(); } catch (SQLException e) { e.printStackTrace(); } } // 回滚事务 private void rollBack() { try { this.connect.rollback(); } catch (SQLException e) { e.printStackTrace(); } } // 定义一组与操作有关的方法 // 使用普通通道执行的select public ResultSet select(String sql) { ResultSet prs = null; if (stmt != null) { try { prs = stmt.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } } return prs; } // 根据传入的sql直接获取单一值 // 使用此方法的时候sql语句返回的单一的值 public String selectFirstValue(String sql, String type, List<String> csList) { String rstr = ""; rs = select(sql, type, csList);// 确定此结果集只有一条记录 if (rs != null) {// 说明结果集有值，且只有一条记录 try { ResultSetMetaData rsmd = rs.getMetaData(); if (rs.next()) { // 移动到第一条记录 String p_type = rsmd.getColumnTypeName(1); rstr = getResultSetValue(rs, 1, p_type); } } catch (SQLException e) { e.printStackTrace(); } } return rstr; } // 使用普通通道执行的select /** * sql 参数 type 使用通道的类型 stmt pstmt cstmt List<String> csList 预编通道执行的参数队列 * String 最少必须满足如下条件的字符串 数据类型 ,数据值 数据类型定义说明 字符串 数字（整数、小数） 日期（DATE、TIMESTAMP） */ public ResultSet select(String sql, String type, List<String> csList) { ResultSet prs = null; if (type.equals(stmtType)) {// 说明使用普通通道来执行 prs = select(sql); } else if (type.equals(pstmtType)) {// 说明使用预编译通道来执行 if (connect != null) { try { pstmt = connect.prepareStatement(sql); // 验证传入的参数和sql中的参数个数一致 setPrepareStatement(pstmt, csList);// 将参数设置进当前的预编译通道 prs = pstmt.executeQuery(); } catch (Exception e) { e.printStackTrace(); } } } return prs; } // 获取 总页数 public int getPageNumber(String sql, String type, List<String> csList, int pageSize) { // 处理总页数 int pageNumber = 0; // 第一步获取sql总记录数 String psql = "select count(*) from (" + sql + ")"; String result = selectFirstValue(psql, type, csList); int rows = 0; if (result != null && result.trim() != "") { rows = Integer.valueOf(result); } if (rows % pageSize == 0) { pageNumber = rows / pageSize; } else { pageNumber = rows / pageSize + 1; } return pageNumber; } /** * 自动添加分页查询方法 * * @param sql * 要执行的sql * @param type * 执行方式 * @param csList * 参数列表 * @param curPage * 当前页数 * @param pageSize * 每页记录数 默认为10 * @return */ public ResultSet selectByFY(String sql, String type, List<String> csList, int curPage, int pageSize) { ResultSet prs = null; // 处理 每页记录数 if (pageSize <= 0) { pageSize = 10;// 默认页面10条记录 } int pageNumber = getPageNumber(sql, type, csList, pageSize); // 处理当前页数 if (curPage < 0) { curPage = 1;// 默认第一页 } if (curPage > pageNumber) { curPage = pageNumber; } String psql = "select tmpaa.* from (select tmpa.*,(select (ROW_NUMBER() over (order by id))) as rn from (" + sql + ") tmpa where (select (ROW_NUMBER() over (order by id))) <= " + (curPage * pageSize) + ") tmpaa where tmpaa.rn >= " + ((curPage - 1) * pageSize + 1); prs = select(psql, type, csList); return prs; } // 将预编通道执行的参数队列按照指定规则设置进通道中 private void setPrepareStatement(PreparedStatement p, List<String> csList) throws Exception { if (csList != null && csList.size() > 0) { for (int i = 0; i < csList.size(); i++) { // 此处的str是数据类型 ,数据值 // 解析出数据类型和数据值 String[] s = csList.get(i).split(","); String sType = s[0]; String sData = s[1]; if (varCharType.equals(sType)) { p.setString(i + 1, sData); } else if (intType.equals(sType)) { p.setInt(i + 1, Integer.valueOf(sData)); } else if(doubleType.equals(sType)){ p.setDouble(i+1, Double.valueOf(sData)); } else if (dateType.equals(sType)) { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); java.util.Date d = sdf.parse(sData); p.setDate(i + 1, new Date(d.getTime())); } else if (timeType.equals(sType)) { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); java.util.Date d = sdf.parse(sData); p.setTimestamp(i + 1, new Timestamp(d.getTime())); } } } } // 定义一个执行insert update delete的方法 public int iudSql(String sql) { int ri = -1; if (stmt != null) { try { ri = stmt.executeUpdate(sql); commit(); } catch (SQLException e) { e.printStackTrace(); rollBack(); } } return ri; } public int iudSql(String sql, String type, List<String> csList) { int ri = -1; if (stmtType.equals(type)) { ri = iudSql(sql); } else if (pstmtType.equals(type)) { if (connect != null) { try { pstmt = connect.prepareStatement(sql); setPrepareStatement(pstmt, csList); ri = pstmt.executeUpdate(); commit(); } catch (Exception e) { e.printStackTrace(); rollBack(); } } } return ri; } /** * 编写一个通用的遍历ResultSet结果集的方法 */ public void iteratorResultSet(ResultSet rs) { try { if (rs != null) {// 说明有值 // ResultSetMetaData 此对象里封装了与结果集有关所有信息 // 此结果有几列组成，每列的列名,每列的数据类型 ResultSetMetaData rsmd = rs.getMetaData(); // 得到结果集列数 int columnCount = rsmd.getColumnCount(); // 输出此结果集的所有列名 for (int i = 1; i <= columnCount; i++) { System.out.print(rsmd.getColumnName(i) + "\t"); } System.out.println(""); // 遍历输出所有的数据 while (rs.next()) { // 如何在获取rs中的数据? for (int i = 1; i <= columnCount; i++) { String type = rsmd.getColumnTypeName(i); System.out.print(getResultSetValue(rs, i, type) + "\t"); } System.out.println(""); } } } catch (SQLException e) { e.printStackTrace(); } } // 从ResultSet中根据数据类型来得到数据值的方法 // 先处理常用的sqlserver的数据类型的对应 private String getResultSetValue(ResultSet rs, int index, String type) { String rstr = ""; try { if (rs != null && !"".equals(type) && index > 0) { if ("char".equals(type.trim()) || "varchar".equals(type.trim())) { if (rs.getString(index) != null) { rstr = rs.getString(index); } } else if ("int".equals(type.trim())) { rstr = rs.getInt(index) + ""; } else if ("decimal".equals(type.trim())) { rstr = String.valueOf(rs.getDouble(index)); } else if ("date".equals(type.trim())) { Date date = rs.getDate(index); if (date != null) { rstr = new SimpleDateFormat("yyyy年MM月dd日").format(date); } } else if ("timestamp".equals(type.trim()) || "datetime".equals(type.trim())) { Timestamp tt = rs.getTimestamp(index); if (tt != null) { rstr = new SimpleDateFormat("yyyy年MM月dd日 HH时mm分ss秒").format(tt); } } } } catch (SQLException e) { e.printStackTrace(); } return rstr; } /* //统一事务管理的批量sql的封装 public boolean iudSql(List<String> sqlList){ int ri = -1; if(stmt!=null){ try { ri = stmt.executeUpdate(sql); commit(); } catch (SQLException e) { e.printStackTrace(); rollBack(); } } return ri; }*/ // 关闭连接 public void close() { try { // 关闭所有的与数据库有关的对象 if (rs != null) { rs.close(); rs = null; } if (stmt != null) { stmt.close(); stmt = null; } if (pstmt != null) { pstmt.close(); pstmt = null; } if (cstmt != null) { cstmt.close(); cstmt = null; } if (connect != null) { connect.close(); connect = null; } } catch (SQLException e) { e.printStackTrace(); } } }

mybatis如何通过jdbc连接sqlserver数据库_course

我用的NavicatServer软件 制作的数据库表，并且可以连接上 有ip地址 用户名和密码 在junit测试的时候 报错： **Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 127.0.0.1,1433 的 TCP/IP 连接失败。错误:“null。请验证连接属性。确保 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接，还要确保防火墙没有阻止到此端口的 TCP 连接。”。** 在网上找了很多办法没有解决。 1先是从官网下载了sqlserver的安装包 安装上了 2有下载了jdbc连接sqlserver的驱动包 这样反复几次还是这个报错信息 问题已经解决了：谢谢大家。 只需要更改url上的IP地址和端口号即可。无需在本地安装sqlserver数据库啦！

Spring mvc 中的mapper.xml的SQL语句报错_course

### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=2,conn_timeout=1,resp_timeout=1,test_retry=1,freq=2,monit_conn_timeout=' at line 1 ### The error may involve com.security.dao.TemplateNetworkDao.updateTempNetwork-Inline ### The error occurred while setting parameters ### SQL: update conf_template_network set interval=?,conn_timeout=?,resp_timeout=?,test_retry=?,freq=?,monit_conn_timeout=?,monit_resp_timeout=?,monit_retry=? where id=? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=2,conn_timeout=1,resp_timeout=1,test_retry=1,freq=2,monit_conn_timeout=' at line 1 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=2,conn_timeout=1,resp_timeout=1,test_retry=1,freq=2,monit_conn_timeout=' at line 1_ 我的SQL语句是 ``` <update id="updateTempNetwork" parameterType="int"> update conf_template_network set interval=#{interval},conn_timeout=#{conn_timeout},resp_timeout=#{resp_timeout},test_retry=#{test_retry},freq=#{freq},monit_conn_timeout=#{monit_conn_timeout},monit_resp_timeout=#{monit_resp_timeout},monit_retry=#{monit_retry} where id=#{id} </update> ``` 找了半天也没找到哪写错了，而且也没有使用mysql的关键字，提示说monit_conn_timeout附近的错误 # ## ——————————————————————————————————** # ## 更新：好像是SQL语句太长了，把前边的字段改短后，前边的字段就能正确显示，但是后边超出长度的部分还是会报错 我把前边长的字段用a,b替代之后，变短了： ``` <update id="updateTempNetwork" parameterType="com.security.entity.TemplateNetwork"> update conf_template_network set interval=#{interval},conn_timeout=#{conn_timeout},resp_timeout=#{resp_timeout},test_retry=#{test_retry},freq=#{freq},a=#{a},b=#{b},monit_retry=#{monit_retry} where id=#{id} </update> ``` 错误就移到了后边： Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=3,conn_timeout=3,resp_timeout=3,test_retry=3,freq=1,a=2,b=1,monit_retry' at line 1 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=3,conn_timeout=3,resp_timeout=3,test_retry=3,freq=1,a=2,b=1,monit_retry' at line 1 好像跟长度又没关系 把后边的字段都砍掉了之后 ``` <update id="updateTempNetwork" parameterType="com.security.entity.TemplateNetwork"> update conf_template_network set interval=#{interval},conn_timeout=#{conn_timeout},resp_timeout=#{resp_timeout},test_retry=#{test_retry},freq=#{freq} where id=#{id} </update> ``` 还是会报错： 移到了最后： ### SQL: update conf_template_network set interval=?,conn_timeout=?,resp_timeout=?,test_retry=?,freq=? where id=? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=1,conn_timeout=2,resp_timeout=2,test_retry=1,freq=1 where id=1' at line 1 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=1,conn_timeout=2,resp_timeout=2,test_retry=1,freq=1 where id=1' at line 1 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at $Proxy29.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at $Proxy37.updateTempNetwork(Unknown Source) at com.security.service.impl.TemplateNetworkImpl.updateTempNetwork(TemplateNetworkImpl.java:35) at com.security.service.impl.TemplateNetworkImpl$$FastClassBySpringCGLIB$$16455d80.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) at com.security.service.impl.TemplateNetworkImpl$$EnhancerBySpringCGLIB$$a87fea1.updateTempNetwork(<generated>) at com.security.controller.TemplateNetworkController.updateTempNetwork(TemplateNetworkController.java:47) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'interval=1,conn_timeout=2,resp_timeout=2,test_retry=1,freq=1 where id=1' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:408) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at $Proxy48.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) # ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ # 结贴啦结帖啦！ # 休息两天果然脑细胞就活过来了，周一一大早就找到了bug # interval是mySQL的关键字，用作变量名，所以报错了，换个名字就好了。已经是第二次撞到关键字了，以后起变量名要小心了。 # 非常感谢各位的帮助！！