Skip to content

To load the data present in a dataset to the database in form of table and rows.

Notifications You must be signed in to change notification settings

mundraroshan/Loading-Data-in-Database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Loading-Data-in-Database

JDBC DRIVER

We are loading the data that is present in the dataset to the database by the use of JDBC driver which helps us to interact with our database.

Basic Steps:

we also created a POJO class for the same which would help us to increase the readability and re-usability of our code.

We need to load our dataset file.

Load the JDBC driver.

Read the csv file.

we converted all the other datatypes for date to date data type and perform the rest specific operations.

we would handle all the exceptions and print them.

use of Batch updates for entering values in our database to increase the efficiency.

I have used eclipse environment and MYSQL server with SQLYOG for this project.

About

To load the data present in a dataset to the database in form of table and rows.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages