Skip to main content

Login Demo in jsp with NetBeans & SQL Server

 

Step 1: Open SQL Server –>Create Data Base->Create Table->Insert Value

Step 2: Create Data Base

 

create database JavaTest ( Select line and press F5)
use JavaTest ( Select line and press F5)
Create table Login
(
       username varchar(20),
       userpass varchar(20)
)
insert into Login values('niit','password')
select * from Login
username             userpass             
-------------------- -------------------- 
niit                 password
(1 row(s) affected)

 

Step 3: Create DSN Name for your database follow the my previous blog post http://niitindrapuri.blogspot.in/2012/02/jdbc-demo-login-using-netbeans-and-sql.html

Step 4: Open Netbeans

Add Login.jsp Page
<%-- 
    Document   : Login
    Created on : Mar 21, 2012, 12:15:05 AM
    Author     : dell_pc
--%>
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*" language="java"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
<body bgcolor="pink">
<form name="f1" action="" method="post">
    <table align="center">
<tr>
<td>User Name</td><td><input type="text" name="name" ></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password"  name="pass"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="btnsubmit" value="LogIn"></td>
</tr>
    </table>
<%
String user=request.getParameter("name");
String pass=request.getParameter("pass");
     try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con=DriverManager.getConnection("jdbc:odbc:javadsn", "sa", "niitbpld95");
     Statement st=con.createStatement();
     ResultSet rs=st.executeQuery("select * from login");
     while(rs.next())
         {
         String username=rs.getString(1);
         String password=rs.getString(2);
         if(user.equals(username) && pass.equals(password))
             {
             %>
             <jsp:forward page="LoginSuccess.jsp" />
         <%}
         else
         out.println("Login Failed,Please try Againe");
         %>
         <%
     }
}catch(Exception e1)
{}
%>
</form>
</body>
</html>

 

LoginSuccess.jsp
<%-- 
    Document   : LoginSuccess
    Created on : Mar 21, 2012, 12:20:49 AM
    Author     : dell_pc
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h1>U sucessfuly Entered</h1><br>
        <h2>Welcome to My Blog</h2>
    </body>
</html>

 

Step 5: deploy your project in Tomcat or any other server

Step 6: Run your project

Output

Login

Welcome


Technorati Tags: 
  












Labels:




































Comments









  1. ankitJuly 2, 2013 at 11:14 AM
    not working  

    every input is shows  "Login failed"
    ReplyDelete
  2. Dilip BariJuly 5, 2013 at 3:57 AM
    Have you created DSN ? if still not working send your code in my mail id i.e. dilipbari2001@gmail.com...
    ReplyDelete











Post a Comment



















Popular posts from this blog



















WAP to calculate the monthly telephone bills as per the following rule: Minimum Rs. 200 for upto 100 calls. Plus Rs. 0.60 per call for next 50 calls. Plus Rs. 0.50 per call for next 50 calls. Plus Rs. 0.40 per call for any call beyond 200 calls.




























  #include<iostream.h> #include<conio.h> void  main() { 	 int  calls; 	 float  bill; 	cout<<" Enter number of calls : "; 	cin>>calls; 	 if (calls<=100) 		bill=200; 	 else  if  (calls>100 && calls<=150)   	{      		calls=calls-100;      		bill=200+(0.60*calls); 	} 	 else  if  (calls>150 && calls<=200) 	{ 		calls=calls-150; 		bill=200+(0.60*50)+(0.50*calls);  	} 	 else 	{ 		calls=calls-200; 		bill=200+(0.60*50)+(0.50*50)+(0.40*calls); 	} 	cout<<"  Your bill is Rs. "<<bill; 	getch(); 	 }    Output: Enter number of calls : 190 Your bill is Rs.250   




















6 comments









Read more




























C++ Program to define a Class BOOK and accessing member function using its object.




























  #include<iostream.h> #include<stdio.h> #include<conio.h> class  BOOK { 	 int  BOOKNO; 	 char  BOOKTITLE[20]; 	 float  PRICE; 	 void  TOTAL_COST( int  N) 	{ 		 float  tcost; 		tcost=PRICE*N; 		cout<<tcost; 	} public : 	 void  INPUT() 	{ 		cout<<" Enter Book Number "; 		cin>>BOOKNO; 		cout<<" Enter Book Title "; 		gets(BOOKTITLE); 		cout<<" Enter price per copy "; 		cin>>PRICE; 	}  	 void  PURCHASE() 	{ 		 int  n; 		cout<<" Enter number of copies to purchase "; 		cin>>n; 		cout<<" Total cost is "; 		TOTAL_COST(n); 	} };  void  main() { 	BOOK obj; 	obj.INPUT(); 	obj.PURCHASE(); 	getch(); }     




















8 comments









Read more






























Addition of Two Number using servlet and jsp




























index.jsp      <%@page contentType="text/html" pageEncoding="UTF-8"%> <! DOCTYPE  HTML  PUBLIC  "-//W3C//DTD HTML 4.01 Transitional//EN"    "http://www.w3.org/TR/html4/loose.dtd" > < html >     < head >         < meta  http-equiv ="Content-Type"  content ="text/html; charset=UTF-8" >         < title > JSP Page </ title >     </ head >     < body  bgcolor ="yellow" >         < center >< h1 > Addition of Two Number </ h1 ></ center >         < form  action =" additionservlet "  method ="post" >         < table  border ="0"  width ="100"  align ="center" >                 < tr >                     < td > First Number </ td >                     < td >< input  type ="text"  name ="txtnum1"  value =""  /></ td >       ...




















1 comment









Read more