Package org.blueoxygen.common.dal

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

99
100
101
102
103
104
105
106
107
108
109
                role_id="";
                pass="";
                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();
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
            date = cal.get(Calendar.DATE) + "-" + (cal.get(Calendar.MONTH) + 1) + "-" + cal.get(Calendar.YEAR)  ;           
            g.setFont(theFont);
            g.drawString("Postila",80,10);
            try{                                  
                    DbBean db = new DbBean();                       
                    db.connect();            

                    int id = 0;
                    String mySQL = "SELECT MAX(id) from pos";
                    ResultSet rs = db.execSQL(mySQL);                      
                    while (rs.next()) {
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
        if(!txtCode.getText().equalsIgnoreCase("")){
            String code = "";
            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");
View Full Code Here
326
327
328
329
330
331
332
333
334
335
336
    private void jPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jPrintActionPerformed
        if(!txtReturn.getText().equalsIgnoreCase("") || !txtNumber.getText().equalsIgnoreCase("")){
            try {
                DbBean db = new DbBean();     
                db.connect();
                String date = "";
                Calendar cal = new GregorianCalendar();
                date =cal.get(Calendar.YEAR) + "-" + (cal.get(Calendar.MONTH) + 1) + "-" + cal.get(Calendar.DATE)  ;
                String mySQL = "INSERT INTO pos (create_date, pembulatan) VALUES ('" + date + "','" + pembulatan + "')";
                db.execute(mySQL);
View Full Code Here
175
176
177
178
179
180
181
182
183
184
185
            public boolean authenticate(String string, char[] c, String string0) throws Exception {
                StringUtils stringutils = new StringUtils();
                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");
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.