![]() Statement and PreparedStatement : These interfaces are used to execute static SQL query and parameterized SQL query, respectively.Connection: This interface represents an established database connection (session) from which we can create statements to execute queries and retrieve results, get metadata about the database, close connection, etc.Oracle Database in this tutorial) and to establish a database connection with the server via its getConnection() method. DriverManager: This class is used to register driver for a specific database type (e.g.No need of using new or creation of object.Ĭlass.forName("") Class.forName() : Here we load the driver’s class file into memory at the runtime.They are all available under the java.sql package: Let’s take an overview look at the JDBC’s main interfaces and classes which we’ll use in this article. For simplicity we grant database administrator privilege to child user.Ĭreate a sample table with blank fields : CREATE TABLE userid( Grant required permissions to child user.Create a user-id protected by a password. ![]() For that type sqlplus in cmd and press Enter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |