Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
SqlServerCreateDatabase.java - sqljdbc JDBC Create Database
How to create a new database in SQL Server using the sqljdbc JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
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
⇒ SqlServerCreateTable.java - sqljdbc JDBC Create Table
⇐ sqljdbc JDBC getClientInfoProperties() Method Not Supported
2016-12-08, 2296🔥, 0💬
Popular Posts:
What is the jaxp\SourceValidator.jav aprovided in the Apache Xerces package? I have Apache Xerces 2....
What Is poi-ooxml-5.2.3.jar? poi-ooxml-5.2.3.jar is one of the JAR files for Apache POI 5.2.3, which...
JDK 11 jdk.jdi.jmod is the JMOD file for JDK 11 JDI (Java Debug Interface) tool. JDK 11 JDI tool com...
Smack is an Open Source XMPP (Jabber) client library for instant messaging and presence. A pure Java...
JDK 11 jdk.compiler.jmod is the JMOD file for JDK 11 Compiler tool, which can be invoked by the "jav...