List of execSQL() Examples

Examples of execSQL()

com.sun.faban.harness.agent.OracleAgent.execSQL()
Executes an SQL statement. @param sql The statement @return Whether the SQL statement executed successfully @throws Exception An error occurred in the process
org.blueoxygen.common.dal.DbBean.execSQL()
org.h2.android.H2Database.execSQL()
Execute the given statement. @param sql the statement @param bindArgs the parameter values

Examples of com.sun.faban.harness.agent.OracleAgent.execSQL()


        for (int i = 0; i < serverMachines.length; i++) {


            OracleAgent oracleAgent = (OracleAgent) allAgents.get(serverMachines[i]);
            try {
                if(!oracleAgent.execSQL(command))
                    logger.severe("Failed to exec SQL " + command + " on " + serverMachines[i]);
            } catch (Exception ex) {
                try {
                    logger.severe("Failed to exec SQL " + command + " on " + serverMachines[i] + " " + ex);
                    logger.log(Level.FINE, "Exception", ex);

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                char password[] = new char[100];
                try {
                    DbBean db = new DbBean();
                    db.connect();
                    String mySQL = "SELECT * FROM backend_user WHERE username like '" + lpLogin.getUserName() + "'";
                    ResultSet rs = db.execSQL(mySQL);
                    StringUtils stringutils = new StringUtils();
                    while (rs.next()) {
                        password = (stringutils.decodeBase64(rs.getString("password"))).toCharArray();
                        role_id = rs.getString("role_id");
                    }

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                    DbBean db = new DbBean();                        
                    db.connect();             


                    int id = 0;
                    String mySQL = "SELECT MAX(id) from pos";
                    ResultSet rs = db.execSQL(mySQL);                       
                    while (rs.next()) {
                       id = rs.getInt(1);
                    }             
                    g.drawString("No.",10,20);
                    g.drawString(String.valueOf(id),25,20);

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                    g.drawString("No.",10,20);
                    g.drawString(String.valueOf(id),25,20);
                    
                    int x=5,y=35;
                    mySQL = "SELECT posId, name, quantity, price FROM product_pos a JOIN pos b on a.posId=b.id JOIN product c on c.code=a.productCode WHERE posId = '" + id + "'";
                    rs = db.execSQL(mySQL);
                    while (rs.next()) {
                        name = (rs.getString("name"));
                        qty = (rs.getInt("quantity"));                        
                        subtotal = qty * (rs.getDouble("price"));
                        total = total + subtotal;

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

            if(evt.getKeyCode()=='\n'){
                try {
                    DbBean db = new DbBean();
                    db.connect();
                    String mySQL = "SELECT * FROM items WHERE itemsCode like '" + txtCode.getText() + "'";
                    ResultSet rs = db.execSQL(mySQL);
                    while (rs.next()) {
                        lblName.setText(rs.getString("itemsName"));
                        code = rs.getString("itemsCode");
                        price = Double.parseDouble(rs.getString("price"));
                    }

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                    db.execute(mySQL);
                }


                int id = 0;
                mySQL = "SELECT MAX(id) from pos";
                ResultSet rs = db.execSQL(mySQL);                       
                while (rs.next()) {
                    id = rs.getInt(1);
                }                     


                int transId = 0;

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                    id = rs.getInt(1);
                }                     


                int transId = 0;
                mySQL = "SELECT MAX(id) from pos_transaction";
                rs = db.execSQL(mySQL);                       
                while (rs.next()) {
                    transId = rs.getInt(1);
                }


                int a = model.getRowCount();

View Full Code Here

Examples of org.blueoxygen.common.dal.DbBean.execSQL()

                char password[] = new char[100];
                try {
                    DbBean db = new DbBean();
                    db.connect();
                    String mySQL = "SELECT * FROM backend_user WHERE username = '"+string+"'";
                    ResultSet rs = db.execSQL(mySQL);
                    while (rs.next()) {
                        password = (stringutils.decodeBase64(rs.getString("password"))).toCharArray();
                        user_id = rs.getString("id");
                    }
                    db.close();

View Full Code Here

Examples of org.h2.android.H2Database.execSQL()

        H2Database db = H2Utils.openOrCreateDatabase("helloWorld.db", MODE_PRIVATE, null);
        log("opened ps=" + db.getPageSize());
        try {
            // db.execSQL("DROP TABLE IF EXISTS test");
            // log("dropped");
            db.execSQL("CREATE TABLE if not exists test(ID INTEGER PRIMARY KEY, NAME VARCHAR)");
            log("created");
            for (int j = 0; j < 10; j++) {
                Cursor c = db.rawQuery("select * from test", new String[0]);
                int count = c.getCount();
                for (int i = 0; i < count; i++) {

View Full Code Here

Examples of org.h2.android.H2Database.execSQL()

                    c.getString(1);
                }
                c.close();
            }
            // log("select " + count);
            db.execSQL("delete from test");
            log("delete");
            db.beginTransaction();
            for (int i = 0; i < 1000; i++) {
                db.execSQL("INSERT INTO TEST VALUES(?, 'Hello')", new Object[] { i });
            }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.