// registers new user and returns his instance
    public Resolution registerUser()
    {
        try
        {
            PreparedStatement pstmt;

            String url = "jdbc:mysql://localhost:3306/diary";
            Class.forName("com.mysql.jdbc.Driver");

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

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

            String sql = "INSERT INTO user(login, pass, mail, name) VALUES('"+login+"', '"+pass+"', '"+mail+"', '"+name+"')";

            pstmt = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);

            pstmt.executeUpdate();
            // gets last insertionid
            ResultSet rs = pstmt.getGeneratedKeys();

            if (rs.next())
                 this.id = rs.getInt(1);

            con.close();
         }
         catch( Exception e )
         {
             test = e.getMessage();
         }
        return new ForwardResolution("index.jsp");
    }