javascript for textbox or prompt using servlet

Dear sir
I am writing script in servlet,so prompt() is not working here so please help me...In my project when a vendors want to delete the uploaded file ,if they are confirmed to delete the i have to take a reason for deleting a textbox as to come if press ok then delete the file then i have to store that reason in a data base so how to do in servlet.please help
me..

My code is as follows
out.println("function del(path,xxx){");
out.println(" var Cv = null;");
out.println(" Cv = confirm(\"Are you sure to delete the file?\");");
out.println(" if(Cv){");
out.println("if(path == \"detach\"){");
out.println(" var reason=prompt('Reason for deleting:','')");
out.println("document.attach.CatId.value=xxx;");
out.println("document.attach.action=\"../servlet/del_files\";");
out.println("document.attach.submit();")
out.println("}");
out.println("}");
out.println("}");

Thanks..

View Answers

July 15, 2010 at 4:01 PM

Hi Friend,

Try the following code:

1)Servlet.java:

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Servlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException{
PrintWriter out = response.getWriter();
out.println("<html><head><script>function deleteRecord(id){var r=confirm('Are you confirm')");
out.println("if (r==true){var reason=prompt('Reason for deleting:')");
out.println("window.open('http://localhost:8080/examples/modified/deleteuser.jsp?id='+id+'&&reas='+reason,'mywindow','width=500, height=350,toolbar=no,resizable=yes,menubar=yes')");
out.println("}}</script></head>");
out.println("<form name='form'>");
out.println("<table border='1'>");
out.println("<tr><th>FirstName</th><th>LastName</th><th>Address</th><th>Email</th></tr>");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String userName ="root";
String password="root";
int sumcount=0;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String query = "select * from employee";
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
out.println("<tr><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td><td>"+rs.getString(5)+"</td>");
out.println("<td><input type='button' name='edit' value='Delete' style='background-color:red;font-weight:bold;color:#ffffff;' onclick=\"deleteRecord('"+rs.getString(1)+"');\"></td></tr>");
}
}
catch (Exception e) {
e.printStackTrace();
}
out.println("</table>");
out.println("<form>");
out.println("</html>");
}
}

2)deleteuser.jsp:

<%@page language="java"%>
<%@page import="java.sql.*"%>
<%
String reason=request.getParameter("reas");
out.println("Reason is: "+reason);
String id=request.getParameter("id");
int no=Integer.parseInt(id);
int sumcount=0;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";, "root", "root");
Statement st = conn.createStatement();
st.executeUpdate("DELETE FROM employee WHERE userid = '"+no+"'");
out.println("<br>Record is deleted successfully");
}
catch(Exception e){}
%>

Hope that it will be helpful for you.
Thanks