Java homework please help! :(?

Question

I coded a script, Currently I can add and delete items to the database but I cannot edit the data. Here's my 3 paged script :

Christmasswishlist.java

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

/**
* Servlet implementation class for Servlet: ChristmasWishlist
*
*/
public class ChristmasWishlist extends javax.servlet.http.HttpServlet implements
javax.servlet.Servlet
{
static final long serialVersionUID = 1L;

/*
* Connect to the database
*/

/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#HttpServlet()
*/
public ChristmasWishlist()
{
super();
}

/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{
// TODO Auto-generated method stub
process(request, response);
}

/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{
// TODO Auto-generated method stub
process(request, response);
}

protected void process(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html");
java.io.PrintWriter out = response.getWriter();
out.println("");

//check if you are getting the right values, comment out once the program is working
//line below will work only for java 5 up
java.util.Enumeration e = request.getParameterNames();
while (e.hasMoreElements())
{
String gift = e.nextElement().toString();
out.println("
" + gift + " - " + request.getParameter(gift));
}

if (request.getParameter("submit") != null)
{
if (!request.getParameter("submit").isEmpty())
{
if (request.getParameter("submit").equals("Add"))
{
if (!request.getParameter("gift").isEmpty())
{
out.println(addChristmasWishlist(request
.getParameter("gift")));
}
else
{
out.println("

Nothing to do");
}
}

else if(request.getParameter("submit").equals("Delete"))
{
delChristmasWishlist(Integer.parseInt(request.getParameter("id")));
}
else if(request.getParameter("submit").equals("Delete"))
{
out.println("

Nothing to do");
}
}

} else
{
out.println("

empty");
}
out.println("

Add again");

ResultSet rst = null;
try
{
rst = viewChristmasWishlist();
int count = 1;
out.println("

");
while(rst.next())
{
out.println("" +
"");
count++;
}
out.println("

ChristmasWishlist
"+count+".	"+rst.getString("gift")+"	Edit"+ "	Delete

");
}
catch(Exception e2)
{

}

out.println("");

}

public String addChristmasWishlist(String wish)
{

try
{
ConnectionManager con = new ConnectionManager();
Statement stmt = con.logOn().createStatement();
String msg = "";
String sql = "insert into wishes set gift='" + wish.replaceAll("\'", "\\\'") + "'";
if (stmt.execute(sql))
{
msg = "Insert failed";
}
else
{
msg = "Added successfully";
}
con.logOff();
return msg;

}
catch (SQLException e)
{

return "Add failed. SQL error " + e.getMessage();
}
catch (java.lang.NullPointerException ne)
{

return "Null error: " + ne.getMessage();
}

}


public String delChristmasWishlist(int id)
{

try
{
ConnectionManager con = new ConnectionManager();
Statement stmt = con.logOn().createStatement();
String msg = "";
String sql = "delete from wishes where id="+id;
if (stmt.execute(sql))
{
msg = "Delete failed";
} else
{
msg = "Delete successfully";
}
con.logOff();
return msg;

} catch (SQLException e)
{

return "Add failed. SQL error " + e.getMessage();
} catch (java.lang.NullPointerException ne)
{

return "

Null error: " + ne.getMessage();
}



}

public String editChristmasWishlist(String wish)
{

try
{
ConnectionManager con = new ConnectionManager();
Statement stmt = con.logOn().createStatement();
String msg = "";
String sql = "update from wishes where gift="+wish;
if (stmt.execute(sql))
{
msg = "update failed";
} else
{
msg = "update successfully";
}
con.logOff();
return msg;

} catch (SQLException e)
{

return "Add failed. SQL error " + e.getMessage();
} catch (java.lang.NullPointerException ne)
{

return "

Null error: " + ne.getMessage();
}



}

public ResultSet viewChristmasWishlist()
{

ResultSet rst = null;
try
{
ConnectionManager con = new ConnectionManager();
Statement stmt = con.logOn().createStatement();
String msg = "";

String sql = "select * from wishes";
rst = stmt.executeQuery(sql);


} catch (SQLException e)
{


} catch (java.lang.NullPointerException ne)
{


}
return rst;
}



Connectionmanager.java

import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionManager {

protected Connection con;
protected String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/";
String database = "WishList";
String user = "root";
String password = "";

/** Creates a new instance of ConnectionManager */
public ConnectionManager() {

}
public Connection logOn(){
try {
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+database,user,password);

}
catch(Exception e){
System.out.print(e.getMessage());
}
return con;

}

public void logOff(){
try {
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}

Wish.html

Place Your Christmas Wishes Here

Wish:
Amount:

Answer 1

Try
"update wishes set gift="+wish+" where id="+id;

Good luck.