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

Java PreparedSentence类代码示例

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

本文整理汇总了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;未经允许,请勿转载。


鲜花

握手

雷人

路过

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

请发表评论

全部评论

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

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

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

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

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