MySqlInsertRow.java - Connector/J JDBC Insert Row

Q

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

A

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

Examples for Connector/J - JDBC Driver for MySQL

⇑⇑ FAQ for Connector/J - JDBC Driver for MySQL

2016-12-02, 2177🔥, 0💬