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("
List of All Your Wishes");
//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("
ChristmasWishlist |
");
while(rst.next())
{
out.println(""+count+". | "+rst.getString("gift")+" | " +
"Edit"+
" | Delete |
");
count++;
}
out.println("
");
}
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
Christmas Wishes
Place Your Christmas Wishes Here
2007-12-19
02:37:30
·
1 answers
·
asked by
Patrick M
1
in
Programming & Design