Starting to open the connection at the beginning of the class

[Nico Yukiko]

How come i can't place the try at the start of a new class and the code below is giving me a problem.and regarding declaring an array to store the info in the database to replace the static code at the bottom is also giving problem.

public class Catalog {
    static String itemName,carModel,specifications,listPrice;
         try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException e) {
      send.println("Error is" + e);
    }
    try {
      Connection conn = DriverManager.getConnection("jdbc  :-o	  dbc  :-P	  roduct");
      Statement stmt = conn.createStatement();
      String sqlStr ="Select itemName,serialNumber,carModel,specifications,listPrice from ItemDetails where itemName='000000'";
      send.println(sqlStr);
      ResultSet rs = stmt.executeQuery(sqlStr);
      ResultSetMetaData info = rs.getMetaData();
      int columnCount=info.getColumnCount();
      String[] columns=new String[columnCount];
      int[] widths= new int[columnCount];
      send.println("<TABLE BORDER=1 width=700 bordercolor=\"#3300CC\">");
       while (rs.next()) {
         itemName=rs.getString("itemName");
         carModel=rs.getString("carModel");
       specifications=rs.getString("specification");
       listPrice=rs.getString("listPrice");
       for(int k=0;k<rs.getRow();k++){
       Item[k] items = {new Item(itemName, carModel, specifications, listPrice)};
}
       }
    }
      catch (SQLException e) {
        send.println("Error " + e);
      }
       send.println("</TABLE>");
      send.println("</body></html>");
      send.close();
    }
private static Item[] items =
//    { new Item(itemName,
//               "<I>"+carModel+"</I> ",
//               specifications,44.44),
     { new Item("hall002",
               "<I>Core Web Programming, Java2 Edition</I> " +
                 "by Marty Hall, Larry Brown, and " +
                 "Paul McNamee",
               "One stop shopping for the Web programmer. " +
                 "Topics include \n" +
                 "<UL><LI>Thorough coverage of Java 2; " +
                 "including Threads, Networking, Swing, \n" +
                 "Java2D, and Collections\n" +
                 "<LI>A fast introduction to HTML 4.01, " +
                 "including frames, style sheets, layers,\n" +
                 "and Netscape and Internet Explorer " +
                 "extensions.\n" +
                 "<LI>A fast introduction to HTTP 1.1, " +
                 "servlets, and JavaServer Pages.\n" +
                 "<LI>A quick overview of JavaScript 1.2\n" +
                 "</UL>",
               49.95),  

[edited to add code tags]
[ August 24, 2005: Message edited by: Jeanne Boyarsky ]

[Bear Bibeault]

Basic Java. All executable statements must be within a method.

[Nico Yukiko]

But how can i separate the code into a method and then call the method

[Jeanne Boyarsky]

Nico,
Welcome to JavaRanch!

I'm guessing you want to run this as a standalone program. In that case, add the line:

public static void main(String[] args) {

before the first "try {". And then close the brace with a } at the end of the code.

To call it, you can then do "java Catalog" from the command line.

[Nico Yukiko]

But how can i store the information retrieve from the database into an array so that i can create a new catalog item base on the array

[Stephen Boston]

You may want to check out ArrayList.

LearnJDBC