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 Loginusername 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 : LoginCreated on : Mar 21, 2012, 12:15:05 AMAuthor : 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" /><%}elseout.println("Login Failed,Please try Againe");%><%}}catch(Exception e1){}%></form></body></html>
LoginSuccess.jsp
<%--Document : LoginSuccessCreated on : Mar 21, 2012, 12:20:49 AMAuthor : 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
not working
ReplyDeleteevery input is shows "Login failed"
Have you created DSN ? if still not working send your code in my mail id i.e. dilipbari2001@gmail.com...
ReplyDelete