What is wrong?

[Roberto Favaro]

Can anyone sort out my ammend and get OrderDetails Methods?

/*
This method returns a reference to an Order object.  This object contains details
of the order with id aOrderId, as well as details of each OrderLine in the order.
*/
 
public Order getOrderDetails(String aOrderId) throws SQLException
{
Connection con = null ;
Statement stmt = null ;
ResultSet rs = null ;
Order order = null ;
 
try
{
con = getConnection() ;
stmt = con.createStatement() ;
String query = "SELECT * from Orders WHERE OrderId = '" + aOrderId + "'" ;
System.out.println(query) ;
rs = stmt.executeQuery(query) ;
 
if (rs.next() )
{
String orderId = rs.getString("OrderId") ;
String date = rs.getString("Date") ;
order = new Order(orderId, date) ;
}
if (order != null)
{
rs.close() ;
rs = null ;
query = "SELECT * from OrderLines WHERE OrderId = '" + aOrderId+ "'" ;
System.out.println(query) ;
rs = stmt.executeQuery(query) ;
while (rs.next() )
{
String orderId = rs.getString("OrderId") ;
String productId = rs.getString("ProductId") ;
}
}
}
catch(SQLException e)
{
throw new SQLException("getOrderDetails(): " + e.getMessage() ) ;
}
finally
{
if (rs != null)
rs.close() ;
if (stmt != null)
stmt.close() ;
if (con != null)
freeConnection(con) ;
}
return order ;
}
  

public int amendProduct(Product p) throws SQLException
{
Connection con = null ;
Statement stmt = null ;
int rows = 0 ;
try
{
con = getConnection() ;
stmt = con.createStatement();
//String command = "UPDATE Products SET Category = '"
//+ category + "', Price = " + price
//+ "', QtyInStock = " + qtyInStock
//+ " WHERE ProductId = " + productId ;
//System.out.println(command);
//rows = stmt.executeUpdate(command);
}
 
catch(SQLException e)
{
throw new SQLException("amendProduct(): " + e.getMessage() ) ;
}
finally
{
if (stmt != null)
stmt.close() ;
if (con != null)
freeConnection(con) ;
}
 
return rows ;
}  

[ankur rathi]

U cant call ' getConnection ' method like this .

DriverManager.getConnection(.....) // it will take some parameter like ur driver type ( thin/thick ) , username , password , database , table .

Before that u have to load the driver also .
Class.forName(.) // ur driver name .

try this , probably it will work .