plz. answer my ques

View Answers

August 24, 2008 at 8:42 PM

can you mention technology in which u want to do i mean for view or it simple console based.

August 25, 2008 at 3:29 PM

create table `user` (
`user` varchar (256),
`password` varchar (256)
);
insert into `user` (`user`, `password`) values('amit','kumar');

Code for validating servlet is given as below:

1. Validation.java

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Validation extends HttpServlet{

private ServletConfig config;

public void init(ServletConfig config)
throws ServletException{
this.config=config;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{

PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://192.168.10.59/messagepaging";;
Connection connection=null;
ResultSet rs;
String userName=new String("");
String passwrd=new String("");
response.setContentType("text/html");
try {
// Load the database driver
Class.forName("com.mysql.jdbc.Driver");
// Get a Connection to the database
connection = DriverManager.getConnection(connectionURL, "root", "root");
//Add the data into the database
String sql = "select user,password from User";
Statement s = connection.createStatement();
s.executeQuery (sql);
rs = s.getResultSet();
while (rs.next ()){
userName=rs.getString("user");
passwrd=rs.getString("password");
}
rs.close ();
s.close ();
}catch(Exception e){
System.out.println("Exception is ;"+e);
}
if(userName.equals(request.getParameter("user"))
&& passwrd.equals(request.getParameter("pass"))){
out.println("User is Valid");
}
else{
out.println("You are not a Valid User");
}
}
}

August 25, 2008 at 5:13 PM

1) first create "retry.jsp" page (this displays login details)
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
</head>
<body>
<form action = "validate.jsp" method = "post">
<p>Username <input type="text" name="userName"/>
<p>Password <input type="password" name="passWord"/>
<input type="submit" value="Login" />
</form>
</body>
</html>

2) and then create "validate.jsp" page
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
<base href="<%=basePath%>">
<body>
<%
String userName = request.getParameter ("userName");
String passWord = request.getParameter("passWord");
%>
<%= userName%><br/>
<%= passWord%><br/>
</head>
</body>
</html>

finally deploy this in the server and run the application
when u enter the username and password it will be displayed in the next page
note: please dont follow the above link because its for different logic
with regards
Fahid

August 25, 2008 at 5:16 PM

i mean dont follow the first logic which was given by me just follow 2nd logic which contains two jsp fils "retry.jsp and validate.jsp"