Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to connect sqlserver through jdbc in sqlserverdriver. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Download the driver.

First download to the sql2005jdbc driver sqljdbc_2.0.1008.2_enu.exe (sql2008 is supported by sql2005,2.0 after version number 1.1)

Download is a decompression can be used, do not need to install, you can put this package anywhere you want, for example, you put the package

In the C:\ Program Files directory. The path of the sqljdbc.jar package is to copy the code as follows: C:\ Program Files\ Microsoft SQL Server 2005 JDBC Driver\ sqljdbc_1.2\ enu\ sqljdbc.jar

Second, configure Tomcat server.

Make sure you have installed Tomcat. Open the Monitor Tomcat server and add the sqljdbc.jar package path copy code under Java Classpath on the Java tab as follows:

C:\ Program Files\ Microsoft SQL Server 2005 JDBC Driver\ sqljdbc_1.2\ enu\ sqljdbc.jar

(use semicolons between two different jar packages ";") restart the Tomcat server so that you can complete the configuration of Tomcat

Third, configure the sql2005 server.

Configure TCP port: copy the code as follows: start-> all programs-> Microsoft SQL Server 2005-> configuration tools-> SQL Server Configuration Manager

-> SQL Server 2005 Network configuration-> MSSQLSERVER Protocol; enable "TCP/IP"; double-click "TCP/IP"-> "IP address"-> "IPAll"

-> the TCP Port entry adds the default "1433". Restart the sql2005 server, which completes the configuration of the sql2005 server.

4. Copy the documents

Find the sqljdbc_auth.dll file in the sqljdbc driver you downloaded, for example, the directory I unzipped is C:\ Program Files, so I

The code for copying the sqljdbc_auth.dll file is as follows: C:\ Program Files\ Microsoft SQL Server 2005 JDBC Driver\ sqljdbc_1.2\ enu\ auth\ x86\ sqljdbc_auth.dll

Put the found file in the C:\ WINDOWS\ system32 directory, which is a dynamic runtime, which must be needed.

Write a test file and test it. (there is an appendix at the end of the article)

Remember: after making changes to the server (whether it's the Tomcat server or the sql2005 server, be sure to restart the server for the changes to take effect)

If you can't get it done, you can try to open up more services to the sql2005 server as follows:

1. Peripheral application configuration:

Microsoft SQL Server 2005-> configuration tools-> SQL Server Peripheral Application Configurator-> Peripheral Application Configurator for Services and connections->

① Select SQLEXPRESS- > Database Engine- > remote connection-> Local connection and remote connection-> use TCP/IP and named pipes at the same time

For ②, select SQL Server Browser- > Service-> start type to change to "automatic"-> apply-> start-> OK.

2. Modify the default login authentication mode (sa login is disabled because it is installed in "Windows authentication mode" by default during installation, and sa login is still disabled even if the authentication mode is changed to "SQL Server and Windows authentication mode", so you need to enable the sa login account):

① in SQL Server Management Studio object Explorer, Security-> Login name-> right-click "sa"-> Properties-> General->

Set the password and confirmation password of the login name sa to strong password-> status-> login-> enable-> OK.

② in object Explorer in SQL Server Management Studio, right-click Server-> Properties-> Security-> Server Authentication->

Select SQL Server and Windows Authentication modes-> OK-> OK.

3. Turn off the firewall.

Note:

Note the difference between 2000 and 2005 when writing connection code:

The copy code for connecting to SqlServer2000 is as follows: Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver"); URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb"

The copy code for connecting to SqlServer2005 is as follows: Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver"); URL = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb"

Appendix: the copy code is as follows: import java.sql.*

Public class Test {public static void main (String [] srg) {String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; / / load JDBC driver String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample"; / / connect server and database sample String userName = "sa"; / / default user name String userPwd = "123456"; / / password Connection dbConn

Try {Class.forName (driverName); dbConn = DriverManager.getConnection (dbURL, userName, userPwd); System.out.println ("Connection Successful!"); / / if the connection is successful, the console outputs Connection Successful!} catch (Exception e) {e.printStackTrace ();}

On how to connect to sqlserver through jdbc in sqlserverdriver to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.