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

Technorati Tags: jsp

.programmingenhance

Search This Blog

Login Demo in jsp with NetBeans & SQL Server

Labels

Comments

Post a Comment