Tutorials

Video Tutorial: How to access MySQL through JDBC?

Video instruction of accessing MySQL Database through JDBC

Video instruction of accessing MySQL Database through JDBC

How to access MySQL through JDBC?

The interface that is used to access the Relational databases is called JDBC or Java Database connectivity. It can be used to build a connection, provide the queries of the database and update whenever required.

The below list elucidates the process of accessing MySQL through JDBC

Select a Database

Go to Java EE-Eclipse page and select new then go to project option.

In the new project window select java project option

Give a project name in the new Java project window that appears

Click finish

Copy the mysql-connecor-java-5.1.35-bin.jar that was previous downloaded

In the Java-Eclipse window , right click the new java project and create a new folder and name it lib and paste the mysql-connector-java-5.1.35

Right click the new java project and go to properties

Select java build path

Select libraries and open the Add JAR file

Here is the video tutorial of "How to Access MySQL through JDBC?":

In the JAR selection window you can see the new java project and below the lib option select -connecor-java-5.1.35-bin.jar and click ok

Select src and new and then go to package

In new java package folder add a new name with extension .jdbc

Select he new package folder with extension as .jdbc , go to new and select class

In the new java class folder name it as Access database and select finish.

Copy the code from the metadata and paste it in the accessdatabase.java folder

After pasting it select the entire code from the acessdatabase.java folder and format it

Now check for any errors

If error free, then right click and select run as option.

If successful, you can now access Mysql through JDBC.

You can get more information on various operations for insert, update and delete data from the data base on www.roseindia.net

Ads