如何下载用于JDBC连接的jar文件 [英] How do I download jar file for JDBC connection

问题描述

大家好，



我正在研究java应用程序，我想保存文本框数据数据库表。我正在使用java 1.8和sql server 2005.我想创建数据库连接。我想要JDBC jar文件，它适用于sql server 2005和java 1.8。谁能请我提供链接。我已经google了这么多，下载所以可能文件，buit eclipse给出错误：找不到适合jdbc的驱动程序：microsoft：sqlserver：//192.168.1.7/userdetails_aadhar。该怎么办？ PLZ帮助



我尝试了什么：



我试过所有microsoft网站上提供的jdbc文件

解决方案

从这里开始用于SQL Server的Microsoft JDBC驱动程序Microsoft Docs [ ^ ]并点击链接。有些是步骤1：为Java开发配置开发环境| Microsoft Docs [ ^ ]和使用JDBC驱动程序| Microsoft Docs [ ^ ]。



来自后者：

引用：

Microsoft JDBC驱动程序jar不是Java SDK的一部分，必须包含在用户应用程序的Classpath中。

和

Quote：

在IDE中运行的应用程序



每个IDE供应商提供在IDE中设置类路径的另一种方法。只是在操作系统中设置类路径是行不通的。您必须将sqljdbc.jar，sqljdbc4.jar或sqljdbc41.jar添加到IDE类路径。

我搜索了一下，发现有关为SQL Server配置Eclipse的说明：如何使用Eclipse连接到Microsoft SQL Server数据库 [ ^ ]

Hello all,

I am working on java application in that i want to save textbox data database table. I am using java 1.8 and sql server 2005. I want to create database connection. I want JDBC jar file for that which is compatable for sql server 2005 and java 1.8. Can anyone please provide me link. i have googled so much, downloaded so may files, buit eclipse is giving error:No suitable driver found for jdbc:microsoft:sqlserver://192.168.1.7/userdetails_aadhar. What to do? plz help

What I have tried:

I have tried all jdbc files available on microsoft website

解决方案

Start here Microsoft JDBC Driver for SQL Server | Microsoft Docs[^] and follow the links. Some are Step 1: Configure development environment for Java development | Microsoft Docs[^] and Using the JDBC Driver | Microsoft Docs[^].

From the latter:

Quote:

The Microsoft JDBC driver jars are not part of the Java SDK and must be included in Classpath of user application.

and

Quote:

Applications that run in an IDE

Each IDE vendor provides a different method for setting the classpath in its IDE. Just setting the classpath in the operating system will not work. You must add sqljdbc.jar, sqljdbc4.jar, or sqljdbc41.jar to the IDE classpath.

I have googled a bit and found this description on configuring Eclipse for SQL Server: How to connect to Microsoft SQL Server database using Eclipse[^]

这篇关于如何下载用于JDBC连接的jar文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！