package server.servlets;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Execute {
    public static String getSql(
            String firstname,
            String middlename,
            String lastname,
            String address1,
            String address2,
            String phone1,
            String phone2,
            String phone3) {

        return "insert into phonelist"
                + "(firstname,middlename, lastname,"
                + "address1,address2,phone1,phone2,phone3) values "
                + "(" + quote(firstname)
                + quote(middlename)
                + quote(lastname)
                + quote(address1)
                + quote(address2)
                + quote(phone1)
                + quote(phone2)
                + nocommaQuote(phone3) + ")";
    }

    public static String nocommaQuote(String s) {
        return "'" + s + "'";
    }

    public static String quote(String s) {
        return "'" + s + "',";
    }

    public static void main(String args[]) {
        // firstname,lastname,"
        //    + "address1,address2,phone1,phone2,phone3
        String sql = getSql("doug", "adams", "lyon", "1313", "mockingbird lane",
                "203-877-0899", "9990999", "1234567");
        System.out.println(sql);
        Execute.statement(sql);
    }

    public static void test1(String args[]) {
        Execute.statement(
                "insert into phonelist(firstname,lastname) values ('doug','lyon')"
        );
    }

    public static void statement(String sql) {
        try {
            String url = server.db.SqlBean.getUrl();
            String driver = server.db.SqlBean.getDriver();
            System.out.println("trying sql statement:" + sql);
            Class.forName(driver).newInstance();
            Connection c = DriverManager.getConnection(
                    url, server.db.SqlBean.getUserId(), server.db.SqlBean.getPassword()
            );
            Statement s = c.createStatement();
            s.execute(sql);
            s.close();
            c.close();
            System.out.println("it worked! Now I am the destroyer of worlds!");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}