使用groovy连接到SQL server

Question

我正在使用sqlserver，我想要从groovy进行连接，并在控制台上显示数据，现在我有了一个错误，并且它没有连接。我决定展示我在这里的东西这样我们就可以一起调试了，

代码如下：

package com.connectgroovy

import groovy.sql.Sql

class GroovyConnectMssqlExample {

    static main(args)
    {
        def conn = Sql.newInstance("jdbc:sqlserver://localhost:1433","DESKTOP-V2G35NU\\SQLEXPRESS","com.microsoft.sqlserver.jdbc.SQLServerDriver")
        conn.eachRow("select * from [bonitasoft_jsonTest].[dbo].[people_data]"){
            println "${it.fullname} | ${it.perdiem}"
        }
    }

}

我认为这是一个异常错误：

Caught: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DESKTOP-V2G35NU\SQLEXPRESS'.
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DESKTOP-V2G35NU\SQLEXPRESS'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
    at com.connectgroovy.GroovyConnectMssqlExample.main(GroovyConnectMssqlExample.groovy:9)

我做错什么了？

PS --我把sqljdbc4.jar作为引用库。日食

Answer 1

连接URL - url通常包含要连接到的服务器、要连接的端口以及要处理的数据库架构。示例："jdbc:mysql://localhost:3306/test“

用户名和密码-用于验证连接的凭据。示例: username = user和password = password。

JDBC驱动程序类-用于连接到数据库的JDBC驱动程序类。"com.microsoft.sqlserver.jdbc.SQLServerDriver“案例: MySQL案例

def sql = Sql.newInstance("jdbc:sqlserver://localhost:1433/test",
                "user", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")

用于窗口身份验证

def sql =Sql.newInstance("jdbc:sqlserver://localhost;Database=myDB;integratedSecurity=true","com.microsoft.sqlserver.jdbc.SQLServerDriver")