tomcat return an error +mvc

[Vas Miriyala]

Hi friends I am developing simple mvc using request dispatcher ,here what i am going to do is I am developing Inventory Management system using mvc and jsp as view servlet as controller and beans as model,I have written a few class file and got the following error
Error

   
HTTP Status 404 - /testing-cashier/cashierDetails
 

these are my codes
Database.java

    
package ims;

import java.sql.*;

public class Database {
final String server="localhost:3306";
final String user="root";
final String  password="root";
final String database="IMS1";



Connection con=null;
ResultSet rs=null;
Statement stmt=null;

public  Database()
	{
			try{
					Class.forName("com.mysql.jdbc.Driver");
					con=DriverManager.getConnection("jdbc:mysql://"+server+"/"+database,user,user);
					stmt=con.createStatement();

			   }
			catch(Exception ex)
	 		   {
					System.out.println(ex.toString());
			   }

	}
public void executeUp(String query) throws Exception
{
         	         stmt.executeUpdate(query);
         	         con.close();
}

}	

cashierDetails.java

   
package ims;
import ims.*;
import java.sql.*;

public class cashierDetails {

int cashier_id;
int usertype;
int aid;
int uid;
public String user_name;
public String password;
public String email_id;
public int phone_no;
public String AddCashierUser(cashierDetails cd)
{
    Database db=new Database(); 
    String status="true";   
    int maxid= getCashierid()+1;
    String name=user_name.replaceAll(" ",null);
		String username=user_name.substring(0,2).concat(Integer.toString(maxid));
		try{
			String str="insert into user (user_name,password,user_type)" +
					" values('"+user_name+"' ,'"+password+"',2 )";
			db.executeUp(str);
			
		}
		catch (Exception e) {
			System.out.println(e.toString());
			status="false";
		}
		return status;

	}

	public String AddCashier(cashierDetails cd)
	{
		Database db=new Database();
		Database db1=new Database();
		cashierDetails acu=new cashierDetails();
		String status="true";
	
		int maxid= acu.getCashierid()+1;
		
	
		String name=user_name.replaceAll(" ",null);
		String username=user_name.substring(0,3).concat(Integer.toString(maxid));
		
		try{
			String str="insert into user (user_name,password,user_type)" +
					" values('"+user_name+"' ,'"+password+"',2 )";
			db.executeUp(str);
			System.out.println(" ID"+maxid); 
			int usid=acu.getuserid();	
		System.out.println("USER ID"+usid);	
			/* str="insert into cashier_details (email_id,phone_no,user_id)" +
			" values('"+cd.email_id+"' ,'"+cd.phone_no+"',"+usid+" )";
			 db1.executeUp(str); */
		}
		catch (Exception e) {
			System.out.println(e.toString());
			status="false"; 
		}
		
		return status;

	}

	
	public int getCashierid()
	{
		Database db=new Database();
	
		try{
			String str="select cashier_id from   ";
			db.rs=db.stmt.executeQuery(str);
			while(db.rs.next())
			{
			aid=db.rs.getInt(1);
			System.out.println("AID"+aid);
			}
		}
		catch (Exception e) {
			System.out.println(e);
		}
  //    aid=1;
		return aid;
		
	}
	public int getuserid()
	{
		Database db=new Database();
	
		try{
			String str="select user_id from user   ";
			db.rs=db.stmt.executeQuery(str);
			while(db.rs.next())
			{
			uid=db.rs.getInt(1);
			System.out.println("user_id=" +uid);
			}
		}
		catch (Exception e) {
			System.out.println(e);			
		}
//uid=2;
		return uid;
		
	}

	
	
	public String addCashier(cashierDetails cd,int chid)
	{
	
		return null;	
	}
	
	
}
	
	
//id for cashier=2
 

cashierServlet.java

   
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package ims;
import  ims.*;
import java.io.*;
import java.net.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author root
 */
public class cashierServlet extends HttpServlet {
   
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
	cashierDetails cd = new cashierDetails();
       cd.user_name   = request.getParameter("username");
       cd.password = request.getParameter("password");
        cd.AddCashierUser(cd);
	cd.AddCashier(cd);
	try {
	   
	   out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet cashierServlet</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet cashierServlet at " + request.getContextPath () + "</h1>");
            out.println("</body>");
            out.println("</html>");
	    
       } finally { 
	   out.close();
        }
    } 

    RequestDispatcher dispatcher = request.getRequestDispatcher("success.jsp");
    dispatcher.forward(request,response);

}

 

web.xml

<web-app>
<servlet>
<servlet-name>cashierServlet</servlet-name>
<servlet-class>ims.cashierServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>cashierServlet</servlet-name>
<url-pattern>/cashierServlet</url-pattern>
</servlet-mapping>
</web-app>

cashierRegistration.sjp

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>cashier-Registration</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<form name="cashierregistration" action="cashierServlet" method="post">
<table>
<td><table width="200" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
              <tr>
                <td height="30" align="center"><strong>TO LOGIN</strong></td>
              </tr>
              <tr>
                <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td>Username:</td>
                      <td><label>
                        <input name="user" type="text" size="16" />
                      </label></td>
                    </tr>
                    <tr>
                      <td>Password:</td>
                      <td><input name="pass" type="password" size="16" /></td>
                    </tr>
                                 <tr>
                      <td>Password:</td>
                      <td><input name="pass1" type="password" size="16" /></td>
                    </tr>
       
                    <tr>
                      <td> </td>
                      
                    </tr>
                   
                    <tr>
                      <td> </td>
                      <td><label>
                        <input type="submit" name="Submit" value="Submit" />
                      </label></td>
                    </tr>
                </table></td>
              </tr>
            </table></td>
          </table>
</form>
</body>
</html>

any idea ..

[Bear Bibeault]

HTTP Status 404 - /testing-cashier/cashierDetails

Where is cashierDetails mapped?

[Bear Bibeault]

P.S. Generating HTML in a servlet? This is no longer 1997. Why are you not using a JSP for the view?

[Vas Miriyala]

thanks for your replyy cashierDetails contains methods to insert user entered parameters like username,password into user table and it will insert user_id into cashier table

[Bear Bibeault]

You didn't answer my mapping question.

[Vas Miriyala]

in my servler file i have create new object for cashierDetails and i called some methods like AddcashierUser and Addcashier(correct me if i am wrong)

   
	cashierDetails cd = new cashierDetails();
       cd.user_name   = request.getParameter("username");
       cd.password = request.getParameter("password");
        cd.AddCashierUser(cd);
	cd.AddCashier(cd);
 

[Bear Bibeault]

You keep answering every question except the one I am asking.

Where is the mapping?

[Vas Miriyala]

may be i can say sorry before asking this ..i am not getting what you are asking for? mapped means ?

[Bear Bibeault]

A servlet must be mapped before it can be addressed. You already have one mapping in your deployment descriptor -- any servlet you wish to directly address must have a mapping.

[Vas Miriyala]

okay,but cashierDetails is not a servlet? right,

[Bear Bibeault]

Then why would you be trying to address it via URL?

You've provided a lot of code, but not any detail on what you are trying to accomplish or how.

[Vas Miriyala]

actually servlet is calling that class and methods( i have written in cashierServlet) here what i am trying to do is i want to insert into a data into a table named user(tables are already created in mysql) and cashier_details by using entered parameters( like username,password), in servlet i am using request.getParameter("username") and request.gerParameter("password") by using this i am calling AddcashierUser and Addcashier from cashierDetails class(i have written mysql statements to insert data into user and cashier_details tables) todo mysql quiries

[Nick Potter]

  #  try {  
#          
#        out.println("<html>");  
#             out.println("<head>");  
#             out.println("<title>Servlet cashierServlet</title>");    
#             out.println("</head>");  
#             out.println("<body>");  
#             out.println("<h1>Servlet cashierServlet at " + request.getContextPath () + "</h1>");  
#             out.println("</body>");  
#             out.println("</html>");  
#           
#        } finally {   
#        out.close();  
#         }  
#     }   
#   
#     RequestDispatcher dispatcher = request.getRequestDispatcher("success.jsp");  
#     dispatcher.forward(request,response);    

How does this compile?

[Vas Miriyala]

oh...by default given by IDE,'s ,i commented that lines then also its not working

[Vas Miriyala]

i did some modification to my codes and got the error which says
Error

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.NullPointerException
	ims.cashierDetails.AddCashierUser(cashierDetails.java:20)
	ims.cashierServlet.doGet(cashierServlet.java:15)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.
Apache Tomcat/5.5.27

here is the source-code for cashierDetails.java

package ims;
import ims.*;
import java.sql.*;

public class cashierDetails {

int cashier_id;
int usertype;
int aid;
int uid;
public String user_name;
public String password;
public String email_id;
public int phone_no;
public String AddCashier(cashierDetails cd)
{
    Database db=new Database(); 
    String status="true";   
    int maxid= getCashierid()+1;
  [b]  String name=cd.user_name.replaceAll(" ",null);[/b]
    String username=user_name.substring(0,2).concat(Integer.toString(maxid));
		try{
			String str="insert into user (user_name,password,user_type)" +
					" values('"+cd.user_name+"' ,'"+cd.password+"',2 )";
			db.executeUp(str);
			
		}
		catch (Exception e) {
			System.out.println(e.toString());
			status="false";
		}
		return status;

	}

	public String AddCashier(cashierDetails cd)
	{
		Database db=new Database();
		Database db1=new Database();
		cashierDetails acu=new cashierDetails();
		String status="true";
	
		int maxid= acu.getCashierid()+1;
		
	
		String name=cd.user_name.replaceAll(" ",null);
		String username=cd.user_name.substring(0,3).concat(Integer.toString(maxid));
		
		try{
			String str="insert into user (user_name,password,user_type)" +
					" values('"+cd.user_name+"' ,'"+cd.password+"',2 )";
			db.executeUp(str);
			System.out.println(" ID"+maxid); 
			int usid=acu.getuserid();	
		System.out.println("USER ID"+usid);	
			/* str="insert into cashier_details (email_id,phone_no,user_id)" +
			" values('"+cd.email_id+"' ,'"+cd.phone_no+"',"+usid+" )";
			 db1.executeUp(str); */
		}
		catch (Exception e) {
			System.out.println(e.toString());
			status="false"; 
		}
		
		return status;

	}

	
	public int getCashierid()
	{
		Database db=new Database();
	
		try{
			String str="select cashier_id from   cashier_details;";
			db.rs=db.stmt.executeQuery(str);
			while(db.rs.next())
			{
			aid=db.rs.getInt(1);
			System.out.println("AID"+aid);
			}
		}
		catch (Exception e) {
			System.out.println(e);
		}
  //    aid=1;
		return aid;
		
	}
	public int getuserid()
	{
		Database db=new Database();
	
		try{
			String str="select user_id from user   ";
			db.rs=db.stmt.executeQuery(str);
			while(db.rs.next())
			{
			uid=db.rs.getInt(1);
			System.out.println("user_id=" +uid);
			}
		}
		catch (Exception e) {
			System.out.println(e);			
		}
//uid=2;
		return uid;
		
	}

	
	
	public String addCashier(cashierDetails cd,int chid)
	{
	
		return null;	
	}
	
	
}
	
	
//id for cashier=2

hee is code for cashierServlet.java

package ims;
import  ims.cashierDetails;
import java.io.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class cashierServlet extends HttpServlet {

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

	//        response.setContentType("text/html;charset=UTF-8");
	cashierDetails cd = new cashierDetails();
	// PrintWriter out = response.getWriter();
	cd.user_name = request.getParameter("name");
	cd.password = request.getParameter("password");
	cd.AddCashierUser(cd);
    }
}