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 create a table with name user having three fields fname, email and pass of varchar type. Java Project Create a dynamic web project and add following

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 table in mysql database with following schema. Database Name: test Table Name: data Here I have used MEDIUMBLOB datatype to store image in database. It

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 libraries. How to Solve java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Error? 1. Download jars from below link and import in the ide you are using. Link: http://www.mediafire.com/download/ahzw21rrp20qiw8/ucanaccess.rar   Also Read: How

Read more

How to Connect Java (JDBC) with MS Access Database

In this tutorial I will teach you how to connect java (jdbc) with ms access database. MS Access is a part of Microsoft Office and used as database management system (dbms). For making a new database go to MS Access > Blank Database. Give a name to database and click on Create button to create the database. Also Read: How to Connect Java (JDBC) with MySQL or Oracle Database Below example shows jdbc ms access database connectivity. How to Connect Java

Read more

How to Connect Java (JDBC) with MySQL or Oracle Database

In this tutorial you will learn how to connect java (jdbc) with mysql or oracle database. Java JDBC is an API used to connect with database and perform all database related operations.   There are few steps for connecting java with any database. 1. Register Driver Class 2. Create Connection 3. Execute Queries 4. Close Connection   1. Register Driver Class We can register driver class by passing its name in Class.forName() method.   Example:

  Driver class for Oracle: oracle.jdbc.driver.OracleDriver

Read more