Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 1 Answers
- 11690 Views
- ABC, I also Faced
- E-Mail Answers
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
Explain about the interpreter in java?
What are controls and their different types in awt?
How is java hashmap implemented?
Explain numeric promotion?
How are variables stored in memory?
What is methods and methodology?
what is the difference between process and thread? : Java thread
How can constructor chaining be done by using the super keyword?
4.1 Supply contracts (in the form of comments specifying pre- and post conditions) for the enqueue() method of the LinkedQueue class given in the Appendix. (2) 4.2 Let Thing be a class which is capable of cloning objects, and consider the code fragment: Thing thing1 = new Thing(); //(1) Thing thing2 = thing1; //(2) Thing thing3 = (Thing) thing1.clone(); //(3) Explain how the objects thing2 and thing3 differ from each other after execution of the statements. (
If an object reference is set to null, will the garbage collector immediately free the memory held by that object?
What is the super void?
Why javac is not recognized?
Java openings 3 - 5 years, Lnt Infotech. requirements - core java, J2ee, struts, hibernate Interview Date:- 19 March 2011 Time:- 9:00 AM to 12:00 Pm Interview Location - L & T Infotech, Manapakkam, Chennai Refererral PS NO:- 291649 (Please mention this when u fill the form only then u will be considered for interview) Documents Required:- Latest Resume, Photograph and last 3 payslips Mail me on vasan2211@gmail.com once u appear for interview
Differentiate between the constructors and methods in java?
What is difference between length and length() method in java ?
