JDBC

Difference between Statement and PreparedStatement in Java

Here you will learn about difference between statement and preparedstatement in Java i.e. Statement vs PreparedStatement. The Java Database Connectivity (JDBC) API is essentially used to connect Java applications with databases. It could be any relational or OLAP database. The JDBC API offers different interfaces to connect to particular databases and execute numerous types of …

Difference between Statement and PreparedStatement in Java Read More »

JDBC Transaction Management in Java with Example

Here you will learn to implement JDBC transaction management in java. By default database is in auto commit mode. That means for any insert, update or delete operation the changes takes place immediately in database. What is Transaction? Transaction involves several sql queries that are considered as one unit. For example money transfer done in …

JDBC Transaction Management in Java with Example Read More »

Servlet Registration Form with MySQL Database Example

Here you will get servlet registration form with mysql database example. This simple registration form include three fields, full name, email and password. If you want you can add more fields. Servlet Registration Form with MySQL Database Example MySQL Database As here we are using mysql database so create a database with name db. Now …

Servlet Registration Form with MySQL Database Example Read More »

Save and Retrieve Image from MySQL Database Using Servlet and JSP

Here you will learn how to save and retrieve image from mysql database using servlet and jsp. This method will work with Servlet 3.0 and MySQL 5.5 and higher versions. Also Read: How to Connect Java (JDBC) with MySQL or Oracle Database Save and Retrieve Image from MySQL Database Using Servlet and JSP Database Create a …

Save and Retrieve Image from MySQL Database Using Servlet and JSP Read More »

Solve java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Error

In this tutorial you will learn to solve java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver error. If you are using jdk 1.8 and trying to connect java with MS Access database then you will get error java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver. This is because java 8 or jdk 1.8 does not support jdbc odbc bridge. To connect with ms access you have to import some …

Solve java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Error Read More »