QuestionAsk Questions?
harini
javascript for textbox or prompt using servlet
1 Answer(s) 2 years and 10 months ago
Posted in : JSP-Servlet
1 Answer(s) 2 years and 10 months ago
Posted in : JSP-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..
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
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
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
