JDBC Statement Example

In this tutorial you will learn java.sql.Statement interface and also how to use this interface in your application.


Share on Google+Share on Google+

JDBC Statement Example


In this tutorial you will learn java.sql.Statement interface and also how to use this interface in your application.

JDBC Statement

JDBC Statement is an interface of java.sql.*; package. It is used for execution of SQL statements. It returns a ResultSet object. This result set object contains the result of the query. Statement interface provides basic method for SELECT, INSERT, UPDATE, DELETE operations in the database. Its query is compiled every time when request is made, therefore is little slower in comparison to PreparedStatement.

An example given below which illustrate to JDBC Statements interface. This example creates a table named StudentDetail in student database.

At first create a database in MySlq named student.


package roseindia.net;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCStatementExample {
	Connection connection = null;

	public JDBCStatementExample() {
		try {
			// Loading the driver
		} catch (ClassNotFoundException e) {

	public Connection createConnection() {
		Connection con = null;
		if (connection != null) {
			System.out.println("Cant create a connection");
		} else {
			try {
				// Crating a Connection to the Student database
				con = DriverManager.getConnection(
						"jdbc:mysql://localhost:3306/student", "root",
				System.out.println("Connection created Successfully");
			} catch (SQLException e) {
		return con;

	public static void main(String[] args) throws SQLException {
		JDBCStatementExample jdbccOnnectionExample = new JDBCStatementExample();
		Connection conn = jdbccOnnectionExample.createConnection();
		// Creating a Statement reference variable
		Statement stmt = null;
		// getting the connection reference to the Statement
		// Creating a statement
		stmt = conn.createStatement();
		String queryString = "CREATE TABLE StudentDetail (RollNo int(9)  PRIMARY KEY NOT NULL, Name tinytext NOT NULL,Course varchar(25) NOT NULL, Address text  );";
		// Executing query
		System.out.println("Table created successfully............");

When you run this application it will display message as shown below:

Connection created Successfully
Table created successfully............

Download this example code


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