Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
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 (322)
Collections:
Other Resources:
SqlServerCreateTable.java - sqljdbc JDBC Create Table
How to create a new table 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 table 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; import java.sql.ResultSet; import java.sql.ResultSetMetaData; // Example of sqljdbc JDBC driver to create a new table public class SqlServerCreateTable { 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()); // 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 SqlServerCreateTable.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar SqlServerCreateTable JDBC connection URL: jdbc: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) methods take input index value starting from 1, not 0.
⇒ SqlServerInsertRow.java - sqljdbc JDBC Insert Row
⇐ SqlServerCreateDatabase.java - sqljdbc JDBC Create Database
2016-12-08, 2138🔥, 0💬
Popular Posts:
JDK 11 jdk.jcmd.jmod is the JMOD file for JDK 11 JCmd tool, which can be invoked by the "jcmd" comma...
pache Derby is an open source relational database implemented entirely in Java and available under t...
What Is mail.jar of JavaMail 1.4.2? I got the JAR file from javamail-1.4.2.zip. mail.jar in javamail...
kernel.jar is a component in iText Java library to provide low-level functionalities. iText Java lib...
JDK 11 java.sql.jmod is the JMOD file for JDK 11 SQL (Structured Query Language) module. JDK 11 SQL ...