Revise paste Java

------------------------ PRACTICAL 01 --------------------------------
Calculator app using servlet

index.html 
<html><head><title>Calculator App</title></head><body> 
<form action="CalculatorServlet" > 
Enter First Number  
          <input type="text" name="txtN1" ><br> 
Enter Second Number       
 <input type="text" name="txtN2" ><br> 
Select an Operation 
<input type="radio" name="opr" value="+">ADDTION 
<input type="radio" name="opr" value="-">SUBSTRACTION 
<input type="radio" name="opr" value="*">MULTIPLY 
<input type="radio" name="opr" value="/">DIVIDE <br> 
<input type="reset"> 
<input type="submit" value="Calculate" > 
</form></body></html>

CalculatorServlet.java 
package mypack; 
import java.io.IOException; 
import java.io.PrintWriter; 
import javax.servlet.ServletException; 
import javax.servlet.http.HttpServlet; 
import javax.servlet.http.HttpServletRequest; 
import javax.servlet.http.HttpServletResponse; 
public class CalculatorServlet extends HttpServlet { 
public void doGet(HttpServletRequest request, HttpServletResponse response) 
throws ServletException, IOException { 
response.setContentType("text/html;charset=UTF-8"); 
PrintWriter out = response.getWriter(); 
out.println("<html><head><title>Servlet CalculatorServlet</title></head><body>"); 
double n1 = Double.parseDouble(request.getParameter("txtN1")); 
double n2 = Double.parseDouble(request.getParameter("txtN2")); 
double result =0; 
String opr=request.getParameter("opr"); 
if(opr.equals("+")) result=n1+n2;            
if(opr.equals("-")) result=n1-n2; 
if(opr.equals("*")) result=n1*n2;   
out.println("<h1> Result = "+result);          
if(opr.equals("/")) result=n1/n2; 
  out.println("</body></html>");}    }

------------------------ PRACTICAL 02 --------------------------------

Practical 2: Even or odd                                                                                                                                                                  <html>
    <head>
        <title>Even or odd</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="test" method="post">
            Enter the number:<input type="text" name="num" size="20"><br>
            <input type="submit" value="submit">
        </form>
    </body>
</html>                                                                                                                                                                                                  test.java                                                                                                                                                                                                                                                                                                                                                                                                                                                                               package app;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author user
 */
@WebServlet(name = "test", urlPatterns = {"/test"})
public class test extends HttpServlet {

/**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        
         int a =Integer.parseInt(request.getParameter("num"));
         
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
           
            if(a%2 == 0){
                out.println(a+" number is even ");
            }else{
                out.println(a+" number is odd");
            }
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet test</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet test at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }
}

------------------------ PRACTICAL 03 --------------------------------

Practical 3: Factorial                                                                                                                                                                       <html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="factorial" method="post">
            Enter A number to get factorial :<input type="text" name="num" size="20"><br>
            <input type="submit" value="submit">
        </form>
    </body>
</html>                                                                                                                                                                                                   factorial.java                                                                                                                                                                             package app;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "factorial", urlPatterns = {"/factorial"})
public class factorial extends HttpServlet {

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        
        int a = Integer.parseInt(request.getParameter("num"));
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            int fact =1;
           
            for(int i=1;i<=a;i++){
                fact = fact*i;
            }
            out.println("factorial of " + a + " is : "+fact);
            
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet factorial</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet factorial at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }
}

------------------------ PRACTICAL 04 --------------------------------

practical 4 - servlet for login page (no db)

index.html 
<html><head><title>Login Form</title></head> 
<form action="LoginServlet" > 
Enter User ID<input type="text" name="txtId"><br> 
Enter Password<input type="password" name="txtPass"><br> 
<input type="reset"><input type="submit" value=" Click to Login " ></form></html> 
LoginServlet.java 
package mypack; 
import java.io.*; 
import javax.servlet.ServletException; 
import javax.servlet.http.*; 
public class LoginServlet extends HttpServlet { 
public void doGet(HttpServletRequest request, HttpServletResponse response) 
throws ServletException, IOException { 
response.setContentType("text/html;charset=UTF-8"); 
PrintWriter out = response.getWriter(); 
out.println("<html><head><title>Servlet LoginServlet</title></head>"); 
String uname = request.getParameter("txtId"); 
String upass = request.getParameter("txtPass"); 
if(uname.equals("admin") && upass.equals("12345")){ 
out.println("<body bgcolor=blue >"); 
out.println("<h1> Welcome !!! "+uname+"</h1>"); 
} 
else{ 
out.println("<body bgcolor=red >");out.println("<h1> Login Fail !!! </h1>"); 
} 
out.println("</body></html>");}}

------------------------ PRACTICAL 05 --------------------------------

practical 5 - Registration using JDBC in db

index.html 
<html><head><title>Registration Page</title></head> 
<body> 
<form action="RegisterServlet" > 
<H1>Welcome to Registration page</H1> 
Enter User Name     
    <input type="text" name="txtUid"><br> 
Enter Password       
  <input type="password" name="txtPass"><br> 
Enter Email        <input type="text" name="txtEmail" ><br> 
Enter Country        
<input type="text" name="txtCon" ><br> 
<input type="reset" ><input type="submit" value="REGISTER" > 
</form> 
</body>

RegisterServlet.java 
package mypack; 
import java.io.*; 
import java.sql.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
public class RegisterServlet extends HttpServlet { 
public void doGet(HttpServletRequest request, HttpServletResponse response) 
throws ServletException, IOException { 
response.setContentType("text/html;charset=UTF-8"); 
PrintWriter out = response.getWriter(); 
String id = request.getParameter("txtUid"); 
String ps = request.getParameter("txtPass"); 
String em = request.getParameter("txtEmail"); 
String co = request.getParameter("txtCon"); 
try{ 
Class.forName("com.mysql.jdbc.Driver"); 
Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/logindb,'root","root123"); 
PreparedStatement pst = con.prepareStatement("insert into user values(?,?,?,?)"); 
pst.setString(1,id); 
pst.setString(2,ps); 
pst.setString(3,em); 
pst.setString(4,co); 
int row = pst.executeUpdate(); 
out.println("<h1>"+row+ " Inserted Succesfullyyyyy"); 
}catch(Exception e){out.println(e);} 
} 
}

------------------------ PRACTICAL 06 --------------------------------

PRACTICAL 6 - Request Dispatcher

<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="login" method="post">
            Enter Username:<input type="text" name="name"><br>
            Enter Password:<input type="password" name="pass"><br>
            Enter Confirm Password:<input type="text" name="cpass"><br>
            <input type="submit" value="submit">
        </form>
    </body>
</html>

package app;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "login", urlPatterns = {"/login"})
public class login extends HttpServlet {

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        
        String  S1 = request.getParameter("name");
         String S2 = request.getParameter("pass");
         String S3 = request.getParameter("cpass");
         
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            if(S2.equals(S3)){
                RequestDispatcher rd1 =request.getRequestDispatcher("welcome");
                rd1.forward(request, response);
            }else{
                RequestDispatcher rd2 =request.getRequestDispatcher("error");
                rd2.include(request, response);
            }
            
            
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet login</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet login at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }
}

welcome.java             
package app;

@WebServlet(name = "welcome", urlPatterns = {"/welcome"})
public class welcome extends HttpServlet {

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            out.println("welcome user");
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet welcome</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet welcome at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }

}

error.java

package app;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "error", urlPatterns = {"/error"})
public class error extends HttpServlet {

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            out.println("error");
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet error</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet error at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }
}

------------------------ PRACTICAL 07 --------------------------------

practical 7 - cookies

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author user
 */
@WebServlet(name="FirstCookieServlet", urlPatterns={"/FirstCookieServlet"})
public class FirstCookieServlet extends HttpServlet {

response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
           
            out.println("<b>" + firstCookie.getName() + "</b> cookie is created which holds the value <b>" + firstCookie.getValue() + "</b>");
           
           
            /* TODO output your page here. You may use following sample code. */
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet FirstCookieServlet</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet FirstCookieServlet at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }

}

------------------------ PRACTICAL 08 --------------------------------

practical 8 - session

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

@WebServlet(name="DisplaySessionDetailsServlet", urlPatterns={"/DisplaySessionDetailsServlet"})
public class DisplaySessionDetailsServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        HttpSession mySession = request.getSession(true);
        String heading;
        Integer counter = new Integer(0);
        try {
            if (mySession.isNew()) {
                heading = "This is the first time you are visiting this page.";
            }
            else {
                heading = "Welcome back to this page";
                Integer oldCounter = (Integer)mySession.getAttribute("counter");
                if (oldCounter != null) {
                    counter = new Integer(oldCounter.intValue() + 1);
                }
            }
            mySession.setAttribute ("counter", counter);
            out.println("<html><head><title>Displaying Session Details</title></head><body>");
            out.println("<h3>" + heading + "</h3><br>");
            out.println("<b>SESSION ID: </b>" + mySession.getId() + "<br>");
            out.println("<b>Creation Time of the Session: </b>" + new Date(mySession.getCreationTime()) + "<br>");
            out.println("<b>Time of Last Access: </b>" + new Date(mySession.getLastAccessedTime()) + "<br><br>");
            out.println("You have visited this page " + (++counter));
            out.println((counter == 1) ? " time " : " times ");
            out.println("</body></html>");
        } finally {
            out.close();
        }
    }
}

------------------------ PRACTICAL 09 --------------------------------

practical 9 - servlet question answer / quiz app

<body>
        <form action="Process1" method="post">
            Q1) what is 2+2?<br/>
            <input type="radio" name="q1" value="2">2<br/>
              <input type="radio" name="q1" value="3">3<br/>
                <input type="radio" name="q1" value="4">4<br/>
               
                Q2) what is a fruit? <br/>
            <input type="radio" name="q2" value="apple">apple<br/>
              <input type="radio" name="q2" value="carrot">carrot<br/>
                <input type="radio" name="q2" value="tomato">tomato<br/>
               
                Q3which is the animals? <br/>
            <input type="radio" name="q3" value="lion">lion<br/>
              <input type="radio" name="q3" value="crow">crow<br/>
                <input type="radio" name="q3" value="eagle">eagle<br/>
                <input type="submit"  value="check"/>
        </form>
       
    </body>

logic1

IOException {
         
         int correct=0,incorrect=0;
        String a1=request.getParameter("q1");
         String a2=request.getParameter("q2");
          String a3=request.getParameter("q3");

logic2

if(a1.equals("4"))
        {
            correct++;
        }
         
            
        
        else
        {
            incorrect++;
              
        }
        
        if(a2.equals("apple"))
        {
            correct++;
            
            
        }
        else
        {
            incorrect++;
              
        }
        if(a3.equals("lion"))
        {
            correct++;
            
            
        }
        else
        {
            incorrect++;
              
        }
        out.println("Correct : " +correct +"Incorrect : " +incorrect);

------------------------ PRACTICAL 10 --------------------------------

practical 10 - Display Intrinsic Objects

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        
        <h1>Use of Intrinsic Objects in JSP</h1>

<h1>Request Object </h1>
Query String <%=request.getQueryString() %><br>
Context Path <%=request.getContextPath() %><br>
Remote Host <%=request.getRemoteHost() %><br>

<h1>Response Object </h1>
Character Encoding Type <%=response.getCharacterEncoding() %><br>
Content Type <%=response.getContentType() %><br>
Locale <%=response.getLocale() %><br>

<h1>Session Object </h1>
ID <%=session.getId() %><br>
Creation Time <%=new java.util.Date(session.getCreationTime()) %><br>
Last Access Time<%=new java.util.Date(session.getLastAccessedTime()) %><br>
        
        
    </body>
</html>

------------------------ PRACTICAL 11 --------------------------------

practical 11 - simple calculator app using JSP

<!DOCTYPE html>

<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        
<form action="test.jsp" method="post">
Number 1 : <input type="text" name="n1" size="20">
<br>
Number 2 : <input type="text" name="n2" size="20">
<br>
     <input type="submit" name="b" value="Add">      
<input type="submit" name="b" value="Sub"> 
<br>
     <input type="submit" name="b" value="Mul">      
<input type="submit" name="b" value="Div"> 
<br>
</form>

</body>
</html>

jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
   
     <%
int a=Integer.parseInt(request.getParameter("n1"));
int b=Integer.parseInt(request.getParameter("n2"));
String s=request.getParameter("b");

if(s.equals("Add"))
{
out.println("Add is : "+(a+b));
}
else if(s.equals("Sub"))
{
out.println("Sub is : "+(a-b));
}

else if(s.equals("Mul"))
{
out.println("Mul is : "+(a*b));
}
else
{
out.println("Div is : "+(a/b));
}
%>   
        
        
    </body>
</html>

------------------------ PRACTICAL 12 --------------------------------

practical 12

Create a registration and login JSP application to register and authenticate the user based on username and password using JDBC.

<form action="Register.jsp" method="post">
<h1> New User Registration Page</h1>
Enter User Name <input type="text" name="txtName" ><br>
Enter Password <input type="password" name="txtPass1" ><br>
Re-Enter Password<input type="password" name="txtPass2" ><br>
Enter Email<input type="text" name="txtEmail" ><br>
Enter Country Name <input type="text" name="txtCon" ><br>
<input type="reset" ><input type="submit" value="REGISTER" >
</form>

<%@page contentType="text/html" import="java.sql.*"%>
<html><body>
<h1>Registration JSP Page</h1>
<%
String uname=request.getParameter("txtName");
String pass1 = request.getParameter("txtPass1");
String pass2 = request.getParameter("txtPass2");
String email = request.getParameter("txtEmail");
String ctry = request.getParameter("txtCon");
if(pass1.equals(pass2)){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/logindb","root","root123");
PreparedStatement stmt = con.prepareStatement("insert into user values (?,?,?,?)");
stmt.setString(1, uname); stmt.setString(2, pass1);
stmt.setString(3, email); stmt.setString(4, ctry);
int row = stmt.executeUpdate();
if(row==1) { out.println("Registration Successful"); }
else {
out.println("Registration FFFFFAAAIIILLLL !!!!");
%><jsp:include page="Register.html" ></jsp:include>
<%
}
}catch(Exception e){out.println(e);}
}
else
{
out.println("<h1>Password Mismatch</h1>");
%>
<jsp:include page="Register.html" ></jsp:include>
<% }
%>
</body>
</html>

Database name : logindb
table name : user
fields : 1. username  2. password  3. email   4. country

<html>
<body>
<h1>Login Page</h1>
<form action="Login.jsp" method="post">
Enter User Name <input type="text" name="txtName" ><br>
Enter Password <input type="password" name="txtPass" ><br>
<input type="reset" ><input type="submit" value="LOGIN~" >
</form>
</body>
</html>

<%@page contentType="text/html" import="java.sql.*"%>
<html><body>
<h1>Registration JSP Page</h1>
<%
String uname=request.getParameter("txtName");
String pass = request.getParameter("txtPass");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/logindb","root","root123");
PreparedStatement stmt = con.prepareStatement("select password from user where username=?");
stmt.setString(1, uname);
ResultSet rs = stmt.executeQuery();
if(rs.next()){
if(pass.equals(rs.getString(1)))
{
out.println("<h1>~~~ LOGIN SUCCESSFULLL ~~~ </h1>");
}
}
else{
out.println("<h1>User Name not exist !!!!!</h1>");
%>
<jsp:include page="Register.html" ></jsp:include>
<%
}
}catch(Exception e){out.println(e);}
%>
</body>
</html>

(use same database and tables from register code, if already created no need to create else follow following details. ) 
Database name : logindb
table name : user
fields : 1. username  2. password  3. email   4. country

------------------------ PRACTICAL 13 --------------------------------

practical 13

Create a Currency Converter application using EJB.

index.html

<form action="CCServlet" method="post">
Enter Amount <input type="text" name="amt"><br>
Select Conversion Type
<input type="radio" name="type" value="r2d" checked>Rupees to Dollar
<input type="radio" name="type" value="d2r" >Dollor to Rupees<br>
<input type="reset" ><input type="submit" value="CONVERT" >
</form>

CCServlet.java

package mypack;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.ejb.EJB;
import mybeans.CCBean;
public class CCServlet extends HttpServlet {
@EJB CCBean obj;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
double amt = Double.parseDouble(request.getParameter("amt"));
if(request.getParameter("type").equals("r2d"))
{
out.println("<h1>"+amt+ " Rupees = "+obj.r2Dollor(amt)+" Dollors</h1>");
}
if(request.getParameter("type").equals("d2r"))
{
out.println("<h1>"+amt+ " Dollors = "+obj.d2Rupees(amt)+" Rupees</h1>");
}
}}

CCBean.java

package mybeans;
import javax.ejb.Stateless;
@Stateless

public class CCBean {
public CCBean(){}
public double r2Dollor(double r){ return r/65.65; }
public double d2Rupees(double d){ return d*65.65; }
}

------------------------ PRACTICAL 14 --------------------------------

practical 14

Develop a Simple Room Reservation System Application Using EJB.

Create table roombook(RoomId varchar(4) PRIMARY KEY, RoomType varchar(20), charges number(5,2), cust varchar(20), mob varchar(20) , status varchar(10))
insert into roombook values('1001','Delux',5000.00,'','','Not Booked')
insert into roombook values('1002','Super Delux',7000.00,'','','Not Booked')
insert into roombook values('1003','Suit',9500.00,'','','Not Booked')
insert into roombook values('2001','Delux',5000.00,'','','Not Booked')
insert into roombook values('2002','Super Delux',7000.00,'','','Not Booked')
insert into roombook values('2003','Suit',9500.00,'','','Not Booked')

RoomBook.html

<form action="RBServlet">
Select a room Type
<input type="radio" name="txtType" value="Delux">Delux
<input type="radio" name="txtType" value="Super Delux">Super Delux
<input type="radio" name="txtType" value="Suit">Suit<br>
Enter Your Name<input type="text" name="txtCust" ><br>
Enter Mobile No.<input type="text" name="txtMob" ><br>
<input type="reset" ><input type="submit" value="Book Room">
</form>

RBServlet.java

package mypack;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.ejb.EJB;
import mybeans.RRBean;
public class RBServlet extends HttpServlet {
@EJB RRBean obj;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
PrintWriter out=response.getWriter();
String rt=request.getParameter("txtType");
String cn=request.getParameter("txtCust");
String cm=request.getParameter("txtMob");
String msg = obj.roomBook(rt, cn, cm);
out.println(msg);
}}

RRBean.java

package mybeans;
import javax.ejb.Stateless;
import java.sql.*;
@Stateless
public class RRBean {
public RRBean(){}
public String roomBook(String rt, String cn, String cm){
String msg="";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/rrdb","root","root");
String query="select * from roombook where RoomType=? and status='Not Booked'";
PreparedStatement pst = con.prepareStatement(query);
pst.setString(1,rt);
ResultSet rs= pst.executeQuery();
if(rs.next()){
String rno=rs.getString(1);
PreparedStatement stm1 = con.prepareStatement("update roombook set cust=? where RoomId=? ");
PreparedStatement stm2 = con.prepareStatement("update roombook set mobile=? where RoomId=? ");
PreparedStatement stm3 = con.prepareStatement("update roombook set status=? where RoomId=? ");
stm1.setString(1,cn); stm1.setString(2,rno);
stm2.setString(1,cm); stm2.setString(2,rno);
stm3.setString(1, "Booked"); stm3.setString(2,rno);
stm1.executeUpdate();
stm2.executeUpdate();
stm3.executeUpdate();
msg = "Room "+rno+ " Booked <br> Charges = "+rs.getString(3);
}
else
{
msg = "Room "+rt+ " currently Not available";
}
}catch(Exception e){msg=""+e;}
return msg;}}