In this tutorial you will learn how to insert data into the table through JDBC simple Statement
In this tutorial you will learn how to insert data into the table through JDBC simple StatementJDBC Insert statement allow you to insert record into the table of the database. This tutorial shows you that how to load database driver, get connection t the database and insert record to the database.
At first create table named student in MySql database and inset values into it as.
CREATE TABLE student (
RollNo int(9) PRIMARY KEY NOT NULL,
Name tinytext NOT NULL,
Course varchar(25) NOT NULL,
Address text
);
JDBCInsertExample.java
package roseindia.net; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class JDBCInsertExample { public static void main(String[] args) throws SQLException { Connection con = null; // connection reference variable for getting // connection Statement stmt = null; // Statement reference variable for query // Execution String conUrl = "jdbc:mysql://localhost:3306/"; String driverName = "com.mysql.jdbc.Driver"; String databaseName = "student"; String usrName = "root"; String usrPass = "root"; try { // Loading Driver Class.forName(driverName); } catch (ClassNotFoundException e) { System.out.println(e.toString()); } try { // Getting Connection con = DriverManager.getConnection(conUrl + databaseName, usrName, usrPass); // Creating Statement for query execution stmt = con.createStatement(); // creating Query String String query = "INSERT INTO student values(1,'Vinay','MCA','Mumbai')"; // Updating Table stmt.executeUpdate(query); System.out.println("Table Updated Successfully...."); } catch (Exception e) { System.out.println(e.toString()); } finally { // Closing Connection con.close(); stmt.close(); } } }When you run this application it will display message as shown below:
Table Updated Successfully.... |