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
- 11760 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
How many threads can java run?
How many return statement are allowed in a function?
Which way a developer should use for creating thread, i.e. Sub classing thread or implementing runnable.
What is class variable java?
Write a program to print the pattern given below
What is the difference amongst jvm spec, jvm implementation, jvm runtime ?
Which class is the superclass for every class in java programming?
What is getclass () getname () in java?
Can we convert integer to string in java?
What are abstract methods in java?
What are strings in physics?
Which is better stringbuffer or stringbuilder?
Can a function return a function?
Which data type is a class in java?
How does compareto work in java?
