bc2

package upload_download_Excel_DB;

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.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ProcessData
{
static String WI_NAME = "1234";
static Connection con= null;

public static void main(String[] args)
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
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("E:\\Root\\Newgen\\ShareCapital.xlsm");

XSSFWorkbook wb = new XSSFWorkbook(fis);

System.out.println("1");
XSSFSheet sheet1 = wb.getSheetAt(0);
int rowcount=sheet1.getLastRowNum();
System.out.println("Rowcount>>"+rowcount);
XSSFRow row ;
System.out.println(">>>>"+sheet1.getLastRowNum());
Cell cell= null;
DataFormatter formatter = new DataFormatter();
for(int i =6; i<=rowcount+1; i++)  //FOR SHEET 1 || SHARE CAPITAL
{
row = sheet1.getRow(i);
if(row!= null)
{
String sno = formatter.formatCellValue(row.getCell(0));
System.out.println(sno);

String class_name = formatter.formatCellValue(row.getCell(1));
//int result = Integer.parseInt(class_name);
System.out.println(class_name);
}
 
 
 



System.out.println("########Before insert_excel_sharedcapital()");

//insert_(WI_NAME,S_No,Share_Class_Number,Share_Class_Code,Currency_Code,Issued_Value,Number_issued,Voting_Rights,Share_Type_Description);
}


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);
}

}
private static void insert_excel_sharedcapital(String WI_NAME,String s_No,
String share_Class_Number, int share_Class_Code,
String currency_Code, String issued_Value, int number_issued,
int voting_Rights, String share_Type_Description)
    {
    System.out.println("Before Inserting into NG_EXP_AR_SCS_CO");

String tableName = "NG_EXP_AR_SCS_CO";
String colNames = "WINAME,s_no,share_class_number,share_class_code,currency_code,issued_value,number_issued,voting_rights,share_type_description";

String colValues = "'"+WI_NAME+",'"+s_No+"','"+share_Class_Number+"',"+share_Class_Code+",'"+currency_Code+"','"+issued_Value+"',"+number_issued+",'"+voting_Rights+"','"+share_Type_Description+",";

//String insertXML = XMLGen.APInsert(objWF.cabinetName, objWF.sessionID, tableName, colValues); //-----------------------------doubt----------------4 PARAMETERS




    }


}