Posts

Java JDBC CRUD Application in IntelliJ and Maven This JDBC tutorial is going to help you learning how to do basic database operations (CRUD - Create, Retrieve, Update and Delete) using JDBC (Java Database Connectivity) API using maven as a build tool. We will learn how to do insert, query, update and delete database records by writing code to manage records of a table  Employee  in a MySQL database called  crud . Understand the main JDBC interfaces and classes DriverManager : this class is used to register driver for a specific database type (e.g. MySQL in this tutorial) and to establish a database connection with the server via its  getConnection()  method. Connection : this interface represents an established database connection from which we can create statements to execute queries and retrieve results, get metadata about the database, close connection, etc. Statement  and  PreparedStatement : these interfaces are used to execut...