• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

Java SentenceExec类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了Java中com.openbravo.data.loader.SentenceExec的典型用法代码示例。如果您正苦于以下问题:Java SentenceExec类的具体用法?Java SentenceExec怎么用?Java SentenceExec使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



SentenceExec类属于com.openbravo.data.loader包,在下文中一共展示了SentenceExec类的19个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: getUpdateSentence

import com.openbravo.data.loader.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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: saveData

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
private void saveData(InventoryRecord rec) throws BasicException {
    
    // A grabar.
    SentenceExec sent = m_dlSales.getStockDiaryInsert();
    
    for (int i = 0; i < m_invlines.getCount(); i++) {
        InventoryLine inv = rec.getLines().get(i);

        sent.exec(new Object[] {
            UUID.randomUUID().toString(),
            rec.getDate(),
            rec.getReason().getKey(),
            rec.getLocation().getID(),
            inv.getProductID(),
            inv.getProductAttSetInstId(),
            rec.getReason().samesignum(inv.getMultiply()),
            inv.getPrice(),
            rec.getUser()
            
        });
    }

    // si se ha grabado se imprime, si no, no.
    printTicket(rec);   
}
 
开发者ID:gnoopy,项目名称:wifepos,代码行数:26,代码来源:StockManagement.java


示例7: getReservationsUpdate

import com.openbravo.data.loader.SentenceExec; //导入依赖的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


示例8: getReservationsInsert

import com.openbravo.data.loader.SentenceExec; //导入依赖的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


示例9: saveData

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
private void saveData(InventoryRecord rec) throws BasicException {

        // A grabar.
        SentenceExec sent = m_dlSales.getStockDiaryInsert();

        for (InventoryLine inv : mergeInventoryLine(rec.getLines())) {
            sent.exec(new Object[]{
                UUID.randomUUID().toString(),
                rec.getDate(),
                rec.getReason().getKey(),
                rec.getLocation().getID(),
                inv.getProductID(),
                inv.getProductAttSetInstId(),
                rec.getReason().samesignum(inv.getMultiply()),
                inv.getPriceBuy()
            });
        }

        // si se ha grabado se imprime, si no, no.
        printTicket(rec);
    }
 
开发者ID:nordpos,项目名称:nordpos,代码行数:22,代码来源:StockManagement.java


示例10: getExecSentence

import com.openbravo.data.loader.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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.SentenceExec; //导入依赖的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: getReservationsDelete

import com.openbravo.data.loader.SentenceExec; //导入依赖的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


示例14: getExecSentence

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
/**
 *
 * @param s
 * @param sql
 * @param indexes
 * @return
 */
public SentenceExec getExecSentence(Session s, String sql, final int... indexes) {
    return new PreparedSentence(s, sql, 
        new SerializerWrite<Object[]>() {
            @Override
            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:gnoopy,项目名称:wifepos,代码行数:20,代码来源:Row.java


示例15: getInsertSentence

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
/**
 *
 * @param s
 * @param t
 * @return
 */
public SentenceExec getInsertSentence(Session s, final Table t) {
    return new PreparedSentence(s,  t.getInsertSQL(), 
        new SerializerWrite<Object[]>() {
            @Override
            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:gnoopy,项目名称:wifepos,代码行数:19,代码来源:Row.java


示例16: getReservationsDelete

import com.openbravo.data.loader.SentenceExec; //导入依赖的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:nordpos,项目名称:nordpos,代码行数:14,代码来源:DataLogicCustomers.java


示例17: SaveProvider

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
/** Creates a new instance of SavePrSentence */
public SaveProvider(SentenceExec sentupdate, SentenceExec sentinsert, SentenceExec sentdelete) {
    m_sentupdate = sentupdate;
    m_sentinsert = sentinsert;
    m_sentdelete = sentdelete;
}
 
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:7,代码来源:SaveProvider.java


示例18: init

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
protected void init() {   
           
    m_paramslocation =  new JParamsLocation();
    m_paramslocation.init(app);
    m_paramslocation.addActionListener(new ReloadActionListener());

    row = new Row(
            new Field("ID", Datas.STRING, Formats.STRING),
            new Field("PRODUCT_ID", Datas.STRING, Formats.STRING),
            new Field(AppLocal.getIntString("label.prodref"), Datas.STRING, Formats.STRING, true, true, true),
            new Field(AppLocal.getIntString("label.prodname"), Datas.STRING, Formats.STRING, true, true, true),
            new Field("LOCATION", Datas.STRING, Formats.STRING),
            new Field("STOCKSECURITY", Datas.DOUBLE, Formats.DOUBLE),
            new Field("STOCKMAXIMUM", Datas.DOUBLE, Formats.DOUBLE),
            new Field("UNITS", Datas.DOUBLE, Formats.DOUBLE)
    );

    lpr = new ListProviderCreator(new PreparedSentence(app.getSession(),
            "SELECT L.ID, P.ID, P.REFERENCE, P.NAME," +
            "L.STOCKSECURITY, L.STOCKMAXIMUM, COALESCE(S.SUMUNITS, 0) " +
            "FROM PRODUCTS P " +
            "LEFT OUTER JOIN (SELECT ID, PRODUCT, LOCATION, STOCKSECURITY, STOCKMAXIMUM FROM STOCKLEVEL WHERE LOCATION = ?) L ON P.ID = L.PRODUCT " +
            "LEFT OUTER JOIN (SELECT PRODUCT, SUM(UNITS) AS SUMUNITS FROM STOCKCURRENT WHERE LOCATION = ? GROUP BY PRODUCT) S ON P.ID = S.PRODUCT " +
            "ORDER BY P.NAME",
            new SerializerWriteBasicExt(new Datas[] {Datas.OBJECT, Datas.STRING}, new int[]{1, 1}),
            new WarehouseSerializerRead()
            ),
            m_paramslocation);
    
    
    SentenceExec updatesent =  new SentenceExecTransaction(app.getSession()) {
        public int execInTransaction(Object params) throws BasicException {
            Object[] values = (Object[]) params;
            if (values[0] == null)  {
                // INSERT
                values[0] = UUID.randomUUID().toString();
                return new PreparedSentence(app.getSession()
                    , "INSERT INTO STOCKLEVEL (ID, LOCATION, PRODUCT, STOCKSECURITY, STOCKMAXIMUM) VALUES (?, ?, ?, ?, ?)"
                    , new SerializerWriteBasicExt(row.getDatas(), new int[] {0, 4, 1, 5, 6})).exec(params);
            } else {
                // UPDATE
                return new PreparedSentence(app.getSession()
                    , "UPDATE STOCKLEVEL SET STOCKSECURITY = ?, STOCKMAXIMUM = ? WHERE ID = ?"
                    , new SerializerWriteBasicExt(row.getDatas(), new int[] {5, 6, 0})).exec(params);
            }
        }
    };     
    
    spr = new SaveProvider(updatesent, null, null);
     
    jeditor = new ProductsWarehouseEditor(dirty);   
}
 
开发者ID:iMartinezMateu,项目名称:openbravo-pos,代码行数:53,代码来源:ProductsWarehousePanel.java


示例19: SaveProvider

import com.openbravo.data.loader.SentenceExec; //导入依赖的package包/类
/** Creates a new instance of SavePrSentence
 * @param sentupdate
 * @param sentdelete
 * @param sentinsert */
public SaveProvider(SentenceExec sentupdate, SentenceExec sentinsert, SentenceExec sentdelete) {
    m_sentupdate = sentupdate;
    m_sentinsert = sentinsert;
    m_sentdelete = sentdelete;
}
 
开发者ID:gnoopy,项目名称:wifepos,代码行数:10,代码来源:SaveProvider.java



注:本文中的com.openbravo.data.loader.SentenceExec类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
Java AssentCallback类代码示例发布时间:2022-05-23
下一篇:
Java DNSResolver类代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap