Category Archives: JDBC

Reading data from database using JDBC Statement

In previous post CRUD(Create,Read,Update and Delete) Operation using JDBC Statement we learnt how to perform insert,read,update and delete operation using JDBC statement.In this post is about Reading data from database using JDBC Statement Project structure in eclipse: SQL Query to create employee_table in MySQL (jdbcdb schema) (Note:Make sure you created employee_table in jdbcdb database schema)

CREATE TABLE `employee_table` (
  `employee_id` int(11) NOT NULL auto_increment,
  `employee_name` varchar(60) NOT NULL,
  `email` varchar(45) NOT NULL,
  `salary` double default NULL,
  `date_of_joining` datetime default NULL,
  `bonus` decimal(10,0) default NULL,
  PRIMARY KEY  (`employee_id`)
) ;

CREATE TABLE `employee_table` (

`employee_id` int(11) NOT NULL auto_increment,

`employee_name` varchar(60) NOT NULL,

`email` varchar(45) NOT NULL,

`salary` double default NULL,

`date_of_joining` datetime default NULL,

`bonus` decimal(10,0) default NULL,

PRIMARY KEY (`employee_id`)

) ;

Suppose we have records in our… Read More »

CRUD(Create,Read,Update and Delete) Operation using JDBC Statement

In last below few posts we learnt about JDBC basics What is Java Database Connectivity (JDBC)? Types of JDBC drivers in java? JDBC MySQL database Connection example JDBC database connection using property resource(property file) In this post we will learn how to perform CRUD(Create,Read,Update and Delete) Operation using Jdbc Statement. In this example I have used… Read More »

JDBC database connection using property resource(property file)

In previous post JDBC MySQL database Connection example we learnt how to connect java program with database using various approaches. In this post we will learn how to segregate database information like database URL,username,password etc. from source code and keeping in .properties file. Project structure in eclipse: Property file(database.properties) which holds database information like database URL,username… Read More »

JDBC MySQL database Connection example

In the previous couple of posts What is Java Database Connectivity (JDBC)? and Types of JDBC drivers in java? We got to know some Jdbc basics. In this post, we will learn how to connect a java program with a database. Here I am using the MYSQL database but you are free to choose any database you… Read More »