Ad:

Java Discussion Thread
Marked Solved
Views: 11941

Aug 14th, 2007

class, interface, or enum expected

Expand Post »

Im getting this on just about every line....anybody see what Im doing wrong?

java Syntax (Toggle Plain Text)
public static int[] getLeadsSummary(UserDataVO userData) throws Exception {
    Connection connection	= null;
    PreparedStatement pstmt	= null;
    ResultSet resultSet		= null;
    int[] leadsSummary = {0,0};
    int leadCount = 0;
 
    try {
        connection = DataBaseConnectionManager.getConnection();
        if (connection != null) {
                if (userData.isAgentType()) {
                    String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" +
                    " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID = ? AND L.BO_VIEWED = 0 ";
//                    logger.debug(sqlStmt);
                    pstmt = connection.prepareStatement(sqlStmt);
                    pstmt.setInt(1,userData.getAgentId());
                    resultSet = pstmt.executeQuery();
                    if (resultSet.next()) {
                        leadsSummary[0] = resultSet.getInt(1);
                    }
                    resultSet.close();
                    pstmt.close();
 
                    // Do it again
 
                } else {
                    String sqlStmt = "SELECT count(*) FROM leads l, leads_contactinfo lc " +
            		" WHERE l.FK_CONID = lc.CON_ID AND lc.FK_ADVERID = ? " + 
                    " AND l.TIME_STAMP > TO_DATE('" + Integer.toString(month) + "/" + 
                    Integer.toString(i+1) + "/" + Integer.toString(year) + " 00:00','MM/DD/YYYY HH24:MI') AND " + 
                    " l.TIME_STAMP < TO_DATE('" + Integer.toString(month) + "/" + 
                    Integer.toString(i+1) + "/" + Integer.toString(year) + " 23:00','MM/DD/YYYY HH24:MI')";
//                    logger.debug(sqlStmt);
                    pstmt = connection.prepareStatement(sqlStmt);
                    pstmt.setInt(1,userData.getAdverId());
                    resultSet = pstmt.executeQuery();
                    if (resultSet.next()) {
                        leadCount = resultSet.getInt(1);
                    }
                    resultSet.close();
                    pstmt.close();
                }
            }
    }catch (SQLException e) {
        throw new Exception(e);
    }catch(Exception e){
        throw new Exception(e);
    } finally {
        try {
            if (resultSet!=null) resultSet.close();
            if (pstmt!=null) pstmt.close();
            DataBaseConnectionManager.closeConnection(connection);
        }  catch (SQLException e) {
            throw new Exception(e);
        }catch(Exception e){
            throw new Exception(e);
        }
    }
 
    return leadsSummary;
}
public static int[] getLeadsSummary(UserDataVO userData) throws Exception {
    Connection connection	= null;
    PreparedStatement pstmt	= null;
    ResultSet resultSet		= null;
    int[] leadsSummary = {0,0};
    int leadCount = 0;
    
    try {
        connection = DataBaseConnectionManager.getConnection();
        if (connection != null) {
                if (userData.isAgentType()) {
                    String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" +
                    " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID = ? AND L.BO_VIEWED = 0 ";
//                    logger.debug(sqlStmt);
                    pstmt = connection.prepareStatement(sqlStmt);
                    pstmt.setInt(1,userData.getAgentId());
                    resultSet = pstmt.executeQuery();
                    if (resultSet.next()) {
                        leadsSummary[0] = resultSet.getInt(1);
                    }
                    resultSet.close();
                    pstmt.close();
                    
                    // Do it again
                    
                } else {
                    String sqlStmt = "SELECT count(*) FROM leads l, leads_contactinfo lc " +
            		" WHERE l.FK_CONID = lc.CON_ID AND lc.FK_ADVERID = ? " + 
                    " AND l.TIME_STAMP > TO_DATE('" + Integer.toString(month) + "/" + 
                    Integer.toString(i+1) + "/" + Integer.toString(year) + " 00:00','MM/DD/YYYY HH24:MI') AND " + 
                    " l.TIME_STAMP < TO_DATE('" + Integer.toString(month) + "/" + 
                    Integer.toString(i+1) + "/" + Integer.toString(year) + " 23:00','MM/DD/YYYY HH24:MI')";
//                    logger.debug(sqlStmt);
                    pstmt = connection.prepareStatement(sqlStmt);
                    pstmt.setInt(1,userData.getAdverId());
                    resultSet = pstmt.executeQuery();
                    if (resultSet.next()) {
                        leadCount = resultSet.getInt(1);
                    }
                    resultSet.close();
                    pstmt.close();
                }
            }
    }catch (SQLException e) {
        throw new Exception(e);
    }catch(Exception e){
        throw new Exception(e);
    } finally {
        try {
            if (resultSet!=null) resultSet.close();
            if (pstmt!=null) pstmt.close();
            DataBaseConnectionManager.closeConnection(connection);
        }  catch (SQLException e) {
            throw new Exception(e);
        }catch(Exception e){
            throw new Exception(e);
        }
    }

    return leadsSummary;
}

Similar Threads

interface, or enum expected errors in Java
What is the difference between abstract class and interface in Java

mimsc

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

70 posts
since Aug 2007

Permalink

Aug 14th, 2007

Re: class, interface, or enum expected

Can U please post the error what u get

seenukarthi

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

2 posts
since May 2006

Permalink

Aug 14th, 2007

Re: class, interface, or enum expected

sure....
class, interface, or enum expected
[javac] public static int[] getLeadsSummary(UserDataVO userData) throws Exception {

mimsc

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

70 posts
since Aug 2007

Permalink

Aug 14th, 2007

Re: class, interface, or enum expected

I am not clear about the problem yet. But seems like you did not declare any class.
In java, almost e'thing is an object. So in order to make your function work, you have to put it inside an object.
sample solution can be:

Java Syntax (Toggle Plain Text)
public class MyClassName
{
public static int[] getLeadsSummary(UserDataVO userData) throws Exception {
/**
*
*all codes inside
*/
}
}
public class MyClassName
{
public static int[] getLeadsSummary(UserDataVO userData) throws Exception {
/**
*
*all codes inside
*/
}
}

orko

Reputation Points: 46

Solved Threads: 11

Junior Poster

Offline

164 posts
since Apr 2006

Permalink

Aug 15th, 2007

Re: class, interface, or enum expected

thanx

mimsc

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

70 posts
since Aug 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: Help!!! Help!!! Help!!!

Next Thread in Java Forum Timeline: Filter JTextField and Display in JTable

DaniWeb Message

Cancel Changes

User Name
Password