TestBean.java

package Bean;

import java.beans.Beans;
import java.sql.ResultSet;
import java.util.logging.Level;
import java.util.logging.Logger;

public class TestBean {
    public static void main(String[] args){


        //=====================[MySQL]======================
        try {
            System.out.println("=====================[MySQL]======================");
            Jdbc_MySQL dbSql = null;
            dbSql = (Jdbc_MySQL) Beans.instantiate(null, "Bean.Jdbc_MySQL");
            dbSql.init();

            System.out.println("Count: " + dbSql.count("voyageurs"));
            System.out.println("==Select==");
            String request = "Select * from voyageurs";
            Object tuples = dbSql.select(request);
            ResultSet rs = (ResultSet) tuples;
            while(rs.next()){
                String test = rs.getString("nom");
                System.out.println("Nom:" + test);
            }
            /*
            System.out.println("nom 1: " + dbSql.extract(tuples, 1, "nom"));
            System.out.println("nom 2: " + dbSql.extract(tuples, 2, "nom"));
            System.out.println("nom 3: " + dbSql.extract(tuples, 3, "nom"));
            */
            dbSql.closeStatement();

            System.out.println("==Update==");
            request = "Update voyageurs SET nom = 'BLABLA' Where nom = 'albert'";
            dbSql.update(request);
            request = "Select * from voyageurs";
            tuples = dbSql.select(request);
            rs = (ResultSet) tuples;
            while(rs.next()){
                String test = rs.getString("nom");
                System.out.println("Nom:" + test);
            }
            dbSql.closeStatement();

            System.out.println("==Update==");
            request = "Update voyageurs SET nom = 'albert' Where nom = 'BLABLA'";
            dbSql.update(request);
            request = "Select * from voyageurs";
            tuples = dbSql.select(request);
            rs = (ResultSet) tuples;
            while(rs.next()){
                String test = rs.getString("nom");
                System.out.println("Nom:" + test);
            }
            /*
            System.out.println("nom 1: " + dbSql.extract(tuples, 1, "nom"));
            System.out.println("nom 2: " + dbSql.extract(tuples, 2, "nom"));
            System.out.println("nom 3: " + dbSql.extract(tuples, 3, "nom"));
            */
            dbSql.closeStatement();
            //reset
            request = "Update voyageurs SET nom = 'wirth' Where nom = 'BLABLA'";
            dbSql.update(request);

            dbSql.Disconnect();
        } catch (Exception ex) {
            Logger.getLogger(TestBean.class.getName()).log(Level.SEVERE, null, ex);
        }

        /*try {
            System.out.println("=====================[Csv]======================");
            Jdbc_CSV dbCsv = null;
            dbCsv = (Jdbc_CSV) Beans.instantiate(null, "Bean.Jdbc_CSV");
            dbCsv.init();

            int csvCount = dbCsv.count("F_AGENTS");
            System.out.println("Count: " + csvCount);
            System.out.println("==Select==");
            String request = "Select nom from F_AGENTS";
            Object tuples = dbCsv.select(request);
            for(int i = 1; i<=csvCount; i++){
                System.out.println("nom 1: " + dbCsv.extract(tuples, i, "nom"));
            }
            dbCsv.closeStatement();

            //dbCsv.insert("INSERT INTO F_AGENTS VALUES ('coco', 'vil', 0, 'SECRET')");
            dbCsv.Disconnect();
        } catch (Exception ex) {
            Logger.getLogger(TestBean.class.getName()).log(Level.SEVERE, null, ex);
        }*/
    }
}