JSP
JSP

Beans files errors

This is Error Compiling JSP File - part 2

Kennethxu's solution worked. Thank you. Now when I compile it shows errors in my two beans java files. Immediately below are the generated errors and I will follow with the two java files. Thanks for any help you can provide..

trackingView$jsp.java [86:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingView$jsp
TrackingDataBean trackingData = null;
^
trackingView$jsp.java [89:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingView$jsp
trackingData= (TrackingDataBean)
^
trackingView$jsp.java [94:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingView$jsp
trackingData = (TrackingDataBean) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "TrackingDataBean");
^
trackingView$jsp.java [142:1] cannot resolve symbol
symbol : class TrackingBean
location: class org.apache.jsp.trackingView$jsp
TrackingBean tracking;
^
trackingView$jsp.java [145:1] cannot resolve symbol
symbol : class TrackingBean
location: class org.apache.jsp.trackingView$jsp
tracking = ( TrackingBean ) trackingListIterator.next();
^
trackingLogin$jsp.java [79:1] cannot resolve symbol
symbol : class TrackingBean
location: class org.apache.jsp.trackingLogin$jsp
TrackingBean tracking = null;
^
trackingLogin$jsp.java [82:1] cannot resolve symbol
symbol : class TrackingBean
location: class org.apache.jsp.trackingLogin$jsp
tracking= (TrackingBean)
^
trackingLogin$jsp.java [87:1] cannot resolve symbol
symbol : class TrackingBean
location: class org.apache.jsp.trackingLogin$jsp
tracking = (TrackingBean) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "TrackingBean");
^
trackingLogin$jsp.java [106:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingLogin$jsp
TrackingDataBean trackingData = null;
^
trackingLogin$jsp.java [109:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingLogin$jsp
trackingData= (TrackingDataBean)
^
trackingLogin$jsp.java [114:1] cannot resolve symbol
symbol : class TrackingDataBean
location: class org.apache.jsp.trackingLogin$jsp
trackingData = (TrackingDataBean) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "TrackingDataBean");
^

11 errors
Errors compiling trackingLogin

The two .java files follow:

// TrackingBean.java
// JavaBean to store branch sales data for a database

public class TrackingBean {

private String branch, year, month, day;
// private int

// set the branch's name
public void setBranch ( String name )
{
branch = name;
}

// get the branch's name
public String getBranch()
{
return branch;
}

// set the branch's year
public void setYear ( String yyyy )
{
year = yyyy;
}

// get the branch's year
public String getYear()
{
return year;
}

// set the branch's month
public void setMonth ( String mm )
{
month = mm;
}

// get the branch's month
public String getMonth()
{
return month;
}

// set the branch's day
public void setDay ( String dd )
{
day = dd;
}

// get the branch's day
public String getDay()
{
return day;
}

}

// TrackingDataBean.java
// Class TrackingDataBean makes a database connection and supports
// inserting and retrieving data from the database/

// Java core packages
import java.sql.*;
import java.io.*;
import java.util.*;

public class TrackingDataBean {
private Connection connection;
private PreparedStatement addRecord, getRecords;
private Statement stat;

// construct TitlesBean object
public TrackingDataBean() throws Exception
{
//System.setProperty( "

// load the Ability driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

// connect to the database
connection = DriverManager.getConnection(
"jdbc:odbc:Tracking" );

//Statement stat=con.createStatement();
//Statement stat=connection.createStatement();
stat = connection.createStatement();
}

// return an ArrayList of TrackingBeans
public ArrayList getTrackingList() throws SQLException
{
ArrayList trackingList = new ArrayList();

// obtain list of titles

ResultSet results = stat.executeQuery(
"SELECT branch, year, month, day FROM Tracking" );

// get row data
while ( results.next() ) {
TrackingBean tracking = new TrackingBean();

tracking.setBranch( results.getString( 1 ) );
tracking.setYear( results.getString( 2 ) );
tracking.setMonth( results.getString( 3 ) );
tracking.setDay( results.getString( 4 ) );

trackingList.add( tracking );
}

return trackingList;

}

// insert a branch's tracking in tracking database
public void addTracking( TrackingBean tracking ) throws SQLException
{
stat.executeUpdate( "INSERT INTO tracking ( branch, " +
"year, month, day ) VALUES ( '" + tracking.getBranch() + "', '" +
tracking.getYear() + "', '" + tracking.getMonth() + "', + '" +
tracking.getDay() + "' )" );
}

// close statemetns and terminate database connection
protected void finalize()
{
// attempt to close database connection
try {
stat.close();
connection.close();
}

// process SQLException on close operation
catch ( SQLException sqlException ) {
sqlException.printStackTrace();
}
}

}

timjgAsked: 2004-03-20

Who is Participating?

Improve company productivity with a Business Account.Sign Up

Solutions

Advertise Here

LVL 92

objectsConnect With a Mentor Commented: 2004-03-25

May be a ' character in one of the fields.
I'd suggest converting it to a PreparedStatement and trying that, its not that much work and will make things far clearer.

Expand your skills with this month's free Premium course.

Beans files errors

Who is Participating?

Already a member? Login.