Prblems accessing a bean from JSP

[dinesh prasad]

Alright, I have tried a different design based on a template. The
controller servlet dispenses the JSPs and the dataBean stores values
into the database.
I haven't gotten to the display servet yet, I just want to get the
values into the database to start wtih. Here is the error I get trying
to compile addPage.jsp
showPage$jsp.java [70:1] cannot resolve symbol
symbol : class dataBean
location: package burnaby
com.brainysoftware.burnaby.dataBean dbBean = null;
^
showPage$jsp.java [73:1] cannot resolve symbol
code:


package com.brainysoftware.burnaby;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.brainysoftware.burnaby.DbBean;
public class ControllerServlet extends HttpServlet {
/**Initialize global variables*/
public void init(ServletConfig config) throws ServletException {
System.out.println("initializing controller servlet.");
ServletContext context = config.getServletContext();
context.setAttribute("base", config.getInitParameter("base"));
context.setAttribute("imageUrl",
config.getInitParameter("imageUrl"));
// instantiating the DbBean
DbBean dbBean = new DbBean();
// initialize the DbBean's fields
dbBean.setDbUrl(config.getInitParameter("dbUrl"));
dbBean.setDbUserName(config.getInitParameter("dbUserName"));
dbBean.setDbPassword(config.getInitParameter("dbPassword"));
// put the bean in the servlet context
// the bean will be accessed from JSP pages
context.setAttribute("dbBean", dbBean);
try {
// loading the database JDBC driver
Class.forName(config.getInitParameter("jdbcDriver"));
System.out.println(config.getInitParameter("jdbcDriver"));
}
catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
super.init(config);
}

/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
doPost(request, response);
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
String base = "/jsp/";
String url = base + "Default.jsp";
String action = request.getParameter("action");
if (action!=null) {
if (action.equals("search"))
url = base + "SearchResults.jsp";
else if (action.equals("browseCatalog"))
url = base + "BrowseCatalog.jsp";
else if (action.equals("productDetails"))
url = base + "ProductDetails.jsp";
else if (action.equals("productDetails"))
url = base + "ProductDetails.jsp";
else if (action.equals("addShoppingItem") ||
action.equals("updateShoppingItem") ||
action.equals("deleteShoppingItem") ||
action.equals("displayShoppingCart"))
url = base + "ShoppingCart.jsp";
else if (action.equals("checkOut"))
url = base + "CheckOut.jsp";
else if (action.equals("order"))
url = base + "Order.jsp";
else if (action.equals("registerhomepage"))
url = base + "registeruser.jsp";
else if (action.equals("showThePage"))
url = base + "homepage.jsp";
else if (action.equals("templateprocessor"))
url = base + "templateprocessor.jsp";
else if (action.equals("login"))
url = base + "Login.jsp";
else if (action.equals("addPage"))
url = base + "showPage.jsp";



}
System.out.println(url);
RequestDispatcher requestDispatcher =
getServletContext().getRequestDispatcher(url);
requestDispatcher.forward(request, response);
}
}
templateprocessor.jsp
<jsp:useBean id="theBean" class="com.infologic" />
<jsp:setproperty name="theBean" property="Username"/>
<jsp:setproperty name="theBean" property="pass"/>
<jsp:setproperty name="theBean" property="maintitle"/>
<jsp:setproperty name="theBean" property="main"/>
<jsp:setproperty name="theBean" property="aboutustitle"/>
<jsp:setproperty name="theBean" property="aboutus"/>
<jsp:setproperty name="theBean" property="servicestitle"/>
<jsp:setproperty name="theBean" property="services"/>
<jsp:setproperty name="theBean" property="contactustitle"/>
<jsp:setproperty name="theBean" property="contactus"/>
<jsp:setproperty name="theBean" property="misctitle"/>
<jsp:setproperty name="theBean" property="misc"/>
<form method=post>
<td><input type="text" name="Username"
size="15" border="0"></td>
<jsp.getProperty name="theBean"
property="Username" />
<td><input type="password" name="pass" size=15
border="0"></td>
<jsp.getProperty name="theBean"
property="pass" />
<td><input type="text" name="maintitle" size=15
border="0"></td>
<jsp.getProperty name="theBean"
property="maintitle" />
<td><input type="text" name="main" size="10"
border="0"></td>
<jsp.getProperty name="theBean"
property="main" />
<td><input type="text" name="aboutustitle"
size="15" border="0"></td>
<jsp.getProperty name="theBean"
property="aboutustitle" />
<td><input type="text" name="aboutus" size="7"
border="0"></td>
<jsp.getProperty name="theBean"
property="aboutus" />
<td><input type="text" name="servicestitle"
size="10" border="0"></td>
<jsp.getProperty name="theBean"
property="servicestitle" />
<td><input type="text" name="services"
size=15 border="0"></td>
<jsp.getProperty name="theBean"
property="services" />
<td><input type="text"
name="contactustitle" size=15 border="0"></td>
<jsp.getProperty name="theBean"
property="contactustitle" />
<td><input type="text"
name="contactus" size=15 border="0"></td>
<jsp.getProperty name="theBean"
property="contactus" />
<td><input type="text"
name="misctitle" size=15 border="0"></td>
<jsp.getProperty name="theBean"
property="misctitle" />
<td><input type="text" name="misc"
size=15 border="0"></td>
<jsp.getProperty name="theBean"
property="misc" />

<input type="submit">
<input type="hidden" name="action"
value="addage">
</body>
</hmtl>

showPage.jsp
<%@page import="java.sql.*" %>
<%@page import="java.util.*" %>
<jsp:useBean id="dbBean" scope="application"
class="com.brainysoftware.burnaby.dataBean" />
<html>
<head><title></title></head>
<table>
<%
if(dbBean.insertPage(request.getParameter("Username"),
request.getParameter("pass"),
request.getParameter("maintitle"),
request.getParameter("main"),
request.getParameter("aboutus"),
request.getParameter("aboutustitle"),
request.getParameter("services"),
request.getParameter("servicestitle"),
request.getParameter("contactus"),
request.getParameter("contactustitle"),
request.getParameter("misc"),
request.getParameter("misctitle"))) {
session.invalidate();
}
else
System.out.println("error");
%>
<body>
Thank you.
<%
response.sendRedirect("http://localhost:7001/citylinks/Default");
%>
</body>
</html>
dataBean.class
import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;

public class dataBean {
private String Username="";
private String pass="";
private String maintitle="";
private String main="";
private String aboutustitle="";
private String aboutus="";
private String servicestitle="";
private String services="";
private String contactustitle="";
private String contactus="";
private String misctitle="";
private String misc="";

private int yes=1;

Connection dbConn = null;


public String getUsername() {
return Username;
}

public void setUsername(String Username) {
if (Username!=null)
this.Username = Username;
}

public String getPass() {
return pass;
}
public void setPass(String pass) {
if (pass!=null)
this.pass = pass;
}
public void setMaintitle (String maintitle) {
if (maintitle!=null)
this.maintitle = maintitle;
}
public String getMaintitle () {
return maintitle;
}
public void setAboutustitle(String aboutustitle) {
if (aboutustitle!=null)
this.aboutustitle = aboutustitle;
}
public String getAboutustitle() {
return aboutustitle;
}
public void setAboutus(String aboutus) {
if (aboutus!=null)
this.aboutus = aboutus;
}
public String getAboutus() {
return aboutus;
}
public void setServices(String services) {
if (services!=null)
this.services = services;
}
public String getServices() {
return services;
}
public void setServicestitle(String servicestitle) {
if (servicestitle!=null)
this.servicestitle = servicestitle;
}
public String getServicestitle() {
return servicestitle;
}
public void setContactus(String contactus) {
if (contactus!=null)
this.contactus = contactus;
}
public String getContactus() {
return contactus;
}
public void setMisc(String misc) {
if (misc!=null)
this.misc = misc;
}
public String getMisc() {
return misc;
}
public void setMisctitle(String misctitle) {
if (misctitle!=null)
this.misctitle = misctitle;
}
public String getMisctitle() {
return misctitle;
}
public boolean insertPage(String Username, String main, String
aboutus, String aboutustitle, String services, String servicestitle,
String contactus, String contactustitle, String misc, String
misctitle)
{
boolean returnValue=false;


// create a persistent conneciton to the SQL server

System.out.println("servlet started");
String jdbcDriver = "weblogic.jdbc.mssqlserver4.Driver";
String dbURL =
"jdbc:weblogic:mssqlserver4:freelance@COMPAQSERVER";
String usernameDbConn = "dinesh";
String passwordDbConn = "werty6969";

System.out.println("database info set up..");

try
{
Class.forName(jdbcDriver).newInstance();
dbConn = DriverManager.getConnection(dbURL,
usernameDbConn, passwordDbConn);
}
catch (ClassNotFoundException e)
{
// throw new UnavailableException("jdbc driver not
found:" + dbURL);
}
catch (SQLException e)
{
//throw new UnavailableException("error: " + e);
}
catch (Exception e)
{
//throw new UnavailableException("error: " +e);
}
//make a callable statement for a stored procedure.
//It has four parameters

try
{
System.out.println("sending datacall");
CallableStatement cstmt = dbConn.prepareCall(
"{call storePageValues(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?)}");

//set the values of the stored procedure's input
parameters

//out.println("calling stored procedure . . .");
cstmt.setString(1, Username);
cstmt.setString(2, pass);
cstmt.setString(3, aboutus);
cstmt.setString(4, aboutustitle);
cstmt.setString(5, services);
cstmt.setString(6, servicestitle);
cstmt.setString(7, contactus);
cstmt.setString(8, contactustitle);
cstmt.setString(9, misc);
cstmt.setString(10, misctitle);
cstmt.setString(11, main);
cstmt.setString(12, maintitle);

//cstmt.setString(5, notes);
//now that the input parameters are set, we can proceed to
execute the insertTheForm stored procedure

cstmt.execute();
returnValue=true;

//out.println("stored procedure executed");
//out.close();
}

catch (SQLException e)
{
//throw new UnavailableException("error: " + e);
}
return returnValue;
}
}









Comment from dprasad
Date: 10/19/2003 11:24PM PDT Your Comment
NOTE: THE SHOWPAGE.JSP FILENAME IS MISLEADING, SORRY FOR THE CONFUSION
IT IS ACTUALLY FOR PUTTING VALUES IN THE DATABASE

 

[Jon Martin Solaas]

Alright, I have tried a different design based on a template. The
controller servlet dispenses the JSPs and the dataBean stores values
into the database.
I haven't gotten to the display servet yet, I just want to get the
values into the database to start wtih. Here is the error I get trying
to compile addPage.jsp
showPage$jsp.java [70:1] cannot resolve symbol
symbol : class dataBean
location: package burnaby
com.brainysoftware.burnaby.dataBean dbBean = null;
^
showPage$jsp.java [73:1] cannot resolve symbol
code:
[...]
dataBean.class

Suppose you mean dataBean.java here ...

It doesn't seem this class belongs to package
com.brainysoftware.burnaby, hence the compiler can't find it in that
package ... try to add a package declaration in dataBean.java and make
sure you've put it in the right directory. (You could also consider
renaming the class to DataBean)


package com.brainysoftware.burnaby

import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;

public class dataBean {
private String Username="";
private String pass="";
private String maintitle="";

[...]