/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package database;

/**
 *
 * @author Erlend, Jakob, Kristian og Payam
 */

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Properties;

public abstract class DBConn {
    protected static Connection conn;
    public DBConn () {
    }
    public static void connect() {
    	try {

            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database.1?autoReconnect=true&useSSL=false","root","vadmyra9394");

            System.out.println("Tilkoblet database");
        } catch (Exception e)
    	{
            throw new RuntimeException("Unable to connect", e);
    	}
    }


    	public static void main(String[] args) {
    		connect();
    		Calendar calendar=new GregorianCalendar(2018,05,06,24,25,33);
    		SimpleDateFormat sdt= new SimpleDateFormat("yyyy MMM dd");

    		Okt okt1=new Okt( 1, 4, 8,calendar,2);

    		okt1.save(conn);
    		okt1.initialize(conn);

    		//System.out.println("oktID: "+okt1.getIdOkt()+" Tidspunkt: " + okt1.getTidspunkt().toString()+" Vargihet: " + okt1.getVarighet());
    		System.out.println(okt1);

    		//System.out.println("oktID: "+okt1.getIdOkt()+" Tidspunkt: " + okt1.getTidspunkt().toString()+" Vargihet: " + okt1.getVarighet());

    	}

}