Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Javascript Java SQL
Hi
friends i am new to java i am working on jsp so i want to insert in database it is showing this error , so how can i solve it can any one help me please... following error is occuring?
In this file i am getting parameters and initilizing beans
<%@page import="com.dryclean.web.controller.AdduserBeans;"%>
<%@page import="com.dryclean.web.controller;" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%
AdduserBeans addCust_obj=new AdduserBeans();
addCust_obj.setCustomer_fname(request.getParameter("add_customer_fname"));
addCust_obj.setCustomer_lname(request.getParameter("add_customer_lname"));
addCust_obj.setCustomer_address(request.getParameter("add_customer_cellnumber"));
addCust_obj.setCustomer_cellnumber(request.getParameter("add_customer_address"));
//DBUtil.SaveCustomer(addCust_obj);
response.sendRedirect("user_page.jsp");
%>
 
public static void SaveCustomer(AdduserBeans adduser)throws Exception
	{
		System.out.println(adduser.getCustomer_fname());
		String dbUrl = "jdbc:mysql://localhost:3306/";
		String db = "dry_cleaner";
		String driver = "com.mysql.jdbc.Driver";
		String user = "root";
		String pass = "";
		Connection con = null;
		Statement stmt = null;
		String query="INSERT INTO customers (customer_id, first_name,last_name,contact,address) VALUES('null','"+adduser.getCustomer_fname()+"','"+adduser.getCustomer_lname()+"','"+adduser.getCustomer_cellnumber()+"','"+adduser.getCustomer_address()+"')";
		try{
			Class.forName(driver);
			con = DriverManager.getConnection (dbUrl+db,user,pass);
			stmt = con.createStatement();
			//stmt.executeQuery(query);
			//stmt.executeQuery(sql)
			 if(stmt.executeUpdate(query)>0){
				   System.out.print("Records inserted");
				  }else{
				   System.out.print("insertion faild");
				  }
			
			
		}catch(Exception ex){
			System.out.println("Query :"+query);
			throw new Exception("Query Error");
		}
	}
 
and it is showing this error
 
An error occurred at line: 5 in the jsp file: /addcustomer_do.jsp
AdduserBeans cannot be resolved to a type
2: <%@page import="com.dryclean.web.controller;" %>
3: <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
4: <%
5: AdduserBeans addCust_obj=new AdduserBeans();
6: addCust_obj.setCustomer_fname(request.getParameter("add_customer_fname"));
7: addCust_obj.setCustomer_lname(request.getParameter("add_customer_lname"));
8: addCust_obj.setCustomer_address(request.getParameter("add_customer_cellnumber"));
Posted 15-Aug-12 22:57pm
Edited 15-Aug-12 23:08pm
TorstenH.33.9K
v4

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I added some format to the question and some tags.
 
Seems like the AdduserBeans is not known - is it added to the build? Check the build files, the AdduserBeans might not be marked to be added to the build.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 95
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 16 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100