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);
      System.out.println("   Connected to: "+con.getCatalog()); 
      // Create a new table "Profile"
      String sql = "CREATE TABLE Profile (ID INTEGER, Name VARCHAR(80))";
      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
      st.execute("DROP DATABASE "+db);

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

   -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar 

   -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar 

JDBC connection URL: 
   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

Examples for jTDS - JDBC Driver for SQL Server

⇑⇑ FAQ for jTDS - JDBC Driver for SQL Server

2017-01-29, 2145🔥, 0💬