package mypackage;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
import java.util.Enumeration;
import java.util.ResourceBundle;

import java.sql.*;

public class Jdbc12 {
    public Connection con;
    public String getCurrentVersion() {
        return "1.2";
    }
    public void Connect() {
        try {
            //Register the JDBC driver for MySQL.
            Class.forName("com.mysql.jdbc.Driver");

            //Define URL of database server for
            // database named mysql on the localhost
            // with the default port number 3306.
            String url =
            "jdbc:mysql://localhost:3306/meetppl";

            //Get a connection to the database for a
            // user named root with a blank password.
            // This user is the default administrator
            // having full privileges to do anything.
            con =
            DriverManager.getConnection(
            url,"root", "rellik00");

        } catch ( Exception e ) {
            System.out.println("exception connecting:"+e.getMessage()); // e.printStackTrace();
        }//end catch
    }

    public String Query(String Q) {
        try {
            Statement stmt;
            stmt = con.createStatement(
            ResultSet.TYPE_SCROLL_INSENSITIVE,
            ResultSet.CONCUR_READ_ONLY);

            ResultSet rs = stmt.executeQuery(Q);

            System.out.println("Display all results:");
            ResultSetMetaData rsMetaData = rs.getMetaData();

            int numberOfColumns = rsMetaData.getColumnCount();
            while(rs.next()){
                for (int i = 1; i<=numberOfColumns; i++) {
                    String str = rs.getString(i);
                    System.out.println(str + "<br>");
                }
            }//end while loop
        } catch ( Exception e ) {
            System.out.println("query except: "+e.toString()+" "+e.getMessage()); // e.printStackTrace();
            e.printStackTrace();
        }//end catch
        return "";
    }

    public ResultSet Query(String Q, Object[] args) {
        try {
            PreparedStatement stmt;
            stmt = con.prepareStatement(
            Q,
            ResultSet.TYPE_SCROLL_INSENSITIVE,
            ResultSet.CONCUR_READ_ONLY);

            for(int i = 0; i < args.length; i++) {
                Object o = args[i];
                if (o.getClass().getName() == "java.lang.String") stmt.setString(i+1, (java.lang.String)args[i]);
                if (o.getClass().getName() == "java.lang.Integer") stmt.setInt(i+1, (java.lang.Integer)args[i]);
                if (o.getClass().getName() == "java.math.BigDecimal") stmt.setBigDecimal(i+1, (java.math.BigDecimal)args[i]);
            }

            ResultSet rs = stmt.executeQuery();

            return rs;

        } catch ( Exception e ) {
            System.out.println("query except: "+e.toString()+" "+e.getMessage()); // e.printStackTrace();
            e.printStackTrace();
        }//end catch
        return null;
    }

    public String Update(String q) {
        try {
            Statement stmt;

            //Get a Statement object
            stmt = con.createStatement();

            stmt.executeUpdate(q);
        } catch ( Exception e ) {
            System.out.println("query except: "+e.toString()+" "+e.getMessage()); // e.printStackTrace();
            e.printStackTrace();
        }//end catch
        return "";
    }//end main

    public void Update(String q, Object[] args) {
        try {
            PreparedStatement stmt;

            //Get a Statement object
            stmt = con.prepareStatement(q);

            for(int i = 0; i < args.length; i++) {
                Object o = args[i];
                if (o.getClass().getName() == "java.lang.String") stmt.setString(i+1, (java.lang.String)args[i]);
                if (o.getClass().getName() == "java.lang.Integer") stmt.setInt(i+1, (java.lang.Integer)args[i]);
                if (o.getClass().getName() == "java.math.BigDecimal") stmt.setBigDecimal(i+1, (java.math.BigDecimal)args[i]);
            }
            stmt.execute();

        } catch ( Exception e ) {
            System.out.println("query except: "+e.toString()+" "+e.getMessage()); // e.printStackTrace();
            e.printStackTrace();
        }//end catch
    }

    public void CloseCon() throws Exception {
        con.close();
    }
}//end class Jdbc12