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:
JtdsSqlServerCreateDatabase.java - jTDS JDBC Create Database
How to create a new database in SQL Server using the jTDS 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 jTDS JDBC driver:
// Copyright (c) 2016 FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.Statement; // Example of jTDS JDBC driver to create a new database public class JtdsSqlServerCreateDatabase { public static void main(String [] args) throws Exception { // jTDS JDBC connection URL with required elements String url = "jdbc:jtds: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 -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerCreateDatabase.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerCreateDatabase JDBC connection URL: jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter Connected to: master Connected to: FyiCenter
⇒ JtdsSqlServerCreateTable.java - jTDS JDBC Create Table
⇐ JtdsSqlServerJdbcUrl.java - jTDS JDBC Connection URL Example
2017-01-29, 1976🔥, 0💬
Popular Posts:
What Is mail.jar of JavaMail 1.4.2? I got the JAR file from javamail-1.4.2.zip. mail.jar in javamail...
JDK 11 java.naming.jmod is the JMOD file for JDK 11 Naming module. JDK 11 Naming module compiled cla...
JDK 17 java.xml.jmod is the JMOD file for JDK 17 XML (eXtensible Markup Language) module. JDK 17 XML...
What Is js.jar in Rhino JavaScript 1.7R5? js.jar in Rhino JavaScript 1.7R5 is the JAR file for Rhino...
JRE 5 sunjce_provider.jar is the JAR file for JRE 5 Sun JCE Provider, which provides implementations...