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:
JtdsSqlServerCreateTable.java - jTDS JDBC Create Table
How to create a new table 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 table 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; import java.sql.ResultSet; import java.sql.ResultSetMetaData; // Example of jTDS JDBC driver to create a new table public class JtdsSqlServerCreateTable { 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()); // Create a new table "Profile" String sql = "CREATE TABLE Profile (ID INTEGER, Name VARCHAR(80))"; st.execute(sql); System.out.println(" Table Profile columns:"); sql = "SELECT * FROM Profile"; ResultSet rs = st.executeQuery(sql); ResultSetMetaData md = rs.getMetaData(); System.out.println(" "+md.getColumnName(1) +": "+md.getColumnTypeName(1)); System.out.println(" "+md.getColumnName(2) +": "+md.getColumnTypeName(2)); // Get out of database "FyiCenter" and drop iat 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 JtdsSqlServerCreateTable.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerCreateTable JDBC connection URL: jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter Connected to: master Connected to: FyiCenter Table Profile columns: ID: int Name: varchar
Note that getColumnName(index) and getColumnTypeName(index) motheds take input index value starting from 1, not 0.
⇒ JtdsSqlServerInsertRow.java - jTDS JDBC Insert Row
⇐ JtdsSqlServerCreateDatabase.java - jTDS JDBC Create Database
2017-01-29, 2101🔥, 0💬
Popular Posts:
commons-net.jar is the bytecode of Apache Commons Net library, which implements the client side of m...
Commons Pool provides an Object-pooling API, with three major aspects: 1. A generic object pool inte...
JRE 8 rt.jar is the JAR file for JRE 8 RT (Runtime) libraries. JRE (Java Runtime) 8 is the runtime e...
JDK 11 jdk.crypto.cryptoki.jmod is the JMOD file for JDK 11 Crypto Cryptoki module. JDK 11 Crypto KI...
What is the sax\Writer.java provided in the Apache Xerces package? I have Apache Xerces 2.11.0 insta...