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:
SqlServerInsertRow.java - sqljdbc JDBC Insert Row
How to insert a row of data into a 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 insert a row of data into a 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; // Example of sqljdbc JDBC driver to insert data rows to a table public class SqlServerInsertRow { 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); // 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 SqlServerInsertRow.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar SqlServerInsertRow JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter Connected to: master Connected to: FyiCenter Rows inserted: 1 Query result: 1, Donald Trump
⇒ FAQ for sqljdbc - JDBC Driver for SQL Server
⇐ SqlServerCreateTable.java - sqljdbc JDBC Create Table
2016-12-08, 2132🔥, 0💬
Popular Posts:
What Is ojdbc5.jar for Oracle 11g R1? ojdbc5.jar for Oracle 11g R1 is the JAR files of ojdbc.jar, JD...
The Bouncy Castle Crypto package is a Java implementation of cryptographic algorithms, it was develo...
What Is poi-scratchpad-5.2.3.jar ?poi-scratchpad-5.2.3.jar is one of the JAR files for Apache POI 5....
What JAR files are required to run dom\Writer.java provided in the Apache Xerces package? 3 JAR file...
JRE 8 rt.jar is the JAR file for JRE 8 RT (Runtime) libraries. JRE (Java Runtime) 8 is the runtime e...