Results 1 to 4 of 4

Thread: Urgent!!!

  1. #1
    winnie99's Avatar
    winnie99 is offline Member
    Join Date
    Dec 2009
    Posts
    3
    Rep Power
    0

    Red face Help....

    Hi,

    I have created a mysql database and a jsp website where users fill in their particulars.

    If the users want to change their particulars, they need to login using their hp number.

    So how do I ensure that the hp number that the users had entered matches the hp number stored in the mysql database?

    Any ideas? :confused::confused::confused:
    Last edited by winnie99; 12-18-2009 at 06:44 PM.

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,036
    Rep Power
    20

    Default

    Using a SQL query?

  3. #3
    sridevisala is offline Member
    Join Date
    Nov 2009
    Posts
    8
    Rep Power
    0

    Default compare the parameter

    hi,
    catch the login parameter value when they are entering and compare with the field in table and update the details in the table.



    Regards,
    Sridevi.

  4. #4
    winnie99's Avatar
    winnie99 is offline Member
    Join Date
    Dec 2009
    Posts
    3
    Rep Power
    0

    Default Re:urgent

    Hey, how to catch the login parameter value?
    Any clues? Cause I am new to java:p

    Below are my codes,




    <%@ page import="java.sql.*" %>
    <%@ page import="java.io.*" %>

    <html>
    <head>
    <title>Updating your Particulars</title>
    </head>
    <body>

    <%
    try {

    String connectionURL = "jdbc:mysql://localhost:3306/testing123";


    Connection connection = null;

    Statement stmt = null;
    ResultSet rst = null;


    Class.forName("com.mysql.jdbc.Driver").newInstance ();


    connection = DriverManager.getConnection(connectionURL, "root", "password");

    stmt = connection.createStatement();
    rst = stmt.executeQuery("Select * current_info WHERE HP_No='' ");



    } catch (Exception ex) {
    System.out.println(ex);
    }
    %>


    <h1>Update Particulars </h1>
    <fieldset>
    <legend> Update Page </legend>
    <form method="post" action="Update_particulars.jsp" onsubmit="return checkform()">
    <table border="0" cellpadding="10" cellspacing="0" width="100%" bgcolor="#FFFFFF">
    To update your particulars, please key in your handphone number<p>

    HP Number: <input type="text" name="hpno">
    <input type="submit" value="Go" />


    </form>
    </fieldset>

    </body>
    </html>

    Do I need to add any codes in any where?:confused:

Similar Threads

  1. Help Urgent pls pls pls!!!!
    By jammyjamsticy in forum Java 2D
    Replies: 5
    Last Post: 05-06-2009, 10:55 PM
  2. Help Urgent
    By jammyjamsticy in forum Java 2D
    Replies: 2
    Last Post: 04-06-2009, 07:31 AM
  3. Hi, need some urgent help!
    By jdark in forum New To Java
    Replies: 2
    Last Post: 04-18-2008, 06:50 AM
  4. Help me ...urgent!
    By googgoo in forum New To Java
    Replies: 7
    Last Post: 04-05-2008, 08:46 AM
  5. please help urgent
    By ananas7777 in forum AWT / Swing
    Replies: 2
    Last Post: 12-25-2007, 08:30 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
  •