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:
OracleInsertRow.java - Oracle JDBC Insert Row
How to insert a row of data into a table in Oracle using the ojdbc Oracle 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 Oracle using the ojdbc Oracle Driver:
// Copyright (c) FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; // Example of ojdbc Oracle Driver to insert data rows to a table public class OracleInsertRow { public static void main(String [] args) throws Exception { // Oracle JDBC connection URL with required elements String url = "jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE"; Connection con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); // Create a new table "Profile" String sql = "CREATE TABLE Profile (ID INTEGER, Name VARCHAR(80))"; Statement st = con.createStatement(); st = con.createStatement(); 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(); // Drop the new table st.execute("DROP TABLE Profile"); 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 OracleInsertRow.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;\fyicenter\Oracle-11.2.0.4\ojdbc6.jar OracleInsertRow JDBC connection URL: jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE Connected to: null Rows inserted: 1 Query result: 1, Donald Trump
⇒ FAQ for ojdbc.jar - JDBC Driver for Oracle
⇐ OracleCreateTable.java - Oracle JDBC Create Table
2018-03-28, 1892🔥, 0💬
Popular Posts:
JDK 11 jdk.crypto.ec.jmod is the JMOD file for JDK 11 Crypto EC module. JDK 11 Crypto EC module comp...
Smack is an Open Source XMPP (Jabber) client library for instant messaging and presence. A pure Java...
How to run "javac" command from JDK tools.jar file? "javac" is the Java compiler command that allows...
What Is poi-contrib-3.5.jar? poi-contrib-3.5.jar is one of the JAR files for Apache POI 3.5, which p...
What Is commons-logging-1.2.jar? commons-logging-1.2.jar is the JAR file for Apache Commons Logging ...