// adds diary record for this user
    public Boolean addDiaryRecord(String caption, String description, Date started, Date finished)
    {
        try
        {
            Statement stmt;
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/mysql";
            Connection con = DriverManager.getConnection(url,"root", "");

            System.out.println("URL: " + url); // debug
            System.out.println("Connection: " + con);

            stmt = con.createStatement();

            stmt.executeUpdate("INSERT INTO diaryrecord(caption, description, started, finished, iduser) VALUES('"+caption+"', '"+description+"', "+started+", "+finished+", "+this.id+")");

            // gets last insertionid
            ResultSet rs = stmt.getGeneratedKeys();
            int lastInsertedId = rs.getInt(1);

            DiaryRecord dr = new DiaryRecord(lastInsertedId, caption, description, started, finished, this.id);

            con.close();
            return true;
         }
         catch( Exception e )
         {
             System.out.println(e.getStackTrace()); // chyba
         }
        return false;
    }

    // registers new user and returns his instance
    public static User registerUser(String login, String password, String mail, String name)
    {
        User tmpUser = null;
        try
        {
            Statement stmt;
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/mysql";
            Connection con = DriverManager.getConnection(url,"root", "");

            System.out.println("URL: " + url); // debug
            System.out.println("Connection: " + con);

            stmt = con.createStatement();

            stmt.executeUpdate("INSERT INTO user(login, pass, mail, name) VALUES('"+login+"', '"+password+"', '"+mail+"', '"+name+"')");

            // gets last insertionid
            ResultSet rs = stmt.getGeneratedKeys();
            int lastInsertedId = rs.getInt(1);

            tmpUser = new User(lastInsertedId, login, name, mail, name);

            con.close();
         }
         catch( Exception e )
         {
             System.out.println(e.getStackTrace()); // chyba
         }
         return tmpUser;
    }