Results 1 to 3 of 3
  1. #1
    Smiley is offline Member
    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    Smile Help in Java Website.

    Hello all, I'm Max and I'm new to this forum and also new to java. Lately I've been given an assignment to create an online video shop website. I've done the skeletons and so on, now I'm trying to enhance the website for better marks. So if your free, please kindly help! Thank you.

    Currently, I have the sign up/login page done, as well as the add/remove movies. shopping cart(modify/remove quantity), also the admin page which allows to edit
    the price and the stock available.

    I'm currently using NetBeans IDE 6.7.1, with personal glassfish v3 Prelude. I have the database set up too. Those SQL stuff (SELECT WHERE etc)

    So basically, I have several stuffs that I want to implement into the website.

    1) How do I check if if a new username created, if the name has already exist in the database. I think it is to use the select count query but I'm not really sure how and where to use it.

    2) I would like to make implement a admin/customer account. Basically for the customer account, everything will be standard except that you have no access to the admin.jsp. For the admin account, it will be a different page which will have a link going to the admin page as well as everything else. Best is when I log in, there will be a label saying "Welcome (USERNAME)", Account Type : Administrator / Customer. I have a few ideas about this basically maybe using a radio button in the sign up page either selecting Customer or Administrator. After, making a new database specifically for each account type. But I'm not sure how I could do this. Some guide would be nice.

    3) Search Engine. To search for a specific movie title or specific group/genre of movie titles

    4) Tracking customer's purchasing histories and preference.

    This is what I currently have in mind now. Most probably more in time to come. If any of you are free, maybe you could add me on MSN : [email removed by moderator] or reply to this thread to help. Thanks in advance all!
    Last edited by DarrylBurke; 05-24-2012 at 11:19 AM. Reason: Removed email

  2. #2
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,188
    Rep Power
    19

    Default Re: Help in Java Website.

    Please don't solicit off-forum communication, as that defeats the very purpose of a forum, which is to share problems and their possible solutions.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  3. #3
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,820
    Rep Power
    19

    Default Re: Help in Java Website.

    1. Just SELECT for the database using the username in the WHERE clause. Write a method that simply does that and returns true or false - public boolean userExists(String username). Of course you could simply try and create the user using that name and the database should throw an exception (duplicate key) assuming you have the username down as a primary key, or at least marked as UNIQUE if you are using an id as the primary key.

    2. Just have a flag on the account which says whether it is an admin account or not. Do not allow the creation of admin accounts through the normal front end (assuming it is customer facing). Only allow another admin account to add an admin account, that way Joe Bloggs should not be able to add an admin account. This does mean you need a bootstrap admin account. The other option is to simply not allow the creation of admin accounts through that site (which is more normal). They would be created using some internal app.

    3. This would involve having a decent database model, which you;re not likely to get anyone here suggesting, and lots of SQL querying.

    4. Database again.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Build a website using java or php?
    By i4ani in forum Networking
    Replies: 0
    Last Post: 10-28-2011, 08:53 PM
  2. Replies: 4
    Last Post: 07-02-2011, 03:28 AM
  3. Java website
    By Eleeist in forum New To Java
    Replies: 5
    Last Post: 05-05-2011, 09:21 AM
  4. Java and Website
    By Fares in forum Advanced Java
    Replies: 3
    Last Post: 11-14-2010, 02:22 PM
  5. How to download website (Get all link in website)
    By finalmem in forum Advanced Java
    Replies: 0
    Last Post: 11-12-2008, 08:43 AM

Posting Permissions

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