Package sk.iway.iwcm

Class ExcelImport

java.lang.Object

sk.iway.iwcm.ExcelImport

public abstract class ExcelImport
extends Object

Superclass pre import udajov z excelu do databazy, prvy riadok obsahuje nazvy stlpcov

Field Summary

Fields

Modifier and Type	Field	Description
protected Map<String,Integer>	header
protected InputStream	in
protected PrintWriter	out
protected javax.servlet.http.HttpServletRequest	request
protected int	rowCounter

Constructor Summary

Constructors

Constructor	Description
ExcelImport(InputStream in, javax.servlet.http.HttpServletRequest request, PrintWriter out)

Method Summary

Modifier and Type	Method	Description
boolean	deleteNotUpdated(String tableName)	vymaze z databazy zaznamy, ktore nie su updatnute
void	doImport(String sheetName, Prop prop)
void	doImport(Prop prop)
String	dropQuote(String textPar)	zmaze uvodzovky a apostrofy z textu
static boolean	getBooleanValue(org.apache.poi.hssf.usermodel.HSSFCell cell)	vrati true ak je v bunke napisane ano, pravda, alebo nieco podobne
boolean	getBooleanValue(org.apache.poi.hssf.usermodel.HSSFRow row, String name)
org.apache.poi.hssf.usermodel.HSSFCell	getCell(org.apache.poi.hssf.usermodel.HSSFRow row, String name)
Date	getDateValue(org.apache.poi.hssf.usermodel.HSSFRow row, String name)
static int	getIntValue(org.apache.poi.hssf.usermodel.HSSFCell cell)	vrati celociselnu hodnotu bunky
int	getIntValue(org.apache.poi.hssf.usermodel.HSSFRow row, String name)
String	getValue(org.apache.poi.hssf.usermodel.HSSFRow row, String name)
static String	getValue(org.apache.poi.ss.usermodel.Cell cell)	Ziska hodnotu bunky ako String
void	importSheet(org.apache.poi.hssf.usermodel.HSSFSheet sheet)	vykonanie importu
static void	println(PrintWriter out, String message, int row)
static void	printlnError(PrintWriter out, String message, int row)
protected abstract void	saveRow(Connection db_conn, org.apache.poi.ss.usermodel.Row row)	pridanie riadku do zoznamu riadkov
protected void	setHeader(org.apache.poi.ss.usermodel.Row row)	Nastavi hashtable, ktora prevadza meno na cislo stlpca.
boolean	setUpdateField(String tableName)	Nastavi stlpec updated v databaze v tabulke tableName na false
String	trim(String sPar)	trimne aj tvrde medzery

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

header

protected Map<String,Integer> header

in

protected InputStream in

request

protected javax.servlet.http.HttpServletRequest request

out

protected PrintWriter out

rowCounter

protected int rowCounter

Constructor Details

ExcelImport

public ExcelImport(InputStream in,
 javax.servlet.http.HttpServletRequest request,
 PrintWriter out)

Method Details

setUpdateField

public boolean setUpdateField(String tableName)

Nastavi stlpec updated v databaze v tabulke tableName na false

Parameters:

tableName -

Returns:

deleteNotUpdated

public boolean deleteNotUpdated(String tableName)

vymaze z databazy zaznamy, ktore nie su updatnute

Parameters:

tableName -

Returns:

setHeader

protected void setHeader(org.apache.poi.ss.usermodel.Row row)

Nastavi hashtable, ktora prevadza meno na cislo stlpca. Meno je vzdy lowercase

Parameters:

row -

saveRow

protected abstract void saveRow(Connection db_conn,
 org.apache.poi.ss.usermodel.Row row)
                         throws Exception

pridanie riadku do zoznamu riadkov

Parameters:

row -

Throws:

Exception

doImport

public void doImport(Prop prop)

doImport

public void doImport(String sheetName,
 Prop prop)

importSheet

public void importSheet(org.apache.poi.hssf.usermodel.HSSFSheet sheet)

vykonanie importu

println

public static void println(PrintWriter out,
 String message,
 int row)

printlnError

public static void printlnError(PrintWriter out,
 String message,
 int row)

dropQuote

public String dropQuote(String textPar)

zmaze uvodzovky a apostrofy z textu

Parameters:

textPar -

Returns:

getCell

public org.apache.poi.hssf.usermodel.HSSFCell getCell(org.apache.poi.hssf.usermodel.HSSFRow row,
 String name)

getValue

public String getValue(org.apache.poi.hssf.usermodel.HSSFRow row,
 String name)

getValue

public static String getValue(org.apache.poi.ss.usermodel.Cell cell)

Ziska hodnotu bunky ako String

Parameters:

cell - Description of the Parameter

Returns:

The value value

getIntValue

public int getIntValue(org.apache.poi.hssf.usermodel.HSSFRow row,
 String name)

getIntValue

public static int getIntValue(org.apache.poi.hssf.usermodel.HSSFCell cell)

vrati celociselnu hodnotu bunky

Parameters:

cell -

Returns:

getBooleanValue

public boolean getBooleanValue(org.apache.poi.hssf.usermodel.HSSFRow row,
 String name)

getBooleanValue

public static boolean getBooleanValue(org.apache.poi.hssf.usermodel.HSSFCell cell)

vrati true ak je v bunke napisane ano, pravda, alebo nieco podobne

Parameters:

cell -

Returns:

getDateValue

public Date getDateValue(org.apache.poi.hssf.usermodel.HSSFRow row,
 String name)

Returns:

trim

public String trim(String sPar)

trimne aj tvrde medzery

Parameters:

sPar -

Returns: