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 / 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 |
why the equals method can be override?when we override the equals method?
What is merge sort in java?
Explain when we should make an instance variable private.
When is the finally clause of a try-catch-finally statement executed?
Is java type safe?
what value will be return by the read() method once it reaches the end-of-file? a. Throws EOException b. Return null c. Return -1 d. Read method return nothing, because it is void method
What is the benefit of lambda expressions?
What is thread?
What is mvc in java?
What is the middleware?
For class CFoo { }; what default methods will the compiler generate for you>?
What is the difference between post and put?