jsp-oracle validation

View Answers

October 1, 2008 at 2:54 PM

Hi friend,

Implement validation code.

<html>
<title>Insert into database</title>
<head>

<script type="text/javascript">

function validateForm(theForm){

if(theForm.userid.value==""){

//Please enter username

alert("Please enter User Name.");

theForm.userid.focus();

return false;

}
if(theForm.password.value==""){
//please enter passward
alert("Please enter Password.");
theForm.password.focus();
return false;
}

return true;
}
</script>
</head>

<body>

<table border="1" width="50%" bgcolor="pink" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="POST" action="/examples/jsp/LoginAction" onsubmit="return validateForm(this);">

<h2 align="center">login page</h2>
<table border="1" width="100%">
<tr>
<td width="50%"><b>User Name:</b></td>
<td width="50%"><input type="text" name="userid" size="20"/></td>
</tr>
<tr>
<td width="50%"><b>Password:</b></td>
<td width="50%"><input type="password" name="password" size="20"/> </td>
</tr>

</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>

</form>
</td>
</tr>
</table>

</body>

</html>

---------------------------------------------

Visit for more information.

http://www.roseindia.net/jsp/

Thanks.

Amardeep

October 1, 2008 at 3:18 PM

Hello

I am try so many times and test different value , but not getting any kind of error.

But one thing,,,,,,,,

statement tryagain try again printed lot of times
so, coding style remove if block from while block. put it separately after while block.

inside first catch block correct e to e1.

Rajanikant
============

October 1, 2008 at 3:29 PM

This is login action code,

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

<%

String userid = request.getParameter("userid");

String password = request.getParameter("password");

Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";

try {

Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);

Statement st = con.createStatement();

String strQuery = "select * from login where userid='"+userid+"' and password='"+password+"'";

out.println(strQuery);

ResultSet rs = st.executeQuery(strQuery);

while(rs.next()){

if((rs.getString(1).equals("admin")) && (rs.getString(2).equals("admin")))

{

session.setAttribute("userid",userid);

response.sendRedirect("userForm.jsp");
}

else{

response.sendRedirect("loginForm.jsp");

}

}

System.out.println("Connected to the database");

con.close();

} catch (Exception e) {

e.printStackTrace();

}

%>

------------------------------