本文整理汇总了Java中com.openbravo.data.loader.PreparedSentence类的典型用法代码示例。如果您正苦于以下问题:Java PreparedSentence类的具体用法?Java PreparedSentence怎么用?Java PreparedSentence使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
PreparedSentence类属于com.openbravo.data.loader包,在下文中一共展示了PreparedSentence类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。
示例1: getUpdateSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public SentenceExec getUpdateSentence(Session s, final Table t) {
return new PreparedSentence(s, t.getUpdateSQL(),
new SerializerWrite<Object[]>() {
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
int index = 1;
for (int i = 0; i < t.getColumns().length; i++) {
if (!t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
for (int i = 0; i < t.getColumns().length; i++) {
if (t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
}
}
);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:20,代码来源:Row.java
示例2: getReservationsUpdate
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceExec getReservationsUpdate() {
return new SentenceExecTransaction(s) {
public int execInTransaction(Object params) throws BasicException {
new PreparedSentence(s
, "DELETE FROM RESERVATION_CUSTOMERS WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0})).exec(params);
if (((Object[]) params)[3] != null) {
new PreparedSentence(s
, "INSERT INTO RESERVATION_CUSTOMERS (ID, CUSTOMER) VALUES (?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 3})).exec(params);
}
return new PreparedSentence(s
, "UPDATE RESERVATIONS SET ID = ?, CREATED = ?, DATENEW = ?, TITLE = ?, CHAIRS = ?, ISDONE = ?, DESCRIPTION = ? WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 1, 2, 6, 7, 8, 9, 0})).exec(params);
}
};
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:19,代码来源:DataLogicCustomers.java
示例3: getReservationsInsert
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceExec getReservationsInsert() {
return new SentenceExecTransaction(s) {
public int execInTransaction(Object params) throws BasicException {
int i = new PreparedSentence(s
, "INSERT INTO RESERVATIONS (ID, CREATED, DATENEW, TITLE, CHAIRS, ISDONE, DESCRIPTION) VALUES (?, ?, ?, ?, ?, ?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 1, 2, 6, 7, 8, 9})).exec(params);
if (((Object[]) params)[3] != null) {
new PreparedSentence(s
, "INSERT INTO RESERVATION_CUSTOMERS (ID, CUSTOMER) VALUES (?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 3})).exec(params);
}
return i;
}
};
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:18,代码来源:DataLogicCustomers.java
示例4: getDeleteSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
/**
*
* @param s
* @param t
* @return
*/
public SentenceExec getDeleteSentence(Session s, final Table t) {
return new PreparedSentence(s, t.getDeleteSQL(),
new SerializerWrite<Object[]>() {
@Override
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
int index = 1;
for (int i = 0; i < t.getColumns().length; i++) {
if (t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
}
}
);
}
开发者ID:gnoopy,项目名称:wifepos,代码行数:22,代码来源:Row.java
示例5: getUpdateSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
/**
*
* @param s
* @param t
* @return
*/
public SentenceExec getUpdateSentence(Session s, final Table t) {
return new PreparedSentence(s, t.getUpdateSQL(),
new SerializerWrite<Object[]>() {
@Override
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
int index = 1;
for (int i = 0; i < t.getColumns().length; i++) {
if (!t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
for (int i = 0; i < t.getColumns().length; i++) {
if (t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
}
}
);
}
开发者ID:gnoopy,项目名称:wifepos,代码行数:27,代码来源:Row.java
示例6: updateSharedTicket
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
/**
*
* @param id
* @param ticket
* @param pickupid
* @throws BasicException
*/
public final void updateSharedTicket(final String id, final TicketInfo ticket, int pickupid) throws BasicException {
Object[] values = new Object[] {
id,
ticket.getName(),
ticket,
pickupid
};
Datas[] datas = new Datas[] {
Datas.STRING,
Datas.STRING,
Datas.SERIALIZABLE,
Datas.INT
};
new PreparedSentence(s
, "UPDATE SHAREDTICKETS SET "
+ "NAME = ?, "
+ "CONTENT = ?, "
+ "PICKUPID = ? "
+ "WHERE ID = ?"
, new SerializerWriteBasicExt(datas, new int[] {1, 2, 3, 0})).exec(values);
}
开发者ID:gnoopy,项目名称:wifepos,代码行数:30,代码来源:DataLogicReceipts.java
示例7: insertSharedTicket
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
/**
*
* @param id
* @param ticket
* @param pickupid
* @throws BasicException
*/
public final void insertSharedTicket(final String id, final TicketInfo ticket, int pickupid) throws BasicException {
Object[] values = new Object[] {
id,
ticket.getName(),
ticket, pickupid,
ticket.getUser()
};
Datas[] datas;
datas = new Datas[] {
Datas.STRING,
Datas.STRING,
Datas.SERIALIZABLE,
Datas.INT
};
new PreparedSentence(s
, "INSERT INTO SHAREDTICKETS ("
+ "ID, "
+ "NAME, "
+ "CONTENT, "
+ "PICKUPID) "
+ "VALUES (?, ?, ?, ?)"
, new SerializerWriteBasicExt(datas, new int[] {0, 1, 2, 3})).exec(values);
}
开发者ID:gnoopy,项目名称:wifepos,代码行数:32,代码来源:DataLogicReceipts.java
示例8: getReservationsUpdate
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceExec getReservationsUpdate() {
return new SentenceExecTransaction(s) {
public int execInTransaction(Object params) throws BasicException {
new PreparedSentence(s
, "DELETE FROM RESERVATION_CUSTOMERS WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0})).exec(params);
if (((Object[]) params)[3] != null) {
new PreparedSentence(s
, "INSERT INTO RESERVATION_CUSTOMERS (ID, CUSTOMER) VALUES (?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 3})).exec(params);
}
return new PreparedSentence(s
, "UPDATE RESERVATIONS SET ID = ?, CREATED = ?, DATENEW = ?, TITLE = ?, CHAIRS = ?, ISDONE = ?, DESCRIPTION = ? WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 1, 2, 6, 7, 8, 9, 0})).exec(params);
}
};
}
开发者ID:nordpos,项目名称:nordpos,代码行数:19,代码来源:DataLogicCustomers.java
示例9: getReservationsInsert
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceExec getReservationsInsert() {
return new SentenceExecTransaction(s) {
public int execInTransaction(Object params) throws BasicException {
int i = new PreparedSentence(s
, "INSERT INTO RESERVATIONS (ID, CREATED, DATENEW, TITLE, CHAIRS, ISDONE, DESCRIPTION) VALUES (?, ?, ?, ?, ?, ?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 1, 2, 6, 7, 8, 9})).exec(params);
if (((Object[]) params)[3] != null) {
new PreparedSentence(s
, "INSERT INTO RESERVATION_CUSTOMERS (ID, CUSTOMER) VALUES (?, ?)"
, new SerializerWriteBasicExt(customerdatas, new int[]{0, 3})).exec(params);
}
return i;
}
};
}
开发者ID:nordpos,项目名称:nordpos,代码行数:18,代码来源:DataLogicCustomers.java
示例10: getExecSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public SentenceExec getExecSentence(Session s, String sql, final int... indexes) {
return new PreparedSentence(s, sql,
new SerializerWrite<Object[]>() {
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
for (int i = 0; i < indexes.length; i++) {
fields[indexes[i]].getData().setValue(dp, i + 1, obj[indexes[i]]);
}
}
}
);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:12,代码来源:Row.java
示例11: getInsertSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public SentenceExec getInsertSentence(Session s, final Table t) {
return new PreparedSentence(s, t.getInsertSQL(),
new SerializerWrite<Object[]>() {
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
for (int i = 0; i < t.getColumns().length; i++) {
fields[i].getData().setValue(dp, i + 1, obj[i]);
}
}
}
);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:12,代码来源:Row.java
示例12: getDeleteSentence
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public SentenceExec getDeleteSentence(Session s, final Table t) {
return new PreparedSentence(s, t.getDeleteSQL(),
new SerializerWrite<Object[]>() {
public void writeValues(DataWrite dp, Object[] obj) throws BasicException {
int index = 1;
for (int i = 0; i < t.getColumns().length; i++) {
if (t.getColumns()[i].isPK()) {
fields[i].getData().setValue(dp, index++, obj[i]);
}
}
}
}
);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:15,代码来源:Row.java
示例13: updateSharedTicket
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final void updateSharedTicket(final String id, final TicketInfo ticket) throws BasicException {
Object[] values = new Object[] {id, ticket.getName(), ticket};
Datas[] datas = new Datas[] {Datas.STRING, Datas.STRING, Datas.SERIALIZABLE};
new PreparedSentence(s
, "UPDATE SHAREDTICKETS SET NAME = ?, CONTENT = ? WHERE ID = ?"
, new SerializerWriteBasicExt(datas, new int[] {1, 2, 0})).exec(values);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:9,代码来源:DataLogicReceipts.java
示例14: insertSharedTicket
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final void insertSharedTicket(final String id, final TicketInfo ticket) throws BasicException {
Object[] values = new Object[] {id, ticket.getName(), ticket};
Datas[] datas = new Datas[] {Datas.STRING, Datas.STRING, Datas.SERIALIZABLE};
new PreparedSentence(s
, "INSERT INTO SHAREDTICKETS (ID, NAME,CONTENT) VALUES (?, ?, ?)"
, new SerializerWriteBasicExt(datas, new int[] {0, 1, 2})).exec(values);
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:10,代码来源:DataLogicReceipts.java
示例15: updateCustomerExt
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public int updateCustomerExt(final CustomerInfoExt customer) throws BasicException {
return new PreparedSentence(s
, "UPDATE CUSTOMERS SET NOTES = ? WHERE ID = ?"
, SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, customer.getNotes());
setString(2, customer.getId());
}});
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:11,代码来源:DataLogicCustomers.java
示例16: getReservationsList
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceList getReservationsList() {
return new PreparedSentence(s
, "SELECT R.ID, R.CREATED, R.DATENEW, C.CUSTOMER, CUSTOMERS.TAXID, CUSTOMERS.SEARCHKEY, COALESCE(CUSTOMERS.NAME, R.TITLE), R.CHAIRS, R.ISDONE, R.DESCRIPTION " +
"FROM RESERVATIONS R LEFT OUTER JOIN RESERVATION_CUSTOMERS C ON R.ID = C.ID LEFT OUTER JOIN CUSTOMERS ON C.CUSTOMER = CUSTOMERS.ID " +
"WHERE R.DATENEW >= ? AND R.DATENEW < ?"
, new SerializerWriteBasic(new Datas[] {Datas.TIMESTAMP, Datas.TIMESTAMP})
, new SerializerReadBasic(customerdatas));
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:9,代码来源:DataLogicCustomers.java
示例17: getReservationsDelete
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public final SentenceExec getReservationsDelete() {
return new SentenceExecTransaction(s) {
public int execInTransaction(Object params) throws BasicException {
new PreparedSentence(s
, "DELETE FROM RESERVATION_CUSTOMERS WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0})).exec(params);
return new PreparedSentence(s
, "DELETE FROM RESERVATIONS WHERE ID = ?"
, new SerializerWriteBasicExt(customerdatas, new int[]{0})).exec(params);
}
};
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:14,代码来源:DataLogicCustomers.java
示例18: syncCustomer
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public void syncCustomer(final CustomerInfoExt customer) throws BasicException {
Transaction t = new Transaction(s) {
public Object transact() throws BasicException {
// Sync the Customer in a transaction
// Try to update
if (new PreparedSentence(s,
"UPDATE CUSTOMERS SET SEARCHKEY = ?, NAME = ?, NOTES = ?, VISIBLE = " + s.DB.TRUE() + " WHERE ID = ?",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, customer.getSearchkey());
setString(2, customer.getName());
setString(3, customer.getAddress());
setString(4, customer.getId());
}}) == 0) {
// If not updated, try to insert
new PreparedSentence(s,
"INSERT INTO CUSTOMERS(ID, SEARCHKEY, NAME, NOTES, VISIBLE) VALUES (?, ?, ?, ?, " + s.DB.TRUE() + ")",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, customer.getId());
setString(2, customer.getSearchkey());
setString(3, customer.getName());
setString(4, customer.getAddress());
}});
}
return null;
}
};
t.execute();
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:35,代码来源:DataLogicIntegration.java
示例19: syncTaxCategory
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public void syncTaxCategory(final TaxCategoryInfo taxcat) throws BasicException {
Transaction t = new Transaction(s) {
public Object transact() throws BasicException {
// Sync the Tax in a transaction
// Try to update
if (new PreparedSentence(s,
"UPDATE TAXCATEGORIES SET NAME = ? WHERE ID = ?",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, taxcat.getName());
setString(2, taxcat.getID());
}}) == 0) {
// If not updated, try to insert
new PreparedSentence(s,
"INSERT INTO TAXCATEGORIES(ID, NAME) VALUES (?, ?)",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, taxcat.getID());
setString(2, taxcat.getName());
}});
}
return null;
}
};
t.execute();
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:31,代码来源:DataLogicIntegration.java
示例20: syncTax
import com.openbravo.data.loader.PreparedSentence; //导入依赖的package包/类
public void syncTax(final TaxInfo tax) throws BasicException {
Transaction t = new Transaction(s) {
public Object transact() throws BasicException {
// Sync the Tax in a transaction
// Try to update
if (new PreparedSentence(s,
"UPDATE TAXES SET NAME = ?, CATEGORY = ?, CUSTCATEGORY = ?, PARENTID = ?, RATE = ?, RATECASCADE = ? WHERE ID = ?",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, tax.getName());
setString(2, tax.getTaxCategoryID());
setString(3, tax.getTaxCustCategoryID());
setString(4, tax.getParentID());
setDouble(5, tax.getRate());
setBoolean(6, tax.isCascade());
setString(7, tax.getId());
}}) == 0) {
// If not updated, try to insert
new PreparedSentence(s,
"INSERT INTO TAXES(ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE) VALUES (?, ?, ?, ?, ?, ?, ?)",
SerializerWriteParams.INSTANCE
).exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, tax.getId());
setString(2, tax.getName());
setString(3, tax.getTaxCategoryID());
setString(4, tax.getTaxCustCategoryID());
setString(5, tax.getParentID());
setDouble(6, tax.getRate());
setBoolean(7, tax.isCascade());
}});
}
return null;
}
};
t.execute();
}
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:41,代码来源:DataLogicIntegration.java
注:本文中的com.openbravo.data.loader.PreparedSentence类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论