Parka Teoh

Ok. Solved.

I declared it to be a String eariler up in the JSP page. That's why.

Below is the error.

insertOrder(int,java.lang.String,java.lang.String,long) in limited.ProcessBean2 cannot be applied to (int,java.lang.String,java.lang.String,java.lang.String)
processBean.insertOrder( uniqueOrderID, name, address, creditCardNumber);

----------------------------------------------------------------------

In ProcessBean2.java, there's a method accepting the parameters (int, String, String, long).

Does it mean that my ( uniqueOrderID, name, address, creditCardNumber) is actually (int, String, String, String)?

Hmmmm...

When I included the public infront of the empty constructor, it still couldn't work.

But when I deleted the constructor away, it's able to work again.

Oh my!! It works now!

Hi.

I have the following tags in my JSP.

<jsp:useBean id="cart" scope="session" class="limited.CartBean" />
<jsp:useBean id="idBean" scope="page" class="limited.GetOrderIDBean" />
<jsp:useBean id="databean" scope="page" class="limited.InsertDataBean" />

Only the third failed to compiled.



Nothing's looking wrong.....or is there...

I'm sorry if I posted this in the wrong forum.

Here's my problem...
I have a javaBean that writes stuff to the database to be saved.
It works fine when I use a testing Class to invoke the bean's method to write some dummy variables.

When I deployed it on a JSP page, I received the following error.

"org.apache.jasper.JasperException: /checkout.jsp(4,0) The value for the useBean class attribute limited.InsertDataBean is invalid.
"

I should think my bean met the bean requirements. But I can't find out what's wrong. Any help would be really really really great..

Here's my insertDataBean code

package limited; import java.sql.*; public class InsertDataBean{ private String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; private String url = "jdbc :-o dbc:LimitedVideoDSN"; private String username = ""; // No username/password required private String password = ""; // for desktop access to MS Access. private Statement statement = null; private Connection connection = null; private GetOrderIDBean idBean = new GetOrderIDBean(); // Create an empty constructor InsertDataBean(){}; //public static void main(String[] args) { public void setOrderTable(String orderName, String address, String creditCardNumber){ try { // Invoke the GetOrderIDBean method to get the last orderID idBean.readLastOrderID(); // Load database driver if it's not already loaded. Class.forName(driver); // Establish network connection to database. connection = DriverManager.getConnection(url, username, password); System.out.println("The id added to product: " + idBean.getUniqueOrderID() + "\n"); // Create a statement for executing queries. Parameters come from JSP statement = connection.createStatement(); String order = "INSERT INTO [order] VALUES (" + idBean.getUniqueOrderID() + ", '" + ProcessBean.orderName + "', '" + ProcessBean.orderAddress + "', '" + ProcessBean.orderCreditCardNumber + "');"; // Run the SQL statements to insert the details from checkout page statement.executeUpdate(order); //setOrderDetails(ProcessBean.pdtID, ProcessBean.pdtQuantity); // Close connection of database connection.close(); } catch(ClassNotFoundException cnfe) { System.err.println("Error loading driver: " + cnfe); } catch(SQLException sqle) { System.out.println("set Order Table Error "); System.err.println("Error with connection: " + sqle); } } public void setOrderDetails(int pdtID, int pdtQuantity){ try { // Invoke the GetOrderIDBean method to get the last orderID //idBean.getLastOrderID(); // Load database driver if it's not already loaded. Class.forName(driver); //idBean.getLastOrderID(); connection = DriverManager.getConnection(url, username, password); Statement statement = connection.createStatement(); System.out.println("pdt ID: " + pdtID + " uniqueOrderID: " + idBean.getUniqueOrderID() + " pdt quantity: " + pdtQuantity + "\n"); // Create a statement for executing queries. Parameters come from CartBean, JSP String orderDetails = "INSERT INTO [order details] VALUES (" + pdtID + ", " + idBean.getUniqueOrderID() + ", " + pdtQuantity + ");"; // Run the SQL statements to insert the details from checkout page statement.executeUpdate(orderDetails); // Close connection of database connection.close(); } catch(ClassNotFoundException cnfe) { System.err.println("Error loading driver: " + cnfe); } catch(SQLException sqle) { System.out.println("InsertDataBean: Set Order Details error "); System.err.println("Error with connection: " + sqle); } } }

Thanks guys!! Thanks a lot!!!

I have a class containing a private array. (as below)

public class myClass{ private int[] myArray = {1, 2, 3, 4}; public int[] getMyArray(){ return myArray; }

How can I display all the items in another class by invoking the getMyArray() method?

Let's say I have a getter method.

What is the difference between a return and a return()?

public void getMethod(){ return myInt; }
public void getMethod(){ return(myInt); }
[ October 19, 2004: Message edited by: Parka Teoh ]

Oh okay, solved. THanks to all who replied.

I had to instantiate Pack1 as an object inside Pack2.

Man, fundamentals.

Hey thanks a lot!!!

I have created a constructor to read the values into the array.

Another problem came up, though.

This file is in a package.

When I use another file to reference the array index myDouble[0] and print out using the command prompt, the result was 0.0, instead of the 21.2 I read it into the first file (Pack1.java in this case)

Here's my other file called Pack2.java

package limited; public class Pack2{ public static void main(String args[]){ for (int i = 0; i<Pack1.myDouble.length; i++) System.out.println(Pack1.myDouble[i]); } }

I create the simplest array and it doesn't work...

Here's the java file with the array code

package limited; public class Pack1{ static double[] myDouble = new double[10]; myDouble[0] = 21.2; }

It gives me the following error message..

D:\webapp_proj2\WEB-INF\classes\limited\Pack1.java:9: ']' expected
myDouble[0] = 21.2;
^
D:\webapp_proj2\WEB-INF\classes\limited\Pack1.java:9: <identifier> expected
myDouble[0] = 21.2;

I'm lost.

I've tried System.out.println in the connection file too. And the queries were printed out correctly. I have 9 items, and all the 9 items were displayed.

But somehow when I run the other java file to reference the array from the connection file, it returns null.

hmmm...

I have an array in a jdbc class file.
But I can't reference it in another class file in the same package.


Here's my jdbc connection class code

public class LimitedConnBean2{ static String[] pdtTitle = new String[10]; static double[] pdtCost = new double[10]; static String[] pdtCategory = new String[10]; public static void main(St......

and further down (in the same file )I have

int i = 0; // Print results. while(resultSet.next()) { pdtTitle[i] = resultSet.getString("pdt_title"); pdtCost[i] = resultSet.getInt("pdt_cost"); pdtCategory[i] = resultSet.getString("pdt_category"); System.out.print(i + 1 + ". " + pdtTitle[i] + " cost " + pdtCost[i] + " and is a " + pdtCategory[i] + "\n"); i++;

in another file called file2.java, I tried to reference the array in the above file using the following...

... public static void main(String args[]) { System.out.println(LimitedConnBean2.pdtTitle[0]); ...

I've got null printed.

I don't know what I've missed...

[ October 17, 2004: Message edited by: Parka Teoh ]
[ October 17, 2004: Message edited by: Parka Teoh ]

The service method is not empty. And I've put the servlet in the correct package in the correct class.

I've also repackaged the servlet. But still doesn't work.

I got the code from a textbook's CD, so can't think of what other things that could go wrong.

Here's the code.

package tiger; import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class NorthwindServlet extends HttpServlet { public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\"\n"; String title = "Northwind Results"; out.print(docType + "<HTML>\n" + "<HEAD><TITLE>" + title + "</TITLE></HEAD>\n" + "<BODY BGCOLOR=\"#FDF5E6\"><CENTER>\n" + "<H1>Database Results</H1>\n"); String driver = request.getParameter("driver"); String url = request.getParameter("url"); String username = request.getParameter("username"); String password = request.getParameter("password"); String query = request.getParameter("query"); showTable(driver, url, username, password, query, out); out.println("</CENTER></BODY></HTML>"); } public void showTable(String driver, String url, String username, String password, String query, PrintWriter out) { try { // Load database driver if it's not already loaded. Class.forName(driver); // Establish network connection to database. Connection connection = DriverManager.getConnection(url, username, password); // Look up info about the database as a whole. DatabaseMetaData dbMetaData = connection.getMetaData(); out.println("<UL>"); String productName = dbMetaData.getDatabaseProductName(); String productVersion = dbMetaData.getDatabaseProductVersion(); out.println(" <LI><B>Database:</B> " + productName + " <LI><B>Version:</B> " + productVersion + "</UL>"); Statement statement = connection.createStatement(); // Send query to database and store results. ResultSet resultSet = statement.executeQuery(query); // Print results. out.println("<TABLE BORDER=1>"); ResultSetMetaData resultSetMetaData = resultSet.getMetaData(); int columnCount = resultSetMetaData.getColumnCount(); out.println("<TR>"); // Column index starts at 1 (a la SQL), not 0 (a la Java). for(int i=1; i <= columnCount; i++) { out.print("<TH>" + resultSetMetaData.getColumnName(i)); } out.println(); // Step through each row in the result set. while(resultSet.next()) { out.println("<TR>"); // Step across the row, retrieving the data in each // column cell as a String. for(int i=1; i <= columnCount; i++) { out.print("<TD>" + resultSet.getString(i)); } out.println(); } out.println("</TABLE>"); connection.close(); } catch(ClassNotFoundException cnfe) { System.err.println("Error loading driver: " + cnfe); } catch(SQLException sqle) { System.err.println("Error connecting: " + sqle); } catch(Exception ex) { System.err.println("Error with input: " + ex); } } private static void showResults(ResultSet results) throws SQLException { while(results.next()) { System.out.print(results.getString(1) + " "); } System.out.println(); } private static void printUsage() { System.out.println("Usage: PreparedStatements host " + "dbName username password " + "vendor [print]."); } }

I noticed that sometimes my IMAGE button doesn't appear.

Is it a bug?