Package org.blueoxygen.common.dal

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

101
102
103
104
105
106
107
108
109
110
111
                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
44
45
46
47
48
49
50
51
52
53
54
                    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
53
54
55
56
57
58
59
60
61
62
63
                    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
311
312
313
314
315
316
317
318
319
320
321
            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
346
347
348
349
350
351
352
353
354
355
356
                    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
353
354
355
356
357
358
359
360
361
362
363
                    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
177
178
179
180
181
182
183
184
185
186
187
                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
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.