www.webdeveloper.com
Results 1 to 2 of 2

Thread: Registration page

  1. #1
    Join Date
    Sep 2008
    Location
    USA
    Posts
    130

    Registration page

    I am working on a registration page and I have got most of it working but having some trouble with some validation checks.

    I need to make sure that there is not already a person with that userid already in the mysql database. And if there is not then I need to check in another database (oracle) and make sure that that userid they are entering is a valid userid for this site.

    The first check that I am using is a mysql database and the second check is to an oracle database.

    Any help would be great!

    Thanks!
    Happy Code Writing!


    Think, think, think......just like pooh does!

  2. #2
    Join Date
    May 2009
    Posts
    1
    Hi,

    1. You can make one view from two tables and use this code:
    Code:
     public String loginHyp_action() {
            String userid = (String) loginTxt.getText();
            String password = (String) pswdTxt.getText();        
            // refresh to pick up newly added users
            motomanaiDataProvider.refresh();
            RowKey rowKey = motomanaiDataProvider.findFirst(new String[]{"motomanai.nick", "motomanai.pasw"}, new Object[]{userid, password});
            motomanaiDataProvider.setCursorRow(rowKey);
    
            if (rowKey == null) {
                error("Bad login");
                return null;
              } 
            }
            return null;
        }
    2. use this code two times for different dataproviders

    I'm not good java programmer, but it should work

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles