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:
JtdsSqlServerInsertRow.java - jTDS JDBC Insert Row
How to insert a row of data into a 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 insert a row of data into a 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; // Example of jTDS JDBC driver to insert data rows to a table public class JtdsSqlServerInsertRow { 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); // Insert data row to table "Profile" sql = "INSERT INTO Profile (ID, Name) VALUES (1, 'Donald Trump')"; int n = st.executeUpdate(sql); System.out.println(" Rows inserted: "+n); // Query data from table "Profile" System.out.println(" Query result: "); sql = "SELECT * FROM Profile"; ResultSet rs = st.executeQuery(sql); while (rs.next()) { System.out.println(" "+rs.getInt("ID")+", " +rs.getString("Name")); } rs.close(); // 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 JtdsSqlServerInsertRow.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerInsertRow JDBC connection URL: jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter Connected to: master Connected to: FyiCenter Rows inserted: 1 Query result: 1, Donald Trump
⇒ FAQ for jTDS - JDBC Driver for SQL Server
⇐ JtdsSqlServerCreateTable.java - jTDS JDBC Create Table
2017-01-29, 2665🔥, 0💬
Popular Posts:
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...
Smack is an Open Source XMPP (Jabber) client library for instant messaging and presence. A pure Java...
JDK 11 jdk.internal.vm.compiler .jmodis the JMOD file for JDK 11 Internal VM Compiler module. JDK 11...
Java Cryptography Extension 1.2.2 JAR File Size and Download Location: File name: jce.jar, jce-1.2.2...
JDK 11 jdk.charsets.jmod is the JMOD file for JDK 11 Charsets module. JDK 11 Charsets module compile...