NIIT Indrapuri Bhopal

Caching:Varying the Output Cache By Parameter in ASP.NET

noreply@blogger.com (Dilip Bari) — Tue, 22 Oct 2013 23:41:00 -0700

OutPutCacheByPrameter.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OutPutCacheByPrameter.aspx.cs" Inherits="OutPutCacheByPrameter" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Caching; Varying the Output Cache By Parameter</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <asp:GridView ID="grdEmployee" runat="server" AutoGenerateColumns="False"

                ShowHeader="False">

                <Columns>

                 <asp:HyperLinkField DataTextField="EmpName" DataNavigateUrlFields="EmpId"

                DataNavigateUrlFormatString="EmployeeDetails.aspx?EmpId={0}" />

                </Columns>

            </asp:GridView>

    </div>

    </form>

</body>

</html>

Code File:

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class OutPutCacheByPrameter : System.Web.UI.Page

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    DataSet ds = new DataSet();

    SqlDataAdapter da;

    protected void Page_Load(object sender, EventArgs e)

        BindData();

    public void BindData()

        string Appcon = ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;

        con = new SqlConnection(Appcon);

        cmd.CommandText = "Select * from Employees";

        da = new SqlDataAdapter(cmd);

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        da.Fill(ds);

        if (ds.Tables[0].Rows.Count > 0)

            grdEmployee.DataSource = ds;

            grdEmployee.DataBind();

web.config:

<connectionStrings>

        <add name="ConnectionStr" connectionString="Data Source=.;Initial Catalog=asp;User Id=sa;Password=niitbpl123"/>

    </connectionStrings>

Code Behind File:

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class OutPutCacheByPrameter : System.Web.UI.Page

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    DataSet ds = new DataSet();

    SqlDataAdapter da;

    protected void Page_Load(object sender, EventArgs e)

        BindData();

    public void BindData()

        string Appcon = ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;

        con = new SqlConnection(Appcon);

        cmd.CommandText = "Select * from Employees";

        da = new SqlDataAdapter(cmd);

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        da.Fill(ds);

        if (ds.Tables[0].Rows.Count > 0)

            grdEmployee.DataSource = ds;

            grdEmployee.DataBind();

EmployeeDetails.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EmployeeDetails.aspx.cs" Inherits="EmployeeDetails" %>

<%@ OutputCache Duration="5" VaryByParam="none" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>CACHING: Output Cache By Parameter: Employee Details</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <asp:Label ID="lblTime" runat="server"></asp:Label><br />

            <br />

            <asp:DetailsView ID="dtlEmployee" runat="server">

            </asp:DetailsView>

    </div>

    </form>

</body>

</html>

Code Behind File:

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class EmployeeDetails : System.Web.UI.Page

    SqlConnection con;

    SqlCommand cmd = new SqlCommand();

    DataSet ds = new DataSet();

    SqlDataAdapter da;

    protected void Page_Load(object sender, EventArgs e)

        lblTime.Text = System.DateTime.Now.ToString();

        BindData();

    public void BindData()

        string Appcon = ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;

        con = new SqlConnection(Appcon);

        cmd.CommandText = "Select * from Employees where EmpId=" + Request.Params[0].ToString();

        da = new SqlDataAdapter(cmd);

        cmd.Connection = con;

        con.Open();

        cmd.ExecuteNonQuery();

        da.Fill(ds);

        if (ds.Tables[0].Rows.Count > 0)

            dtlEmployee.DataSource = ds;

            dtlEmployee.DataBind();

Output:

What is Caching in ASP.NET.

noreply@blogger.com (Dilip Bari) — Tue, 22 Oct 2013 23:27:00 -0700

What is Caching?
Caching is a technique of persisting the data in memory for immediate access to requesting program calls. Many in the developer community consider caching as one of the features available to improve performance of Web applications.
Why Caching?
Consider a page that has list of Employee name, contact numbers and mail-Ids of existing employees of a company on an intranet accessible by all employees. This is very useful information that is available throughout the company and could also be one of the most accessed pages. The functionality of adding, updating or deleting is usually less intensive compared to more transaction-based systems like Purchase ordering, Voucher creation etc. Now in a normal scenario the process of querying database for each request is not cost-effective in terms of server resources, hence is lot better to cache or persist the data to avoid this costly loss of resources.

The .NET Advantage
ASP.NET provides the flexibility in terms of caching at different levels.
1. Page Level Output Caching
This is at the page level and one of the easiest means for caching pages. This requires one to specify Duration of cache and Attribute of caching.
Syntax: <%@ OutputCache Duration="60" VaryByParam="none" %>
The above syntax specifies that the page be cached for duration of 60 seconds and the value "none" for VaryByParam* attribute makes sure that there is a single cached page available for this duration specified.

2. Fragment Caching
Even though this definition refers to caching portion/s of page, it is actually caching a user control that can be used in a base web form page. In theory, if you have used include files in the traditional ASP model then this caching model is like caching these include files separately. In ASP.NET more often this is done through User Controls. Initially even though one feels a bit misleading, this is a significant technique that can be used especially when implementing "n" instances of the controls in various *.aspx pages. We can use the same syntax that we declared for the page level caching as shown above, but the power of fragment caching comes from the attribute "VaryByControl". Using this attribute one can cache a user control based on the properties exposed.
Syntax: <%@ OutputCache Duration="60" VaryByControl="DepartmentId" %>
The above syntax when declared within an *.ascx file ensures that the control is cached for 60 seconds and the number of representations of cached control is dependant on the property "DepartmentId" declared in the control.

3. Application Level Caching
With Page level Output caching one cannot cache objects between pages within an application. Fragment caching is great in that sense but has limitations by using user controls as means to do. We can use the Cache object programmatically to take advantage of caching objects and share the same between pages. Further the availability of different overloaded methods gives a greater flexibility for our Cache policy like Timespan, Absolute expiration etc. But one of the biggest takes is the CacheDependancy. This means that one can create a cache and associate with it a dependency that is either another cache key or a file.

Program 1: VarByParam=”none”

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ OutputCache Duration="5" VaryByParam="none" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>CACHING: Page Output Caching</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

       <asp:Label ID="lblTime" runat="server"></asp:Label>

    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />

    </div>

    </form>

</body>

</html>

Code Behind file:

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page

    protected void Page_Load(object sender, EventArgs e)

    protected void Button1_Click(object sender, EventArgs e)

        lblTime.Text = DateTime.Now.ToString();

Output:

Program 2: VarByParam=”TextBox1”

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<%@ OutputCache Duration="8" VaryByParam="TextBox1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <asp:Label ID="lblTime" runat="server"></asp:Label>

    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />

    </div>

    </form>

</body>

</html>

Code Behind file:

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class Default2 : System.Web.UI.Page

    protected void Page_Load(object sender, EventArgs e)

    protected void Button1_Click(object sender, EventArgs e)

        lblTime.Text = DateTime.Now.ToString();

Output:

Enter the Name in textbox and click the button yon will see the time

Note: Wile changing the name in textbox time will change

While selecting combobox value display the data from database using Ajax and jsp

noreply@blogger.com (Dilip Bari) — Mon, 12 Aug 2013 02:32:00 -0700

First Create table in database
create table studentinfo
(
    name varchar(20),
    branch varchar(20),
    year varchar(4),
    email varchar(20)
)

insert into studentinfo values('Satyam','CSE','2013','satyam@gmail.com')
insert into studentinfo values('Anand','CSE','2013','anand@gmail.com')
Now create home.jsp page

<%@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>

   1:  
   2: function showuser(str)
   3: {
   4: var xreq;
   5: if(str=="")
   6: {
   7: document.getElementById("showtext").innerHTML="Plase Select Name";
   8: return;
   9: }
  10:  
  11: if(window.XMLHttpRequest)
  12: {
  13: xreq=new XMLHttpRequest();
  14: }
  15: else
  16: {
  17: xreq=new ActiveXObject("Microsoft.XMLHTTP");
  18: }
  19: xreq.onreadystatechange=function ()
  20: {
  21: if( (xreq.readyState==4) && (xreq.status==200) )
  22: {
  23: document.getElementById("showtext").innerHTML=xreq.responseText;
  24:  
  25: }
  26: }
  27: xreq.open("get","getuser.jsp?q="+str,"true");
  28: xreq.send();
  29:  
  30: }
</script>

</head>
<body>
<form>
<select name="user" onchange="showuser(this.value)" >
<option value="">Select Student name....</option>
<option value="Satyam">Satyam</option>
<option value="Anand">Anand</option>
<option value="Shruti">Shruti</option>
<option value="Diksha">Diksha</option>
<option value="Shweta">Shweta</option>
</select>
</form>
<br />
<div id="showtext">The response will come here</div>
</body>
</html>

Now create one more jsp page

getuser.jsp

<%@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">

<%@page import="java.text.SimpleDateFormat"%>

<%@page import="java.util.*,java.sql.*,java.io.*" %>

<%@page import="javax.servlet.*" %>

<%@page import="javax.servlet.http.*" %>

<html>

<head>

</head>

<body>

   1: ! Connection con; 
%>

   1: ! Statement s; 
%>

   1: ! ResultSet rs; 
%>

   1:  String name=request.getParameter("q");
   2:  
   3: try{
   4:  
   5: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   6:  
   7: con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=j2ee","sa","niitbpl123");
   8:  
   9: s=con.createStatement();
  10:  
  11: rs=s.executeQuery("select * from studentinfo where name='"+name+"'");
  12:  
  13: }catch(Exception e){ e.printStackTrace(); }
%>

<table border='3' cellpadding='5'

cellspacing='2' width="400px">

<tr bgcolor="66FF00">

<th>Name</th>

<th>Branch</th>

<th>Year</th>

<th>Email id</th>

</tr>

<tr>

<%

   1:  while(rs.next())
   2: { 
%>

   1:  } 
%>

</tr>

</table></div>

</body>

</html>

Output:

Check user name available or already exists in database while creating Registration form in jsp using AJAX like gmail

noreply@blogger.com (Dilip Bari) — Mon, 12 Aug 2013 02:10:00 -0700

First Create login table in sql server
create table login
(
name varchar(20),
password varchar(20)
)
insert into login values('dilip','niit')
Now Create jsp page:
ajaxcheck.jsp

<%@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><title>welcome</title>

    <script language="javascript">

        reqObj=null;

        function varify(){

            document.getElementById("res").innerHTML="Checking";

            if(window.XMLHttpRequest){

                reqObj=new XMLHttpRequest();

            }else {

                reqObj=new ActiveXObject("Microsoft.XMLHTTP");

            reqObj.onreadystatechange=process;

            reqObj.open("POST","usercheck.jsp?id="+document.getElementById("username").value,true);

            reqObj.send(null);

}
function process(){
if(reqObj.readyState==4){
document.getElementById("res").innerHTML=reqObj.responseText;

}

        </script>

    </head>

    <body>

        <h1>welcome to this application</h1>

    <form>

        User Name<input type="text" name="t1" id="username" onblur="varify();"><span id="res"></span><br/>

        First Name<input type="text" name="t2" ><br/>

        Last Name<input type="text" name="t3"><br/>

        Email<input type="text" name="t4"><br/>

        Password<input type="password" name="t5"><br/>

        <input type ="submit" value="Press"/>

    </form>

    </body>

</html>

Now create usercheck.jsp

<%@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">

<%@page import="java.util.*,java.sql.*,java.io.*" %>

<%@page import="javax.servlet.*" %>

<%! Connection con; %>

<%! Statement s; %>

<%! ResultSet rs; %>

<%

String user=request.getParameter("id");

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=j2ee","sa","niitbpl123");

s=con.createStatement();

rs=s.executeQuery("select name from login where name='"+user+"'");

if(rs.next())

        Thread.sleep(1000);

        if(user.equals(rs.getString(1))

%>

        <font color="red" ><strong>User already exists</strong></font>

<%

else

        Thread.sleep(1000);

%>

<font color="green" ><strong>User  name available</strong></font>

<%

catch(Exception e)
{
e.printStackTrace();
}
%>

Output:

Technorati Tags: ajax & java script,jsp

How to use JSON(JavaScript Object Notation) in NetBeans

noreply@blogger.com (Dilip Bari) — Mon, 12 Aug 2013 01:17:00 -0700

JSON: JavaScript Object Notation.

JSON is syntax for storing and exchanging text information. Much like XML.

JSON is smaller than XML, and faster and easier to parse.

First Create simple jsp page in netbeans:

index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!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>AJAX calls to Servlet using JQuery and JSON</title>
<script src="http://code.jquery.com/jquery-latest.min.js"></script>   1:  
   2: <script>
   3:     $(document).ready(function() {
   4:         $('#country').change(function(event) {
   5:         var $country=$("select#country").val();
   6:            $.get('ActionServlet',{countryname:$country},function(responseJson) {
   7:             var $select = $('#states');
   8:                $select.find('option').remove();
   9:                $.each(responseJson, function(key, value) {
  10:                    $('<option>').val(key).text(value).appendTo($select);
  11:                     });
  12:             });
  13:         });
  14:     });
</script></head><body><h1>AJAX calls to Servlet using JQuery and JSON</h1>Select Country: <select id="country"><option>Select Country</option><option value="India">India</option><option value="US">US</option></select><br/><br/>Enter:  <select id="states"><option>Select State</option></select> </body></html>

ActionServlet.java

package ajaxdemo;
import com.google.gson.Gson;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class ActionServlet extends HttpServlet {
   
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
   String country=request.getParameter("countryname");
  Map<String, String> ind = new LinkedHashMap<String, String>();
     ind.put("1", "New delhi");
     ind.put("2", "Tamil Nadu");
     ind.put("3", "Kerala");
     ind.put("4", "Andhra Pradesh");

     Map<String, String> us = new LinkedHashMap<String, String>();
     us.put("1", "Washington");
     us.put("2", "California");
     us.put("3", "Florida");
     us.put("4", "New York");
     String json = null ;
     if(country.equals("India")){
      json= new Gson().toJson(ind);
     }
     else if(country.equals("US")){
      json=new Gson().toJson(us);
     }
     response.setContentType("application/json");
     response.setCharacterEncoding("UTF-8");
     response.getWriter().write(json);

        } finally { 
            out.close();
        }
    }

Download JSON Jar file.

Output:

Technorati Tags: AJAX & JSON

Managing Session using Servlet session API

noreply@blogger.com (Dilip Bari) — Wed, 10 Jul 2013 23:49:00 -0700

You can use the classes and interfaces defined in the Servlet Session API to create and manage user sessions. Various interfaces provided by Servlet Session API to create and manage user session are, javax.servlet.http.HttpSession,
javax.servlet.http.HttpSessionListener, and
javax.servlet.http.HttpSessionBindingListener.
The javax.servlet.http.HttpSession interface provides methods for tracking the
session of a user. You can create an object of HttpSession interface to store session information as name/value pairs. You can later retrieve this information to manage user sessions.

httpservlet.html

<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <form action="httpServlet">
Name:<input type="text" name="userName"/><br/>
<input type="submit" value="go"/>
</form>
  </body>
</html>

httpServlet.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;
import javax.servlet.http.HttpSession;

/**
 *
 * @author Dilip
 */
public class httpServlet 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
        String n=request.getParameter("userName");
        out.println("Dear "+ n +"Your user name has been set as an attribute to the session");
        HttpSession session=request.getSession();
        session.setAttribute("uname",n);
        out.print("<a href='httpServlet1'>visit</a>");
        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

httpServlet1.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;
import javax.servlet.http.HttpSession;

/**
 *
 * @author Dilip
 */
public class httpServlet1 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
             HttpSession session=request.getSession(false);
        String n=(String)session.getAttribute("uname");
        out.print("Welcome "+n);

        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Output

Managing Session using Cookies

noreply@blogger.com (Dilip Bari) — Wed, 10 Jul 2013 23:35:00 -0700

Cookies are small text files that are stored by an application server in the client
browser to keep track of all the users. A cookie has values in the form of name/value
pairs. For example, a cookie can have a name, user with the value, Michael. They are
created by the server and are sent to the client with the HTTP response headers. The
client saves the cookies in the local hard disk and sends them along with the HTTP
request headers to the server. A Web browser is expected to support 20 cookies per
host and the size of each cookie can be a maximum of 4 bytes each. Various
characteristics of cookies are:

Coockie.html

<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
  <form action="cookieServlet" method="post">
Name:<input type="text" name="userName"/><br/>
password:<input type="password" name="userPass"/><br/>
<input type="submit" value="go"/>
</form>

  </body>
</html>

cookieServlet.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class cookieServlet 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
           String n=request.getParameter("userName");
           String p=request.getParameter("userPass");
    out.println("Welcome "+n);

    Cookie ck=new Cookie("uname",n);//creating cookie object
    ck.setMaxAge(120);
    response.addCookie(ck);//adding cookie in the response
Cookie ck1=new Cookie("upass",p);//creating cookie object
    ck1.setMaxAge(120);
    response.addCookie(ck1);
    //creating submit button
    out.print("Cookie containing user name and password  is stored in your browser.");
    out.print("<form action='cookieServlet1' method='post'>");
    out.print("<input type='submit' value='go'>");
    out.print("</form>");
        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

cookieServlet1.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class cookieServlet1 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            String username=null;
            String userpass=null;

            Cookie ck[]=request.getCookies();
    //out.print("Hello "+ck[0].getValue());
            if (ck!=null)
            {
                for (int i=0; i<ck.length; i++)
                {
                    /* Retrieve username from the cookie. */
                    if (ck[i].getName().equals("uname"))
                    {
                        username = ck[i].getValue();
                    out.println("User Name : "+username);

                    }
                     if (ck[i].getName().equals("upass"))
                    {
                        userpass = ck[i].getValue();
                    out.println(" Password : "+userpass);

                    }
                }
            }
        else
        {
            out.println("No cookies found");
        }
        
    }catch(Exception e)
    {
        out.println("Error"+e.toString());
        }
        
        finally {
            out.close();
        }
     
        }
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Output

Managing Session using URL rewriting

noreply@blogger.com (Dilip Bari) — Wed, 10 Jul 2013 23:24:00 -0700

URL rewriting is a session management technique that manages user session by
modifying a URL. Usually, this technique is used when information that is to be
transferred is not very critical because the URL can be intercepted easily during
transfer. For example, in an online shopping portal, a servlet can modify a URL to
include user information, such as a username. The servlet can then display the URL.

When the user clicks the URL hyperlink. The information is sent to another servlet that
retrieves the user information and displays a welcome message. You can use the
following code to create the servlet, RewriteServletURL that modifies and displays a
URL.

urlRewriting.html

<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
   <form action="urlServlet" method="post">
Name:<input type="text" name="userName"/><br/>
<input type="submit" value="go"/>
</form>

  </body>
</html>

urlServlet.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class urlServlet 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
             String n=request.getParameter("userName");
        out.print("Welcome "+n);

        //appending the username in the query string
        out.print("<a href='urlServlet1?uname="+n+"'>visit</a>");

        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

urlServlet1.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class urlServlet1 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
             //getting value from the query string
        String n=request.getParameter("uname");
        out.print("Hello "+n);
        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Output

Managing Session using Hidden form field

noreply@blogger.com (Dilip Bari) — Wed, 10 Jul 2013 23:04:00 -0700

You can use hidden form fields to maintain the session information of a user while the
user interacts with the Web application. A hidden form field is embedded in an HTML
page and is not visible when viewed in a browser. The following code snippet shows a
hidden form field in an HTML page:

Programs:

HiddenForm.html

<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
   <form action="FirstServlet1" method="post">
Name:<input type="text" name="uname"/><br/>
<input type="submit" value="go"/>
</form>
  </body>
</html>

FirstServlet1.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class FirstServlet1 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
           String n=request.getParameter("uname");
        //out.print("Welcome "+n);

        //creating form that have invisible textfield
        out.print("<form method='post' action='SecondServlet'>");
        out.print("<input type='hidden' name='uname' value='"+n+"'>");
        out.print("<input type='submit' value='go'>");
        out.print("</form>");
        out.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
         finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

SecondServlet.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Code;

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;

/**
 *
 * @author Dilip
 */
public class SecondServlet 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
          String n=request.getParameter("uname");
        out.print("Hello "+n);
            
        } finally { 
            out.close();
        }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @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 doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @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 {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Output

Login form in servlet with Attribute & RequestDispatcher

noreply@blogger.com (Dilip Bari) — Fri, 5 Jul 2013 05:56:00 -0700

login.html

<html>
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        
  </head>
  <body>
   <form method="post" action="login">
        User Name:<input type="text" name="name" /><br/>
        Password:<input type="password" name="pass" /><br/>
        <input type="submit" value="login" />
        </form>
  </body>
</html>

login.java

package Code;

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;

/**
 *
 * @author Dilip
 */
public class login extends HttpServlet {

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
           String name = request.getParameter("name");
        String pass = request.getParameter("pass");
        request.setAttribute("user",name );
        if(Validate1.checkUser(name, pass))
        {
            RequestDispatcher rs = request.getRequestDispatcher("Welcome1");
            rs.forward(request, response);
        }
        else
        {
           out.println("Username or Password incorrect");
           RequestDispatcher rs = request.getRequestDispatcher("login.html");
           rs.include(request, response);
        }
        } finally { 
            out.close();
        }
    } 
}

Welcome1.java

package Code;

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;
/**
 *
 * @author Dilip
 */
public class Welcome1 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
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String n=(String)request.getAttribute("user");
        try {
           
        out.println("Welcome user:"+n);
        } finally { 
            out.close();
        }
    } 
}

Validate1.java

package Code;
import java.sql.*;
/**
 *
 * @author Dilip
 */
public class Validate1 {
public static boolean checkUser(String uname,String pass)
     {
      boolean st =false;
      try{
                
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con=DriverManager.getConnection("jdbc:odbc:mydb","sa","niitbpl123");
         PreparedStatement ps =con.prepareStatement("select * from student where name=? and pass=?");
         ps.setString(1, uname);
         ps.setString(2, pass);
         ResultSet rs =ps.executeQuery();
         st = rs.next();

      }catch(Exception e)
      {
          e.printStackTrace();
      }
         return st;
}

}

Output

If user is and password are correct then output will be

If user is and password are incorrect then output will be

Addition of Two Number using servlet and jsp

noreply@blogger.com (Dilip Bari) — Fri, 5 Jul 2013 05:09:00 -0700

index.jsp

<%@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 bgcolor="yellow">
        <center><h1>Addition of Two Number</h1></center>
        <form action="additionservlet" method="post">
        <table border="0" width="100" align="center">

                <tr>
                    <td>First Number</td>
                    <td><input type="text" name="txtnum1" value="" /></td>
                </tr>
                <tr>
                    <td>Second Number</td>
                    <td><input type="text" name="txtnum2" value="" /></td>
                </tr>
            <tr>
                <td><input type="submit" value="Add" name="btnadd" /></td>
                <td></td>
                </tr>
        </table>
</form>
    </body>
</html>

additionservlet.java

package pck;

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;

/**
 *
 * @author Dilip
 */
public class additionservlet extends HttpServlet {
   
    
    protected void processRequest(HttpServletRequest req, HttpServletResponse response)throws ServletException, IOException 
    {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        int x,y,res;
        x=Integer.parseInt( req.getParameter("txtnum1"));
        y=Integer.parseInt(req.getParameter("txtnum2"));

        try {
            res=x+y;
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet NewServlet</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Addition= " + res + "</h1>");
            out.println("</body>");
            out.println("</html>");
        
           } 
       finally 
           { 
              out.close();
           }
    } 

}

Output:

Best Education wordpress themes for educational institutes

noreply@blogger.com (Dilip Bari) — Wed, 29 May 2013 01:45:00 -0700

How to configure JNDI step by step in NetBeans..

noreply@blogger.com (Dilip Bari) — Wed, 3 Apr 2013 01:11:00 -0700

Software	Version Required
NetBeans IDE	Java bundle, 6.8 or 6.9
Java Development Kit (JDK)	version 6,7
GlassFish server	v3 or Open Source Edition 3.0.1
SQL Server	2005
Type 4 Driver for SQL Server 2005	sqljdbc

SQL Server 2005 Type 4 driver

•First Download the SQL Server 2005 Type 4 driver.

•Set the classpath

Database Create a database and table in SQL Server 2005

Create a new web Application

index.jsp code

<%-- 
Document   : index
Created on : Nov 21, 2012, 3:42:17 PM
Author     : NIIT
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JNDI DEMO</title>
</head>
<body bgcolor="pink">
<h1>Login Management System</h1>
<form action="NewServlet" method="post">
<table align="center">
<tr>
<td>User Name </td>
<td><input type="text" name="txtuser" ></td>
</tr>
<tr>
<td>Password </td>
<td><input type="password" name="txtpass" ></td>
</tr>
<tr>
<td><input type="submit" value="Login"></td>
</tr>
</table>
</form>
</body>
</html>

Configuration of JNDI

Now Check your Connection Poll is working or not?

Create a Servlet

Servlet Code

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.naming.InitialContext;
import javax.naming.NamingException;
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.sql.DataSource;
@WebServlet(name = "NewServlet1", urlPatterns = {"/NewServlet1"})
public class NewServlet1 extends HttpServlet {


Connection con;
ResultSet rs;
Statement st;
InitialContext ctx;
DataSource ds;

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {

String uname,pass;
uname=request.getParameter("txtuser");
pass=request.getParameter("txtpass");
String qry="select * from Login";

ctx = new InitialContext();
ds = (DataSource)ctx.lookup("jdbc/myDatasource");
con=ds.getConnection();
st = con.createStatement();
rs = st.executeQuery(qry);
rs.next();
if(uname.equals(rs.getString(1)) && pass.equals(rs.getString(2)))
{
out.println("Your User Name and Password is correct<br>");
out.println("Welcome Mr. "+ uname);

}
else
{
out.print("Invalid User Name & Password");

}
}
catch(SQLException ex)
{
out.println(ex.getMessage());
}
catch(NamingException nx)
{
out.println(nx.getMessage());
}
}

printf() inside printf ()in C Language.

noreply@blogger.com (Dilip Bari) — Thu, 21 Mar 2013 23:25:00 -0700

#include<stdio.h>
#include<conio.h>
void main()
{
int num=1342;
clrscr();
printf("%d",printf("%d",printf("%d",num)));
getch();
}

Output :

134241
How ?

Firstly Inner printf is executed which results in printing 1324 
This Printf Returns total number of Digits i.e  4 and second inner printf will looks like
printf("%d",printf("%d",4));
It prints 4 and Returns the total number of digits i.e 1 (4 is single digit number )
printf("%d",1);
It prints simply 1 and output will looks like 132441
Rule :

Inner printf returns Length of string printed on screen to the outer printf

Make Your Own Header File in C & C++?

noreply@blogger.com (Dilip Bari) — Thu, 21 Mar 2013 23:09:00 -0700

Make Your Own Header File ?

Step1 : Type this Code 

int Multiplication(int a,int b)
{
return(a*b);
}
In this Code write only function definition as you write in General C Program

Step 2 : Save Code

Save Above Code with [.h ] Extension .
Let name of our header file be myhead [Multhead.h ]
Compile Code if required.

Step 3 : Write Main Program

#include<stdio.h>
#include"Multhead.h"
void main()
{
int number1=10,number2=10,number3;
number3 = Multiplication(number1,number2);
printf("Addition of Two numbers : %d",number3);
}

Include Our New Header File .
Instead of writing < Multhead.h> use this terminology “Multhead.h”
All the Functions defined in the Multhead.h header file are now ready for use .
Directly  call function Multiplication(); [ Provide proper parameter and take care of return type ]

Note

While running your program precaution to be taken : Both files [ Multhead.h and sample.c ] should be in same folder.

Technorati Tags: Hedder file in C & C++

C Language Programs

C++ Programs

Program Displays Colourful Characters in Text Mode and Initialises speaker & Plays Sound of Random Frequencies.

noreply@blogger.com (Dilip Bari) — Thu, 21 Mar 2013 22:59:00 -0700

#include<stdio.h>
#include<dos.h>
#include<conio.h>
#include<stdlib.h>

void main()
{
int count=100;
clrscr();
while(count--)
{
sound(10*random(100));
delay(75);
nosound();
textattr(random(16)+'a'+BLINK);
cprintf("*");
}
}

Technorati Tags: Sound in C Language

Program will accept Year,Month and Date from the user and will display the day of the month.

noreply@blogger.com (Dilip Bari) — Wed, 20 Mar 2013 13:06:00 -0700

#include<stdio.h>
#include<conio.h>
#include<math.h>

int isdatevalid(int month, int day, int year)
{
if (day <= 0) return 0 ;
switch( month )
{
case 1:
case 3:
case 5:
case 7:
case 8:
case 10:
case 12: if (day > 31) return 0 ; else return 1 ;
case 4:
case 6:
case 9:
case 11: if (day > 30) return 0 ; else return 1 ;
case 2:
if ( day > 29 ) return 0 ;
if ( day < 29 ) return 1 ;

else return 0 ;
}
return 0 ;
}
//------------------------------------------------
int fm(int date, int month,int year)
{
int fmonth,leap;

//leap function 1 for leap & 0 for non-leap

if((year%100==0) && (year%400!=0))
leap=0;
else if(year%4==0)
leap=1;
else
leap=0;

fmonth=3+(2-leap)*((month+2)/(2*month))+(5*month+month/9)/2;
//f(m) formula

fmonth = fmonth % 7; //bring it in range of 0 to 6

return fmonth;
}

//----------------------------------------------
int day_of_week(int date, int month, int year)
{
int dow; //day of week

int YY = year % 100;
int century = year / 100;

printf("nDate: %d/%d/%dnn",date,month,year);

dow = 1.25 *  YY + fm(date,month,year) + date - 2*( century % 4);
//function of weekday for Gregorian

dow = dow % 7; //remainder on division by 7

switch (dow)
{
case 0:
printf("weekday = Saturday");
break;
case 1:
printf("weekday = Sunday");
break;
case 2:
printf("weekday = Monday");
break;
case 3:
printf("weekday = Tuesday");
break;
case 4:
printf("weekday = Wednesday");
break;
case 5:
printf("weekday = Thursday");
break;
case 6:
printf("weekday = Friday");
break;
default:
printf("Incorrect data");
}
return 0;
}
//------------------------------------------
void main()
{
int date,month,year;
clrscr();

printf("Enter the year ");
scanf("%d",&year);

printf("Enter the month ");
scanf("%d",&month);

printf("Enter the date ");
scanf("%d",&date);

day_of_week(date,month,year);

getch();
}

Output :

Enter the year 2012
Enter the month 02
Enter the date 29

Date: 29/2/2012

weekday = Wednesday

Write a C program that reads the customer number and power consumed and prints the amount to be paid by the customer.

noreply@blogger.com (Dilip Bari) — Wed, 20 Mar 2013 13:00:00 -0700

An electric power distribution company charges its domestic consumers as follows.

Consumption   Rate of
Units        Charge
------------------------------------------------------
0-200       Rs.0.50 per unit
201-400     Rs.100 plus Rs.0.65 per unit excess 200
401-600     Rs.230 plus Rs.0.80 per unit excess of 400.

#include<stdio.h>
#include<conio.h>
void main()
{
int n, p;
float amount;
clrscr();
printf("Enter the customer number: ");
scanf("%d",&n);
printf("Enter the power consumed: ");
scanf("%d",&p);

if(p>=0 && p<=200)
amount=p*0.50;
else if(p>200 && p<400)
amount = 100+((p-200) * 0.65);
else if(p>400 && p<=600)
amount = 230 + ((p-400) * 0.80);
printf("Amount to be paid by customer no. %d is Rs.:%5.2f.",n,amount);

getch();
}

Output :

Enter the customer number: 1
Enter the power consumed: 100
Amount to be paid by customer no. 1 is Rs.:50.00.

Running Clock in C++ with Graphics

noreply@blogger.com (Dilip Bari) — Tue, 19 Mar 2013 13:53:00 -0700

#include<conio.h>
#include<graphics.h>
#include<math.h>
#include<dos.h>

#define WBC 5
//^watchbackcolor
#define X 200
#define Y 200

void dial(int x, int y);
void sechand(int timeminute);

void minhand(int t)
{
int x1,y1;
setlinestyle(0,0,3);

x1= X+ (80 * cos(t*0.1047));
y1= Y+ (80 * sin(t*0.1047));

setcolor(BLACK);
line( X, Y, x1, y1);

setcolor(WBC+1);
line( X, Y, X+ 80 * cos((t-1)*0.1047),Y+ 80 * sin((t-1)*0.1047));
circle(X,Y,4);
}

void sechand(int t)
{
int x1,y1;
setlinestyle(0,0,3);

x1= X+(100 * cos(t*0.1047));
y1= Y+(100 * sin(t*0.1047));

setcolor(RED);
line(X, Y, x1, y1);

setcolor(WBC+1);
line(X, Y, X+ 100 * cos((t-1)*0.1047),Y+ 100 * sin((t-1)*0.1047));

circle(X,Y,4);
}

void dial(int x,int y)
{
int const size=200;

setfillstyle(1,WBC);
fillellipse(x,y,size,size);

setfillstyle(1,WBC+1);
fillellipse(x,y,size-20,size-20);

outtextxy(x,y-(size-40),"12");
outtextxy(x,y+(size-40),"6");
outtextxy(x+(size-40),y,"3");
outtextxy(x-(size-40),y,"9");
outtextxy(x+size/3,y-2*size/3,"1");
outtextxy(x+2*size/3,y-size/3,"2");
outtextxy(x+2*size/3,y+size/3,"4");
outtextxy(x+size/3,y+2*size/3,"5");
outtextxy(x-size/3,y+2*size/3,"7");
outtextxy(x-2*size/3,y+size/3,"8");
outtextxy(x-size/3,y-2*size/3,"11");
outtextxy(x-2*size/3,y-size/3,"10");

circle(x,y,4);
}

void main()
{
int gd=DETECT, gm,i,j, flag=1;
initgraph(&gd,&gm,"C:\\turboc3\\bgi");

dial(200,200);
do
{
minhand(i);
for(j=0;j<60;j++)
{
sechand(j);
delay(1000
);
if(kbhit()) {
flag =0;
break;
}
}
i++;
}while(flag);
closegraph();
}

Output:

Installation Steps For Installing TurboC compiler

noreply@blogger.com (Dilip Bari) — Wed, 27 Feb 2013 07:18:00 -0800

This guide will explain how to install the TurboC compiler onto the C: drive but you can choose any drive and location that you wish.
Following are the steps to install the TurboC compiler:
1. Copy the truboC.exe file onto the C: drive of your computer.
2. Double-click the truboC.exe file. The Open File – Security Warning dialog box appears, as shown in the following figure.

3. Click the Run button in the Open File – Security Warning dialog box. The WinZip Self-Extractor – turboC.exe dialog box appears, as shown in the following figure.

4. Click the Unzip button. All the files get unzipped and stored in the C:\tctemp folder. If you want, you can change the name and location of the folder.
5. Double-click the C:\tctemp folder. This displays the contents of the folder.
6. Double-click the INSTALL.EXE file. The following window is displayed.

7. Press the ENTER key. The following widow is displayed.

8. Type C as the source drive in the Enter the SOURCE drive to use box.

9. Press the ENTER key. The following widow is displayed.

10. Press the ENTER key. The following widow is displayed.

11. Press the ENTER key with the default option selected. The following widow is displayed.

12. Select the Start Installation option from the options provided in the TurboC Installer window.

13. Press the ENTER key. The following widow is displayed.

14. Press the ENTER key. This completes the installation of the TurboC compiler.

Android Programming Tutorials, 3rd Edition

noreply@blogger.com (Dilip Bari) — Tue, 26 Feb 2013 13:07:00 -0800

There are two major steps for getting started with Android:
1. Y ou need to install the Android SDK and developer tools
2. Y ou should build a test project to confirm that those tools are
properly installed and configured
If you have already done some form of "hello, world" project with the
development tools on your development machine, you can skip this
tutorial.
If you have not yet installed the Android SDK and related tools, there is an
appendix that covers this process. Once you have the Android SDK, it is
time to make your first Android project. The good news is that this requires
zero lines of code – Android's tools create a "Hello, world!" application for
you as part of creating a new project. All you need to do is build it, install it,
and see it come up on your emulator or device. That is what this tutorial is
for.

CUSTOMER ENGAGEMENT Highlights-North (NIIT)

noreply@blogger.com (Dilip Bari) — Wed, 21 Nov 2012 07:19:00 -0800

Arithmetic Example in JSP using NetBeans

noreply@blogger.com (Dilip Bari) — Tue, 20 Mar 2012 12:40:00 -0700

Create Arithmetic.jsp

<%-- 
    Document   : Arithmetic
    Created on : Mar 21, 2012, 1:03:10 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>Arithmetic Example</title>
    </head>
     <h1>Some Arithmetic Example in JSP</h1>
    <body>
        a = 13;
        b = 3;
        <%
                    int a = 15;
                    int b = 7;
                    int result1 = a + b;
                    {
                        out.println("<br/> Additon of a and b = " + result1);
                        out.print("<br>");
                        int result2 = a - b;
                        out.println("<br/> Substraction of a anb b = " + result2);
                        out.print("<br>");
                        float result3 = a / b;
                        out.println(" <br/>Division of a anb b = " + result3);
                        out.print("<br>");
                        int result4 = a * b;
                        out.println("<br/> Mulitplication of a anb b = " + result4);
                        out.print("<br/>");
                    }
                    for (int i = 0; i <= 13; i++) {
                        if ((i % 2) == 0) {
                            out.print(" Even number of a : " + i);
                            out.print("<br>");
                        }
                    }
                    out.print("<br>");
                    for (int i = 0; i <= 13; i++) {
                        if ((i % 2) != 0) {
                            out.print(" Odd number of a :" + i);
                            out.print("<br>");
                        }
                    }
        %>
    </body>
</html>

Output:

Technorati Tags: jsp,NetBeans

Login Demo in jsp with NetBeans & SQL Server

noreply@blogger.com (Dilip Bari) — Tue, 20 Mar 2012 12:29:00 -0700

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

Reverse a number using recursion in c program

noreply@blogger.com (Dilip Bari) — Sun, 18 Mar 2012 11:19:00 -0700

#include<stdio.h>
int main(){
int num,rev;
printf("\nEnter a number :");
scanf("%d",&num);
rev=reverse(num);
printf("\nAfter reverse the no is :%d",rev);
return 0;
}
int sum=0,r;
int reverse(int num){
if(num){
r=num%10;
sum=sum*10+r;
reverse(num/10);
}
else
return sum;
return sum;
}

NIIT Indrapuri Bhopal

Caching:Varying the Output Cache By Parameter in ASP.NET

What is Caching in ASP.NET.

While selecting combobox value display the data from database using Ajax and jsp

Check user name available or already exists in database while creating Registration form in jsp using AJAX like gmail

How to use JSON(JavaScript Object Notation) in NetBeans

Managing Session using Servlet session API

Managing Session using Cookies

Managing Session using URL rewriting

Managing Session using Hidden form field

Login form in servlet with Attribute & RequestDispatcher

Addition of Two Number using servlet and jsp

Best Education wordpress themes for educational institutes

Education Academy

Grand College

Education

EduPress

Academica

How to configure JNDI step by step in NetBeans..

printf() inside printf ()in C Language.

Make Your Own Header File in C & C++?

Program Displays Colourful Characters in Text Mode and Initialises speaker & Plays Sound of Random Frequencies.

Program will accept Year,Month and Date from the user and will display the day of the month.

Output :

Write a C program that reads the customer number and power consumed and prints the amount to be paid by the customer.

Running Clock in C++ with Graphics

Installation Steps For Installing TurboC compiler

Android Programming Tutorials, 3rd Edition

CUSTOMER ENGAGEMENT Highlights-North (NIIT)

Arithmetic Example in JSP using NetBeans

Login Demo in jsp with NetBeans & SQL Server

Reverse a number using recursion in c program