Java J2EE

In this project we doing user registration, saving user details in database. we used Oracle 10g as database.
To run this project we need following files:
1)web.xml
2)RegForm.jsp
3)RegisterData.java
4)DbConnection.java

1)web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4"

xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<servlet-name>Reg Servlet</servlet-name>

<servlet-class>com.jexamples.web.RegisterData</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>Reg Servlet</servlet-name>

<url-pattern>/RegServ.do</url-pattern>

</servlet-mapping>

<welcome-file-list>

<welcome-file>index.jsp</welcome-file>

</welcome-file-list>

</web-app>

2)RegForm.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

</head>

<h1>Registration Form</h1>

<form name="uForm" method="get" action="RegServ.do">"

<table>

<tr><td colspan="2">Please register here</td></tr>

<tr><td>Enter user id</td><td><input type="text" name="uid" value="" size="25"></td> </tr>

<tr><td>Enter user name</td><td><input type="text" name="uname" value="" size="25"></td> </tr>

<tr><td> Gender</td><td><select name="ugender" size="1">

<option value="f">Female</option>

</select>

</td> </tr>

<tr><td>Enter mobile no.</td><td><input type="text" name="unum" value="" size="25"></td> </tr>

<tr><td>Address</td><td><input type="text" name="uaddr" value="" size="25"></td> </tr>

</table>

<br>

<input type="submit" value="Registe Now!"/>"

</form>

</center>

</body>

</html>

3)RegisterData.java

package com.jexamples.web;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.jexamples.dbconnect.*;

public class RegisterData extends HttpServlet

{

public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException

{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

int count=0;

Connection con=null;

Statement stmt=null;

try

{

con = DbConnection.getConn();

stmt = con.createStatement();

}

catch (Exception e)

{

}

String userid=request.getParameter("uid");

String name=request.getParameter("uname");

String gender=request.getParameter("ugender");

String numb=request.getParameter("unum");

String addr=request.getParameter("uaddr");

try

{

count = stmt.executeUpdate("INSERT INTO BEERTAB VALUES ('"+userid+"','"+name+"','"+gender+"','"+numb+"','"+addr+"')");

}

catch (Exception e)

{

}

if(count > 0)

{

out.println("<h1>Update Successful</h1>");

}

else

{

out.println("<h1>This id not available. Kindly choose other id!!!</h1>");

}

4)DbConnection.java

package com.jexamples.dbconnect;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DbConnection
{
public static Connection getConn() throws ClassNotFoundException, SQLException
{

Class stringClass= Class.forName("oracle.jdbc.driver.OracleDriver");
//if we use "oracle.jdbc.OracleDriver" then also its working.

System.out.println("Class found: "+stringClass.getName());

String url="jdbc:oracle:thin:@localhost:1521:ORCLE";

Connection con=DriverManager.getConnection(url,"scott","tiger");

return con;

}

}

To run this project we need following files:
1)web.xml
2)LForm.jsp
3)LoginServlet.java
4)Success.jsp
5)WForm.jsp
6)BeerSelect.java
7)Failure.jsp

1)web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4"

xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<servlet-name>login servlet</servlet-name>

<servlet-class>com.jexamples.web.LoginServlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>login servlet</servlet-name>

<url-pattern>/SelectForm.do</url-pattern>

</servlet-mapping>

<servlet-name>Ch3 Beer</servlet-name>

<servlet-class>com.jexamples.web.BeerSelect</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>Ch3 Beer</servlet-name>

<url-pattern>/SelectBeer.do</url-pattern>

</servlet-mapping>

<welcome-file-list>

<welcome-file>LForm.jsp</welcome-file>

</welcome-file-list>

</web-app>

2)LForm.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Login Form Page</title>

</head>

<body>

<h1>Please Login</h1>

<hr>

<!-- Never put '/' here like action="/SelectForm.do"

or u will get error HTTP Status 404 - /SelectForm.do

The requested resource (/SelectForm.do) is not available.

-->

<tr>

<td colspan="2"> Please provide correct UserId and Password</td>

</tr>

<tr>

<td>UserName</td>

</tr>

<tr>

<td>Password</td>

</tr>

</table>

</form>

</body>

</html>

3)LoginServlet.java

package com.jexamples.web;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class LoginServlet extends HttpServlet

{

private static final long serialVersionUID = 1L;

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException

{

response.setContentType("text/html");

PrintWriter out=response.getWriter();

String un = request.getParameter("Uname");

String pw = request.getParameter("Pword");

if( ("javaj2eepro".equals(un)) && ("jj").equals(pw))

{

//success

RequestDispatcher view = request.getRequestDispatcher("Success.jsp");

view.include(request, response);

out.println("<h1> <font color='blue'>Congrats..!!!</font><br></h1>");

}

else

{

RequestDispatcher view = request.getRequestDispatcher("Failure.jsp");

view.include(request, response);

out.println("<h1> <font color='red'>Failure..!!!</font><br></h1>");

}

//failure

}

4)Success.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP 'Success.jsp' starting page</title>

</head>

<table>

<tr>

</tr>

</table>

<br>

</form>

</body>

</html>

5)WForm.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Beer Choice</title>

</head>

<br>

<body>

String nNme= request.getParameter("nName");

Cookie cookie = new Cookie("nick",nNme);

cookie.setMaxAge(1*10);

response.addCookie(cookie);

<h1 align="center"> Beer Selection Page</h1>

<hr>

<p>hi <%=nNme %> Plz Select Beer Characteristics <br>

Color:

<option value="light"> light </option>

<option value="amber"> amber </option>

<option value="brown"> brown </option>

</select>

<br>

</form>"

</body>

</html>

6)BeerSelect.java

package com.jexamples.web;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.Cookie;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class BeerSelect extends HttpServlet

{

private static final long serialVersionUID = 1L;

public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException

{

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("Beer Selection Advice <br>");

String c = request.getParameter("color");

out.println("<br> Got Beer Color "+c);

Cookie[] cookies = request.getCookies();

String cName, cValue;

for(int i=0; i< cookies.length; i++)

{

Cookie cookie =cookies[i];

cName = cookie.getName();

cValue = cookie.getValue();

out.println("<br> hi "+cValue+" Thanks for choosing our brand <br>");

out.println("cookie name ="+cName+", cookie value ="+cValue+"<hr>");

}

7)Failure.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP 'Failure.jsp' starting page</title>

</head>

</body>

</html>

Java J2EE

Saturday, 30 April 2011

17)Simple Registration project Using JSP & Servlet and database Oracle 10g

Thursday, 28 April 2011

16) Simple Project on cookies