ma access reading values

hey ,thanks for my question i have one question: now from login page user needs to login , when he types his "username and password " he has to login . i already created ms access page and inserted values throught servlet and register.jsp now i need code for reading values from "username and password" from my ms access............and detail in register(table in my ms access) need to display values in jsp .............please help me dis is my login.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<html><head>

<link rel="stylesheet" type="text/css" href="css/style.css" />
<script type="text/javascript" src="script/jquery-1.3.1.min.js">
</script>
<script type="text/javascript" src="script/jquery.jclock.js">
</script>
<script type="text/javascript">
    $(function($) {
      var options = {
        format: '%I:%M %p', // 12-hour with am/pm
      }
      $('.clock').jclock(options);
      var options3 = {
        format: '%d-%m-%Y ' // 24-hour
      }
      $('.date').jclock(options3);
    });
  </script>
<style type="text/css">

input.groovybutton
{
   font-size:12px;
  font-family:Comic Sans MS,sans-serif;
   font-weight:bold;
   color:#FFCC00;
   height:32px;
   background-color:transparent;
   border-style:solid;
   border-color:#FFCC00;
   border-width:5px;
}

</style>

<script language="javascript">

function goLite(FRM,BTN)
{
   window.document.forms[FRM].elements[BTN].style.color = "#FFEE99";
   window.document.forms[FRM].elements[BTN].style.backgroundColor = "#1166AA";
   window.document.forms[FRM].elements[BTN].style.borderColor = "#FFEE99";
}

function goDim(FRM,BTN)
{
   window.document.forms[FRM].elements[BTN].style.color = "#FFCC00";
   window.document.forms[FRM].elements[BTN].style.backgroundColor = "transparent";
   window.document.forms[FRM].elements[BTN].style.borderColor = "#FFCC00";
}

</script>

<style type="text/css">

input.groovybutton1
{
   font-size:12px;
  font-family:Comic Sans MS,sans-serif;
   font-weight:bold;
   color:#FFCC00;
   height:32px;
   background-color:transparent;
   border-style:solid;
   border-color:#FFCC00;
   border-width:1px;
}

</style>


<style>

      a{

      font: bold 13px Verdana;

      padding: 2px;

      padding-left: 4px;

      display: block;

      width: 100px;

      color: black;

      text-decoration: underline;

      }

      a:hover{



    color: black;

        text-decoration: none;

      } 

      </style>





      <script>

      function validate()

      {

         if(document.frm.username.value=="")

        {

                 alert("Please enter username");

                 document.frm.username.focus();

                 return false;

        }

         if(document.frm.password.value=="")

        {

                 alert("Please enter username");

                 document.frm.password.focus();

                 return false;

        }

        return true;

      }

      function trim(stringToTrim) {

        return stringToTrim.replace(/^\s+|\s+$/g,"");

      }

      function login()

      { 

        if(validate())

        {



        xmlHttp=GetXmlHttpObject()

        if (xmlHttp==null)

        {

        alert ("Browser does not support HTTP Request")

        return

        }



        var username =document.getElementById("username").value;

        var password =document.getElementById("password").value;







        var url="userloginmid.jsp"

        url=url+"?username="+username+"&password="+password;

        //alert(url);



        xmlHttp.onreadystatechange=stateChanged 

        xmlHttp.open("GET",url,true)

        xmlHttp.send(null)

        }



      }



      function stateChanged() 

      { 



      if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")

 { 



  var showdata = xmlHttp.responseText; 

  var str  = showdata.toString();
   if(trim(str)=="successLogin")

         {

                window.opener.location.reload();

                window.location.reload(); 

                window.close();

         }

         else

         {

                        window.location.href="Login.jsp?errmsg=error";

         }



 } 

      }



      function GetXmlHttpObject()

      {

      var xmlHttp=null;

      try

 {

 // Firefox, Opera 8.0+, Safari

 xmlHttp=new XMLHttpRequest();

 }

      catch (e)

 {

 //Internet Explorer

 try

  {

  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

  }

 catch (e)

  {

  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

  }

 }

      return xmlHttp;

      }



      </script>


</head>

<body background="images/nandu.bmp">

<div id="container" style="height:1000px;width:1300px">

<div id="header" style="background-color:#DEB887; height:100px;width:1300;">
<h1 style="margin-bottom:0;"><center>"Knowledge is Divine"<center></h1>
<div class="date">Date is :</div>
<table align="right" valign="bottom" border="0" width="70" height="70" cellpadding="15" cellspacing="10">
<td>
<form name="groovyform">
<input
   type="button"
   name="groovybtn1"
   class="groovybutton"
   value="SIGN IN" 
   onClick="self.location='sign.jsp'"
   title=""
   onMouseOver="goLite(this.form.name,this.name)"
   onMouseOut="goDim(this.form.name,this.name)">
</form>

</td>
</table>
<table align="right" valign="top" border="0" width="70" height="70" cellpadding="15" cellspacing="10">
<td>
<form name="groovyform1">
<input
   type="button"
   name="groovybtn1"
   class="groovybutton"
   value="SIGN UP"
   onClick="self.location='register.jsp'"
   title=""
   onMouseOver="goLite(this.form.name,this.name)"
   onMouseOut="goDim(this.form.name,this.name)">
</form>
</td>
</table>
</div>
 <br><br>



<form name="login" action="./SessionLogin" method="POST">
 <%
            if (request.getParameter("error")!=null) {
        %>
            Login failed. Please try again.
        <%
            }
        %>

      <table border="0" width="400px" align="left" bgcolor="#CDFFFF" cellpadding="02" cellspacing="02">



      <tr><td colspan=2 align="center"> </td></tr>

      <tr><td colspan=2 align="center"><b>User Login</b></td></tr>

      <tr><td><i>Username :</i> </td><td><input type="text" name="userName" id="username"></td></tr>

      <tr><td><i>Password :</i> </td><td><input type="password" name="passWord" id="password"></td></tr>



      <tr><td width="0"></td>
      <td align="right"><input type="submit" value="Login" name="login" /><input type="submit" value="Cancel" name="cancel" /></td> 
      </tr>

      <tr><td colspan=2 align="center"><a href="register.jsp">New User</a>
      </td></tr>

      </form>

</body>
</html>

now from login page user needs to login , when he types his "username and password " he has to login . i already created ms access page and inserted values throught servlet and register.jsp now i need code for reading values from "username and password" from my ms access............and detail in register(table in my ms access) need to display values in jsp .............please help me

View Answers