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:
MySqlInsertRow.java - Connector/J JDBC Insert Row
How to insert a row of data into a table in MySQL using the Connector/J 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 MySQL using the Connector/J JDBC driver:
// Copyright (c) FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; // Example of Connector/J JDBC driver to insert data rows to a table public class MySqlInsertRow { public static void main(String [] args) throws Exception { // Connector/J JDBC connection URL with required elements String url = "jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false"; 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 = 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 database and its table st.execute("DROP DATABASE "+db); con.close(); } }
You can compile and run the above example in a command window as shown below:
fyicenter> javac MySqlInsertRow.java fyicenter> java -cp .;mysql-connector-java-5.1.40-bin.jar MySqlInsertRow JDBC connection URL: jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false Connected to: Connected to: FyiCenter Rows inserted: 1 Query result: 1, Donald Trump
⇒ FAQ for Connector/J - JDBC Driver for MySQL
⇐ MySqlCreateTable.java - Connector/J JDBC Create Table
2016-12-02, 2187🔥, 0💬
Popular Posts:
What Is jsse.jar (JDK 6) Java Secure Socket Extension? jsse.jar, Java Secure Socket Extension, is Ja...
What Is js.jar in Rhino JavaScript 1.7R5? js.jar in Rhino JavaScript 1.7R5 is the JAR file for Rhino...
Provides support for the runtime platform, core utility methods and the extension registry. JAR File...
What Is poi-ooxml-5.2.3.jar? poi-ooxml-5.2.3.jar is one of the JAR files for Apache POI 5.2.3, which...
JDK 11 jdk.charsets.jmod is the JMOD file for JDK 11 Charsets module. JDK 11 Charsets module compile...