JDBC: Insert Record using Prepared Statements


 

JDBC: Insert Record using Prepared Statements

In this section, you will learn how to insert row using Prepared Statements.

In this section, you will learn how to insert row using Prepared Statements.

JDBC: Insert Record using Prepared Statements

In this section, you will learn how to insert row using Prepared Statements.

Insert Record   :

Prepared statement is good to use where you need to execute same SQL statement many times for different values. It is precompiled SQL Statements which are stored in a PreparedStatement object. Now you can use this object to execute this statement many times. It is the best way to reduce execution time and improve performance. So if you want to insert many rows ,use PreparedStatement in place of Statement.

executeUpdate(String sql): This method executes SQL statements(insert, update or delete)in PreparedStatement object, which takes the SQL query of string type and returns int.

Example : In this example we are inserting student record using PreparedStatement.

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

class PreparedStmntInsert {
	public static void main(String[] args) {
		System.out.println("Insert Record using Prepared Statement ...");
		Connection con = null;
		String url = "jdbc:mysql://localhost:3306/";
		String dbName = "students";
		String driverName = "com.mysql.jdbc.Driver";
		String userName = "root";
		String password = "root";
		PreparedStatement st = null;
		try {
			Class.forName(driverName);
			con = DriverManager.getConnection(url + dbName, userName, password);
			try {

				String sql = "INSERT INTO student(name,course,location) VALUES(?,?,?)";
				st = con.prepareStatement(sql);
				st.setString(1, "Jackson");
				st.setString(2, "MBA");
				st.setString(3, "London");
				st.executeUpdate();
				System.out.println("Record inserted successfully!");
			} catch (SQLException s) {
				System.out.println(s);
			}
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

Output :

Insert Record using Prepared Statement ...
Record inserted successfully!

Ads