Share on Google+Share on Google+

Executing Prepared Statement

Advertisement
In this tutorial you will learn how to execute query in JDBC prepared statement,

Executing Prepared Statement

Prepared Statement represents the pre-compiled query with parameter and no-parameter. An example given below is no-parameter prepared statement example.

Example-

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
 );

Inset Data into the student table

PreparedStatementExecuteExample.java

package roseindia.net;

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

public class PreparedStatementExecuteExample {
	Connection connection = null;
	String driverName = "com.mysql.jdbc.Driver";
	String connectionUrl = "jdbc:mysql://localhost:3306/student";
	String userName = "root";
	String userPass = "root";

	public PreparedStatementExecuteExample() {
		try {
			Class.forName(driverName);
		} catch (ClassNotFoundException e) {
			System.out.println(e.toString());
		}
	}

	public Connection getConnection() {
		try {
			connection = DriverManager.getConnection(connectionUrl, userName,
					userPass);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return connection;
	}

	public static void main(String[] args) throws SQLException {
		PreparedStatementExecuteExample ptmtExample = new PreparedStatementExecuteExample();
		Connection con = ptmtExample.getConnection();
		// Writing a query
		String query = "SELECT * FROM student";
		try {
			// Compiling query String
			PreparedStatement statement = con.prepareStatement(query);
			ResultSet resultSet=statement.executeQuery();
			while(resultSet.next()){
				System.out.println("Roll No- "+resultSet.getInt(1)+", Name- "+resultSet.getString(2)+", Course- "+resultSet.getString(3)+", Address- "+resultSet.getString(4));
			}
			statement.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			con.close();
		}
	}
}
When you run this application it will display message as shown below:

Roll No- 1, Name- Rajan, Course- MCA, Address- Motihari
Roll No- 2, Name- Dinesh, Course- MCA, Address- Patna
Roll No- 3, Name- Rohan, Course- MCA, Address- Mumbai
Roll No- 4, Name- Ramesh, Course- B.Tech, Address- Nagpurs

Download this example code

Advertisements

Posted on: October 21, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.