jdbc interface
-Connection = Helps our java project
connect to database
-Statement = Helps to write and execute SQL query
-ResultSet = A DataStructure where
the data from query result stored
4.25
8
Connection =
Helps our java project connect to database
Statement =
Helps to write and execute SQL query
ResultSet =
A DataStructure where the data from query result stored
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
After succesfully created the connect
next step is STATEMENT
Statement statement = connection.createStatement();
We use createStatement() method to create
the statement from our connection.
-The result we get from this type of statement
can only move from top to bottom,
not other way around
Statement statement = connection.
createStatement(ResultSet TYPE_SCROLL_INSENSITIVE
,ResultSet CONCUR_READ_ONLY);
-The result we get from this type of
statement can freely move between rows
Once we have statement we can run
the query and get the result to
ResultSet format
import java.sql.ResultSet;
We use the method executeQuery()
to execute our queries
ResultSet result = statement.
executeQuery("Select * from employees");
Thank you!
8
0
Are there any code examples left?
New code examples in category Java
-
Java 2022-03-27 21:35:04 Sort string array in case insensitive order and case sensitive order java
-
Java 2022-03-27 21:25:10 java -jar -l resources\es.porperties -i ejemplo.txt -o inject.bin
-
Java 2022-03-27 21:20:21 Debug & Fix a 2-Dimensional Array Java Console Application
-
Java 2022-03-27 20:40:19 TreeSet headSet(E toElement) method in java
-
Java 2022-03-27 19:30:06 close keyboard android
-
Java 2022-03-27 19:20:40 java measure execution time
-
Java 2022-03-27 19:10:06 how to add cardview support in android studio
-
Java 2022-03-27 18:55:08 android studio lower case letters on a button