Posts

Showing posts from December, 2014

Convert Excel to XML in JEXCEL API

package com.relaytemplate.data; import java.io.*; import jxl.*; import jxl.demo.XML; import jxl.read.biff.BiffException; import java.util.*; import java.sql.*; public class ExceltoXML{ // public void readExcelFile() { public static void main(String args[]) throws BiffException, IOException{ File f = new File("TestConsolidated.xml"); OutputStream os = (OutputStream) new FileOutputStream(f); String encoding = "UTF8"; OutputStreamWriter osw = new OutputStreamWriter(os, encoding); String filename = "relaytemplate.xls"; WorkbookSettings ws = new WorkbookSettings(); ws.setLocale(new Locale("en", "EN")); Workbook w = Workbook.getWorkbook(new File(filename), ws); try { XML myxml=new XML(w,os,filename, false); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }

Spring JDBC Template- To get back the inserted values using Keyholder

public List insert(final Action action){ final String insertIntoSql ="INSERT INTO MIPUSER_ACTIONS(IACTIONID, SACTIONNAME) VALUES (nextval('SEQ_MIPUSER_ACTIONS'),?)"; KeyHolder holder = new GeneratedKeyHolder(); jdbcTemplate.update(new PreparedStatementCreator() {                            @Override                 public PreparedStatement createPreparedStatement(Connection connection)                         throws SQLException {                     PreparedStatement ps = connection.prepareStatement(insertIntoSql.toString(), Statement.RETURN_GENERATED_KEYS);                     ps.setString(1, action.getAction_name());                     return ps;                 }             }, holder); KeyHolder newPersonId = holder; System.out.println(newPersonId.getKeyList()); System.out.println(newPersonId.getKeys()); return newPersonId.getKeyList();  }