Exel data to DataBase Using JDBC

package upload_download_Excel_Bakchodi;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFFactory;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Excel_To_DB

{

public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hr", "hr");
Statement st = con.createStatement();

con.setAutoCommit(false);
PreparedStatement pstm = null;
FileInputStream fis = new FileInputStream("D:\\work\\Java Work Space\\files\\demo.xlsx");

XSSFWorkbook wb = new XSSFWorkbook(fis);
XSSFSheet sheet = wb.getSheetAt(0);
Row row;

for(int i=1; i<=sheet.getLastRowNum(); i++)
{
row = sheet.getRow(i);

String name = row.getCell(0).getStringCellValue();
String city = row.getCell(1).getStringCellValue();
String hobby = row.getCell(2).getStringCellValue();
String food = row.getCell(3).getStringCellValue();
String id = row.getCell(4).getStringCellValue();
String country  = row.getCell(5).getStringCellValue();

System.out.println(name+" : "+city+" : "+hobby+" : "+food+" : "+id+" : "+country);

String query = "insert into myexel values(?,?,?,?,?,?)";
PreparedStatement ps = con.prepareStatement(query);
ps.setString(1, name);
ps.setString(2, city);
ps.setString(3, hobby);
ps.setString(4, food);
ps.setString(5, id);
ps.setString(6, country);
int res = ps.executeUpdate();
if(res>0)
    System.out.println("Values inserted");
   
}
con.close();
/*
* XSSFFactory fs = new POIFSFileSystem( input ); XSSFWorkbook wb = new
* XSSFWorkbook(fs); XSSFSheet sheet = wb.getSheetAt(0); Row row;
*/
} catch (ClassNotFoundException e) {
System.out.println(e);
} catch (SQLException ex) {
System.out.println(ex);
} catch (IOException ioe) {
System.out.println(ioe);
}

}
}

==================TABLE==================

create table myexel( name varchar(20),
                    city varchar(20),
                    hobby varchar(20),
                    food varchar(20),
                    ID varchar(20),
                    Country varchar(20));
==========================================

Name	city	hobby	food	ID	Country
amit	Ranchi	Football	Fruits	gdf	USA
Sohan	Jaiput	hocky	idly	dfgd	India
Mohan	Mumbai	golf	litty	dfgd	Dubai
Mohan	Mumbai	golf	litty	dfgd	England
Mohan	Mumbai	golf	litty	dfgd	japan

===========================================