Create a form of user Login in JSP, that accepts the user
name and password from user and authenticate it with user
names and passwords stored in database.
(Plz provide me answer immediately)
Answer Posted / amit2009mca
first you should to create a jsp
like login.jsp
<%@page language="java"%>
<html>
<head>
<title>fill form</title>
<body>
<form action ="loginservlet.java" mrthod=post>
<input type =text ,name=username ,value="">
<imput type =password,name =password,value="">
</form>
</body>
....
loinservlet.java
import java.io.*;
import javax.servlet.*;
import java.sql.*;
class Loginservlet extends HttpSevlet
{
public void dopost(HttpServletRequest request,
HttpServletResponse response)throws
ServletException,IOException
{
String connectionURL
= "jdbc:mysql://192.168.10.59/datbasename";
Connection connection=null;
ResultSet rs;
String userName=new String("");
String passwrd=new String("");
response.setContentType("text/html");
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection
(connectionURL, "root", "root");
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("usernmae"))
&&
passwrd.equals(request.getParameter
("password"))){
out.println("User Authenticated");
}
else{
out.println("You are not an authentic person");
}
}
}
bydefault the sql run on above port but if you changed it
so please chkit and give the port nuber which you customize
Class.forname(): we pass the string of particular driver
and it automaticaly convert it inot Class object
thanks AMIT SINGH09
Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
Where are local variables stored?
Is it possible to specify multiple jndi names when deploying an ejb?
List any five features of java?
Detail discussions on JVM, memory management and garbage collector.
How can you handle java exceptions?
What is the functionability stubs and skeletons?
What is the size of int in 64-bit jvm?
How does linkedhashmap work in java?
can rmi and corba based applications interact ?
How to access arraylist elements in java?
What is dynamic binding(late binding)?
What are the steps involved to write rmi based programs?
What are the restrictions imposed by a Security Manager on Applets?.
How to display all the prime numbers between 1 and 100
What is a method in coding?