CodesJava

Easy learning with example program codes

Create table using PreparedStatement JDBC


The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by creates a table example.

Example:

JDBCTest.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import com.codesjava.util.JDBCUtil;
 
/**
 * This class is used to create a table in DB 
 * using PreparedStatement.
 * @author codesjava
 */
public class JDBCTest {
	public static void main(String args[]){
		Connection conn = null;
		PreparedStatement preparedStatement = null;
 
		String query = "create table EMPLOYEE("
			+ "EMPLOYEE_ID NUMBER(5) NOT NULL, "
			+ "NAME VARCHAR(20) NOT NULL, "
			+ "SALARY NUMBER(10) NOT NULL, "
			+ "PRIMARY KEY (EMPLOYEE_ID) )";
 
		try{			
			//get connection
			conn = JDBCUtil.getConnection();
 
			//create preparedStatement
			preparedStatement = conn.prepareStatement(query);
 
			//execute query
			preparedStatement.execute();
 
			//close connection
			preparedStatement.close();
			conn.close();
 
		      System.out.println("Table created successfully.");
		}catch(Exception e){
			e.printStackTrace();
		}
	}	
}

JDBCUtil.java

import java.sql.Connection;
import java.sql.DriverManager;
 
/**
 * This is a utility class for JDBC connection.
 * @author codesjava
 */
public class JDBCUtil {
	//JDBC and database properties.
	private static final String DB_DRIVER = 
		           "oracle.jdbc.driver.OracleDriver";
	private static final String DB_URL = 
		        "jdbc:oracle:thin:@localhost:1521:XE";
	private static final String DB_USERNAME = "system";
	private static final String DB_PASSWORD = "oracle";
 
	public static Connection getConnection(){
		Connection conn = null;
		try{
			//Register the JDBC driver
			Class.forName(DB_DRIVER);
 
			//Open the connection
			conn = DriverManager.
			getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
 
			if(conn != null){
			   System.out.println("Successfully connected.");
			}else{
			   System.out.println("Failed to connect.");
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}	
}

Output:

Successfully connected.
Table created successfully.

Download this example.
 
Next Topic: JDBC PreparedStatement inserts a record example.
Previous Topic: JDBC PreparedStatement interface.

 

Please follow and like us:
Posted in JDBC   


Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki