本文整理汇总了Java中com.openbravo.data.loader.PreparedSentence类的典型用法代码示例。如果您正苦于以下问题：Java PreparedSentence类的具体用法？Java PreparedSentence怎么用？Java PreparedSentence使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
PreparedSentence类属于com.openbravo.data.loader包，在下文中一共展示了PreparedSentence类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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]);
}
}
}
}
);
}
示例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);
}
};
}
示例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;
}
};
}
示例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]);
}
}
}
}
);
}
示例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]);
}
}
}
}
);
}
示例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);
}
示例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);
}
示例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);
}
};
}
示例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;
}
};
}
示例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]]);
}
}
}
);
}
示例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]);
}
}
}
);
}
示例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]);
}
}
}
}
);
}
示例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);
}
示例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);
}
示例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());
}});
}