Link to home
Start Free TrialLog in
Avatar of Gaute Rønningen
Gaute RønningenFlag for Norway

asked on

WAP & Oracle database

So here's the problem, I'm on a project where we're about to create a Java application which is going to use a Oracle database. We also want the database to be accessible through WAP.

We've been able to make ourselves a Login page.
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">

<wml>
<card title="Login">

<p>
Username: <input name="Username" size="15"/><br/>
Password:  <input name="Password" size="15"/><br/>
</p>

</card>
</wml>

Now we want this is where the database comes in. Checking username and password up against previously added records.
How do we do that?

Any help appreciated,
eX.
Avatar of Gaute Rønningen
Gaute Rønningen
Flag of Norway image

ASKER

Did a little research. We gotta use WMLScript, but neither of us know the WMLScript language and how it operates. Any tutorials on how one is to check input values up against an oracle database?
Hi,

look at here..
http://doug.burns.tripod.com/wap.html
http://nds1.forum.nokia.com/nnds/ ForumDownloadServlet?id=4016&name=Oracle_mobile_WP_en.pdf

i hope it may help you//

R.K
Avatar of virtue79
virtue79

> Did a little research. We gotta use WMLScript, but neither of us know the WMLScript language and how it operates.

Some WMLScript tutorials can be found at:
http://www.developershome.com/wap/wmlscript/
http://www.w3schools.com/wmlscript/default.asp


It should be noted that WMLScript is a client-side scripting language. To check the username and password against the records in a database, I think you need to send the data back to the server first (Have a look here http://www.developershome.com/wap/wml/wmlSendingData.asp). Then use a server-side language like JSP to retrieve the record in the database and compare it with the user data.
ASKER CERTIFIED SOLUTION
Avatar of tomgallo
tomgallo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Another example here using only the cellphone number to login (always using JSP and WAP):

<%
      response.setContentType("text/vnd.wap.wml");
      response.setIntHeader("Expire",-1);
      response.setHeader("Pragma","no-cache");
      response.setHeader("CacheControl","no-cache, must-revalidate");
%>
<%String sUrl=(String)request.getAttribute("wmsUrl");%>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
      <head>
            <meta forua="true" http-equiv="Cache-Control" content="max-age=0"/>
      </head>
      <card id="PhoneLogin">
            <do type="accept" label="Sgte.">
                  <go href="<%=sUrl%>" method="post">
                        <postfield name="event" value="makeloginphone"/>
                        <postfield name="phone" value="$(phone)"/>
                  </go>
            </do>
            <p align="left">
                  Telefono: <input type="text" name="phone" value="" format="N*" maxlength="15" emptyok="false"/>
            </p>
      </card>
</wml>

Hope it helps.
-tom
Sorry a correction on my first answer...
When I said: WAP is like ordinary HTML
I mean: WML is like ordinary HTML

WAP is a protocol (wireless application protocol).

-tom
Vernabili,

I do not think that all answers have the same value this time...
I don't see that a split as the correct closing method in this question.

My answers are more specific and to the point that the others.

That is my point of view,
-tom

Sorry, didn't check EE for awhile...