无法使用java 8连接到sql server

Question

import java.sql.*;
import java.io.*;
import java.net.*;
import java.util.Scanner;

public class DBConnec
{
    public static void main(String a[])
    {

        try
        {
            String url = "jdbc:jtds:sqlserver//localhost:1433/dictionary";   
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection conn = DriverManager.getConnection(url);
            System.out.println("connection created");
            Statement st=conn.createStatement();    
            String sql="select * from data where word LIKE 'hi'";
            ResultSet rs=st.executeQuery(sql);

            if (rs.next()) 
            {
                System.out.println(rs.getString(0));
            }

            if(st!=null)
                st.close();
            if(conn!=null)
                conn.close();
        }
        catch(SQLException sqle)
        {
            sqle.printStackTrace();
        }

        catch(ClassNotFoundException e)
        {
            e.printStackTrace();
        }

    }
}

java.sql.sqlexception：网络错误IOException：连接被拒绝：连接在net.sourceforge.jtds.jdbc.jtdsConnection.（jtdsconnection.java:434)在net.sourceforge.jtds.jdbc.driver.connect（driver.java:183)在net.sql.drivermanager.getConnection（未知源）在dbconnect.main（dbconnect.java.java:15)由：java.net.Connection（未知源）引起：连接被拒绝：连接在java.net.dualstackplainsocketimpl.connect0（本机方法）在java.net.dualstackplainsocketimpl.socketconnection.AbstractPlainsockeTimpl.DoConnect（未知源）在java.net.AbstractPlainsockeTimpl.ConnectToAddress（未知源）在java.net.AbstractPlainsockeTimpl.connect（未知源）在java.net.PlainsockeTimpl.connect（未知源）在java.net.PlainsockeTimpl.connect（未知源）在java.net.SocksSocksSocksSocksSocksSocksSocksSocksSocksSocksSockeTimpl.connect（未知源）在java.net.NativeMethodAccessorImpl.Invoke0（本机方法）在已知源）在sun.reflect.DelegatingMethodAccessorImpl.Invoke（未知源）在java.lang.reflect.Method.Invoke（未知源）

Answer 1

试试看：

String url = "jdbc:jtds:sqlserver://localhost:1433/dictionary";

sqlserver后面漏了冒号。

您不应该将JDBC驱动程序JAR添加到jre/lib/ext目录中。了解如何正确使用类路径。