sql

Connect to SQLServer database example

With this example we are going to demonstrate how to connect to SQLServer Database in Java. In short, to connect to SQLServer Database you should:

  • Load the NetDirect JDBC driver, using the forName(String className) API method of the Class, in order to connect to SQLServer Database.
  • Create a Connection to the database. Invoke the getConnection(String url, String user, String password) API method of the DriverManager to create the connection.The parameters should be the database url, the database user on whose behalf the connection is being made and the user’s password.

Let’s take a look at the code snippet that follows:
 

package com.javacodegeeks.snippets.core;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectToSQLServer {
 
  public static void main(String[] args) {

    Connection connection = null;
    try {

  // Load the NetDirect JDBC driver

  String driverName = "com.jnetdirect.jsql.JSQLDriver";

  Class.forName(driverName);


  // Create a connection to the database

  String serverName = "localhost";

  String serverPort = "1433";

  String database = serverName + ":" + serverPort;

  String url = "jdbc:JSQLConnect://" + database;

  String username = "username";

  String password = "password";

  connection = DriverManager.getConnection(url, username, password);

  

  System.out.println("Successfully Connected to the database!");

  
    } catch (ClassNotFoundException e) {

  System.out.println("Could not find the database driver " + e.getMessage());
    } catch (SQLException e) {

  System.out.println("Could not connect to the database " + e.getMessage());
    }

 }

}

Output:

Successfully Connected to the database!

 
This was an example of how to connect to SQLServer Database in Java.

Ilias Tsagklis

Ilias is a software developer turned online entrepreneur. He is co-founder and Executive Editor at Java Code Geeks.
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Back to top button