JDBC

package Model;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

/**
 * Created by WRoslundh on 10/02/16.
 */
public class Jdbc_Singleton
{

    private static Jdbc_Singleton ourInstance =  new Jdbc_Singleton();

    Statement stmt;
    ResultSet rs;
    String sqlString;

    public static Jdbc_Singleton getInstance()
    {
        return ourInstance;
    }

    private Jdbc_Singleton()
    {
        System.out.println("jdbc_single is created");

        try
        {
            //Registrere MySQL DRIVER
            Class.forName("com.mysql.jdbc.Driver");
            //Definerer URL på databaseserver med navn CPC
            //på localhost med default port 3306
            String url = "jdbc:mysql://localhost:3306/CPC?autoReconnect=true&useSSL=false";


            //Forbinder til databasen med url, bruger: root pass: 12345

            Connection con = DriverManager.getConnection(url, "root", "12345");


            // Henter et statement objekt

            stmt = con.createStatement();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }


    public ArrayList<Employee> selectEmployee()
    {
        System.out.println("Trying to select from table employee");
        ArrayList<Employee> employeeArrayList = new ArrayList<>();

        try
        {
            //Query the database and storing the result in an object of type ResultSet
            sqlString = "SELECT * FROM employee ORDER BY employeeID ASC";
            rs = stmt.executeQuery(sqlString);

            //Use the methods of class ResultSet in a loop
            // to display all of the data in the result
            while (rs.next())
            {
                int id = rs.getInt("employeeID");
                String fName = rs.getString("fName");
                String lName = rs.getString("lName");
                String email = rs.getString("email");
                String phone = rs.getString("phone");
                Employee employee = new Employee();
                employee.setEmployeeID(id);
                employee.setfName(fName);
                employee.setlName(lName);
                employee.setEmail(email);
                employee.setPhone(phone);
                employeeArrayList.add(employee);
            }

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        return employeeArrayList;
    }

    public void addEmployee(Employee employee)
    {
        try
        {
            sqlString = "INSERT INTO employee (fName, lName, email, phone) VALUES('" + employee.getfName() + "','" + employee.getlName() + "','" + employee.getEmail() + "','"+employee.getPhone()+"')";
            stmt.executeUpdate(sqlString);

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }


}