java.sql.Connection
interface provides 'createStatement' method to create a Statement
object. 'createStatement' method available in three varieties.
Method
|
Description
|
Statement
createStatement()
|
Creates a Statement
object for sending SQL statements to the database.
|
Statement
createStatement(int resultSetType, int resultSetConcurrency)
|
Creates a Statement
object that will generate ResultSet objects with the given type
and concurrency.
|
Statement
createStatement(int resultSetType, int resultSetConcurrency, int
resultSetHoldability)
|
Creates a Statement
object that will generate ResultSet objects with the given type,
concurrency, and holdability.
|
By
default ResultSet created by using Statement object is of type
TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.
But you can change this behavior while creating Statement object.
/* Step 1: Import sql package */ import java.sql.*; public class SampleApp { /* Update username, password and driver details here */ static Connection getConnection() throws ClassNotFoundException, SQLException{ /* Step 2: Load Driver */ System.out.println("Loading/Registering driver"); Class.forName("com.mysql.jdbc.Driver"); /* Step 3: Open connection to database */ System.out.println("Connecting to database"); String url = "jdbc:mysql://localhost/world"; String userName = "root"; String pasword = "tiger"; return DriverManager.getConnection(url, userName, pasword); } public static void main(String args[]) throws SQLException, ClassNotFoundException{ Connection conn = getConnection(); /* Create table employee */ String query = "CREATE TABLE employee (id int, name varchar(30), PRIMARY KEY(id))"; Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt.execute(query); /* Insert data to employee table */ query = "INSERT INTO employee values(1, \"Krishna\")"; stmt.execute(query); query = "INSERT INTO employee values(2, \"Arjun\")"; stmt.execute(query); query = "SELECT * FROM employee"; ResultSet rs = stmt.executeQuery(query); int id; String name; while(rs.next()){ id = rs.getInt("id"); name = rs.getString("name"); System.out.println(id +" " + name); } System.out.println("Dropping table employee"); query = "DROP TABLE employee"; stmt.execute(query); rs.close(); stmt.close(); conn.close(); } }
Output
Loading/Registering driver Connecting to database 1 Krishna 2 Arjun Dropping table employee
No comments:
Post a Comment