Class BarcodeDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.BarcodeDAO

public class BarcodeDAO
extends CommonDAO

DAO for inventoru_item_barcode — nomenclature barcodes, mostly imported from 1C (barcode register), used to resolve scanner/camera input to an item.

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
BarcodeDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
int	getItemIdByBarcode(String barcode)
void	upsert(String barcode, int itemId)	Binds a barcode to an item; an existing binding of the same barcode is re-pointed.

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

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

Constructor Details

BarcodeDAO

public BarcodeDAO(Connection con)

Method Details

upsert

public void upsert(String barcode,
 int itemId)
            throws SQLException

Binds a barcode to an item; an existing binding of the same barcode is re-pointed.

Throws:

SQLException

getItemIdByBarcode

public int getItemIdByBarcode(String barcode)
                       throws SQLException

Returns:

item id for the barcode, or 0 if unknown.

Throws:

SQLException