
March 26th, 2005, 04:06 AM
|
|
Registered User
|
|
Join Date: Mar 2005
Posts: 2
Time spent in forums: 24 m 29 sec
Reputation Power: 0
|
|
|
Wml and jsp code error
I have a WML page where the user enters his username and password which are passed on to a jsp page that fetches the details from (access) DB and displays the message accordingly.
but the jsp page is not working.The code for both files are:
WML File
Quote: <?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="login" title="LOGIN">
<do type="accept" label="Go!">
<go href="authen.jsp">
<postfield name="loginid" value="$loginid" />
<postfield name="pasword" value="$pasword" />
<p>Enter ID
<input name="loginid" maxlength="15" /><br />
Enter password
<input name="pasword" maxlength="15" type="password" /><br />
</p><p>
<anchor>
<go href="main.wml" />
Home
</anchor>
</p>
</card>
</wml> |
JSP file
Quote: <%@ page language="Java" %>
<%@ page contentType="text/vnd.wap.wml" %>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">
<%@ page contentType="text/vnd.wap.wml" %>
<%@ page import="java.sql.*" %>
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sourceurl = "jdbc dbc:db1";
Connection conn = DriverManager.getConnection(sourceurl);
Statement stat=conn.createStatement();
ResultSet r=stat.executeQuery("SELECT id FROM login WHERE id =" + request.getQueryString(loginid) + "AND password = " + request.getQueryString("pasword"));
if(r) { %>
<wml>
<card id="a" title="Welcome">
<p>Welcome <% request.getParameter(loginid) %>
<% } else %>
Wrong Login
</p>
<%
}
catch(Exception e) {
} %>
</card>
</wml> |
|