How to connect sql database in java?

1. Preparation: Prepare relevant software (except Eclipse, open source software can be downloaded from the official website)

f35d6e602fd7d0f0edfa6f7d103c1b57.Microsoft SQL server 2005 Express Edition

Download address: http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE

2cc198a1d5eb0d3eb508d858c9f5cbdb. SQL Server Management Studio

Download address: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796#filelist

5bdf4c78156c7953567bb5a0aef2fc53.SQL Server 2005 driver for JDBC

Download address: http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/ sqljdbc_1.2.2323.101_enu.exe

2. Driver installation for JDBC connection to SQL Server. The first two are database software and can be installed normally (note that you do not need to use windows authentication for database login)

f35d6e602fd7d0f0edfa6f7d103c1b57 Unzip JDBC to any location, such as unzip it to the C drive program files, and find the sqljdbc.jar file in the installation directory, get its path and start configuring the environment variables

After the environment variable classpath Append C:\Program Files\Microsoft SQL Server2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar

2cc198a1d5eb0d3eb508d858c9f5cbdb Set SQLEXPRESS server:

a. Open SQL Server Configuration Manager - > SQLEXPRESS protocol-> TCP/IP

b. Right-click to start TCP/IP

c. Double-click to enter the properties and set the TCP port in IP all in the IP address For 1433

d. Restart the SQLEXPRESS server in the SQL Server 2005 service

e. Close SQL Server Configuration Manager

5bdf4c78156c7953567bb5a0aef2fc53 Open the SQL Server you just installed Management Studio, connect to the SQLEXPRESS server, create a new database, name it sample

23889872c2e8594e0f446a471a78ec4c Open Eclipse

a. Create a new project-> Java -> Java project, name it Test

b. Select eclipse->Window->Preferences->Java->installed JRE Edit the installed jdk, find the directory and add sqljdbc.jar

c. Right-click Click Test in the directory window, select Build Path ->Configure Build Path..., add the extension jar file, that is, add sqljdbc.jar to it

43ad812d3a971134e40facaca816c822 Write Java code to test JDBC Connect to SQL Server database

import java.sql.*;   
  
public class Test {  
  
public static void main(String[] srg) {  
  
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动  
  
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";   //连接服务器和数据库sample  
  
   String userName = "sa";   //默认用户名  
  
   String userPwd = "123456";   //密码  
  
   Connection dbConn;  
  
   try {  
  
   Class.forName(driverName);  
  
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd);  
  
   System.out.println("Connection Successful!");   //如果连接成功 控制台输出Connection Successful!  
  
   } catch (Exception e) {  
  
   e.printStackTrace();  
  
   }  
  
}  
  
}

The above is the detailed content of How to connect sql database in java?. For more information, please follow other related articles on the PHP Chinese website!