How to connect sql database in java?

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

<1>.Microsoft SQL server 2005 Express Edition

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

<2>. SQL Server Management Studio

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

<3>.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)

<1> 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

<2> 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

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

<4> 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

<5> 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!