Breaking News
yeni film izle hd film seyret film izle

Creating and Executing JDBC Statements

Creating and Executing JDBC Statements

We need to create a Statement object to send request and retrieve result from a database. The Connection object provide the createStatement ( ) method to create a Statement object.
We can use the following code to create a Statement object:
Connection con =DriverManager.getConnection
(“jdbc:odbc:MyDSN”, “NewUser”, “NewPassword”);
Statement stmt= con.createStatement ( );
We can use the static SQL statement to send request to a database.
Here we can use the send the SQL statement to a database using the Statement object.
The Statement interface contain the following methods to send static SQL statement to the database:—–
1. ResultSet executeQuery(String str):– It execute an SQL statement and returns a single object of the type, ResultSet.
The syntax to use the executeQuery ( ) method is :
Statement stmt = con.createStatement ( );
ResultSet rs = stmt.executeQuery(<SQL statement>);
2. int executeUpdate (String str):– It execute the SQL statements and returns the number of data rows that are affected after processing the SQL statement. The executeUpdate ( ) can be used when we need to INSERT, DELETE, and UPDATE the data.
Statement stmt = con.createStatement ( );
ResultSet rs = stmt.execute(<SQL statement>);
3. Boolean execute(String str): This method execute an SQL statement and return a Boolean
Statement stmt = con.createStatement ( );
stmt.execute(<SQL statement>);