SqlServerCreateDatabase.java - sqljdbc JDBC Create Database

Q

How to create a new database in SQL Server using the sqljdbc JDBC driver? I want to see a Java program example.

✍: FYIcenter.com

A

Here is a Java example that shows you how to create a new database in SQL Server using the sqljdbc JDBC driver:

// Copyright (c) 2016 FYIcenter.com
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;

// Example of sqljdbc JDBC driver to create a new database
public class SqlServerCreateDatabase {
   public static void main(String [] args) throws Exception {

      // sqljdbc JDBC connection URL to the default SQL Server instance
      String url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 

      // Create a new database "FyiCenter" and connect to it  
      String db = "FyiCenter";      
      Statement st = con.createStatement();
      st.execute("CREATE DATABASE "+db);
      con.setCatalog(db);
      System.out.println("   Connected to: "+con.getCatalog()); 
      
      // Get out of database "FyiCenter" and drop it
      con.setCatalog("master");
      st.execute("DROP DATABASE "+db);
      con.close();
   }
}

You can compile and run the above example in a command window as shown below:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   SqlServerCreateDatabase.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar 
   SqlServerCreateDatabase

JDBC connection URL: 
   jdbc:sqlserver://localhost;user=sa;password=fyicenter
   Connected to: master
   Connected to: FyiCenter

 

Examples for sqljdbc - JDBC Driver for SQL Server

⇒⇒FAQ for sqljdbc - JDBC Driver for SQL Server

2016-12-08, 1283👍, 0💬