public static void dbConnect() {
        Connection dbConnection = null;
        Statement statement = null;
        ResultSet rs = null;

        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            System.out.println("MYSQL:s JDBC-drivrutiner hittades. ");
        } catch (Exception e) {
            System.err.println("MYSQL:s JDBC-drivrutiner kunde INTE hittas.");
        }

        //Byt ut databasnamn mot den databas ni vill koppla er mot.
        String url = "jdbc:mysql://atlantis.informatik.umu.se/svph1510_db_ht2016";
        String user = "svph1510_2016264";
        String password = "yryrevasa";

    }

    public static void dbClose() {
        Connection dbConnection = null;
        Statement statement = null;
        ResultSet rs = null;

        try {
            if (rs != null) {
                rs.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (dbConnection != null) {
                dbConnection.close();
            }
        } catch (SQLException ex) {
            System.err.println("Ett fel har uppstått: " + ex.toString());
        }
        System.out.println("Stängd");
    }

    public static void dbInsert(){

        Connection dbConnection = null;
        Statement statement = null;
        ResultSet rs = null;
        String url = "jdbc:mysql://atlantis.informatik.umu.se/svph1510_db_ht2016";
        String user = "svph1510_2016264";
        String password = "yryrevasa";


        try {
            dbConnection = DriverManager.getConnection(url, user, password);
            String strSql = "SELECT flyg, datum FROM avgang ORDER BY flyg";
            statement = dbConnection.createStatement();
            rs = statement.executeQuery(strSql);
            while (rs.next()) {
                System.out.println(rs.getString("flyg") + ", " + rs.getString("datum"));
            }

        } catch (SQLException ex) {
            System.err.println("Ett fel har uppstått: " + ex.toString());
        }

    }