Login page in jsp in only one jsp page

-

Prerequisite
------------------------------------

 1)) Import the ojdbc6.jar /ojdbc14.jar filr to the project by using build path-library-add external jar for database connectivity.

 2))Optional--May be some external jar like jsp.api be required

 index.jsp
=============================================================

 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.sql.*;"%>

 <!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
String n=request.getParameter("name");
String p=request.getParameter("pass");
if(n==null || p==null)
{

 %>
<form action="index.jsp" >
Enter name
<br>
<input type="text" name="name" ></input><br>
Enter password<br>
<input type="text" name="pass" ></input><br>
<input type="submit" name="submit" value="Submit"/>
</form>

 <%
}
else
{
String name=request.getParameter("name");
String pass=request.getParameter("pass");
try
{
boolean status=false;

Class.forName("oracle.jdbc.driver.OracleDriver"); 
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe","sandeep","cts");
PreparedStatement pst=con.prepareStatement
("Select * from abc where name=? and pass=?");
pst.setString(1,name);
pst.setString(2,pass);
ResultSet rs=pst.executeQuery();
while(rs.next())
{
status=true;
}
if(status=true)
{
out.print("Valid");
}
else
{
out.print("InValid");
}

}catch(Exception e)
{
e.printStackTrace();
}
}
%>
</body>
</html>

#jsp
#advance Java , J2EE

Comments

Post a Comment

Popular posts from this blog

Git Commands With Output Log

-
Step by step command only Guide where command starts with symbol $ ----------------------------- git config -- global user . name "your username"   git config -- global user . password "your password" Track file : This means the file is added to the git repository in your local machine. Also called added to the stage area. Untracked File : Code is still in your local folder not added to git repository ----------------------------------------------- Commands --------------------------- checking current working directory  rssan@DESKTOP-QA9A7TD MINGW64 ~ $ pwd /c/Users/rssan creating a new directory rssan@DESKTOP-QA9A7TD MINGW64 ~ $ mkdir test getting inside that newly created directory rssan@DESKTOP-QA9A7TD MINGW64 ~ $ cd test creating a new directory inside for git repository rssan@DESKTOP-QA9A7TD MINGW64 ~/test $ mkdir repo getting inside the newly created repo directory rssan@DESKTOP-QA9A7TD MINGW64 ~/test $ cd repo/ Again created a mygitrepo directory inside rss...
Read more

Java Interview Preparation (conceptual)

-
Image
 All Concepts sumerized .... ------------------------------------------------------------- *** Java is partially Object-oriented as it has primitive types. (Primitive i.e. int, float are not the objects, to convert them to use as Object, we use wrapper class) ***Java is platform-independent but JVM dependent. And JVM is platform dependent because for Linux there is a different JVM whereas for windows it's different. _-_____-----___--___--____--- Oo ps Conc ept  _-_____-----___--___--____--- abstraction ,  encapsulation ,  inheritance ,  polymorphism .  Inheritance : Real-World Example : Children have some of the qualities of their parents and grandparents or their ancestors. Java Example: There is a method in the parent class and you want the same method to create in a child class. Why create a new one if it already exists. As a child, you can inherit the method. There are a few variables in a class and you need them .So why to create new variables. We can ...
Read more

Java 8 Function Interface

-
Java.Util.Function ------------------------ Java.Util.Function added in java 8. So let's have a closer look into it. To go through the documentation click the below link. https://docs.oracle.com/javase/8/docs/api/java/util/function/package-summary.html The 4 important topics are , 1. Predicate 2. Consumer   3. Function 4. Supplier A youtube example for better understanding is :  https://www.youtube.com/watch?v=Tapz6_T5oHY Consumer :  --  two methods, accept(T t) and andThen() ** accept(T t) , returns void means no thing returned. It accepts only input. **andThen executes two consumers one after another. #java #java8 #java 8 #java.util.function #javaFunction #java function #java consumer #java predicate #java supplier #java lambda expression
Read more