deleting messages using checkbox in JSP

deleting messages using checkbox in JSP

Am working on a Mail Server Project. In that I have Inbox And Outbox Messages. Now Each and Every message is deleting correctly in my project. But Problem occurs when i use to delete the last message left in both in/out box. i have done the validations which says an alert while i directly click on button(which it should show) without checking it but if during last message left in mail and its already checked;i click on button it shows an error. A when there is no message in it and i click on delete its showing jasper error(Instead of showing 'there is no message in outbox/inbox'). am posting my code also.....

<html>
<head>
<script>
    function ValidateForm()
    {
        var flag = false;
        for(i=0;i< document.frm.inboxchk.length;i++)
        {
            if(document.frm.inboxchk[i].checked)
                flag = true;
        }

        if(!flag)
        {
            alert('Please select Mails');
            return false;
        }
        return true;
    }
</script>
</head>
<body>
<form action="DeleteOutbox.jsp" method="post" name="frm" onsubmit="return ValidateForm();">

outbox.jsp

<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.io.File"%>
<%@ page import="java.util.*"%>
<%

    PMS.common.PMSDBManager obj = new PMS.common.PMSDBManager();
    String sesUserId=(String)session.getAttribute("UserId");
    if(sesUserId == null)
    {   
        response.sendRedirect("Login.jsp");
    }
    else
    {   
        String empid=request.getParameter("empid");
        if(sesUserId == null)
        {   
            response.sendRedirect("Login.jsp");
        }


        Calendar cal = Calendar.getInstance();
        String CurrentTime = cal.get(Calendar.HOUR) + ":" + cal.get(Calendar.MINUTE) + ":" + cal.get(Calendar.SECOND);
        String CurrentDate = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH)+1) + "/" + cal.get(Calendar.DATE);
        String sql="SELECT * FROM mstOutbox WHERE fromuid='"+sesUserId+"' AND dstatus='N'";
        ResultSet rs=obj.getResultSet(sql); 

%>  <center><i><h4>OUTBOX:</h4></i>
    <table BORDER="1" CELLPADDING="2">
    <tr>    <td></td>
        <td>Subject</td>
        <td>To</td>
        <td>Date</td>
        <td>Time</td>
    <tr>
<% 

    while(rs.next())
    { 
        int frmid=rs.getInt("touid");
        String sql1="SELECT * FROM mstRegistration WHERE userid='"+frmid+"'";
        ResultSet rs1=obj.getResultSet(sql1);
        while(rs1.next())
        {
        %>
    <tr>    <td><input type="checkbox" name="inboxchk" value="<%=rs.getInt("omailid")%>"></td>
        <td><h4><i><a href="Displaymail.jsp?empid=<%=rs.getInt("omailid")%>&userid=<%=rs1.getString("userid")%>&outbox=Y" target="middle_pane"><%out.println(rs.getString("subject"));%></a></i></h4></td>
        <td><h4><i><%out.println(rs1.getString("firstname"));%></i></h4></td>
        <td><h4><i><%out.println(rs.getString("date"));%></i></h4></td>
        <td><h4><i><%out.println(rs.getString("time"));%></i></h4></td>
    </tr>
<%}}
%>
    </table>
    <input type="submit" name="delete" value="Delete Mail" onClick="return ValidateForm();">
    </center>
</form>
</body>
</html>
<%}%>

deleteout.jsp

<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.io.File"%>
<%
    PMS.common.PMSDBManager obj = new PMS.common.PMSDBManager();
    String sesUserId=(String)session.getAttribute("UserId");
    if(sesUserId == null)
    {   
        response.sendRedirect("Login.jsp");
    }
    else
    {   

        String[ ] touserId = request.getParameterValues("inboxchk");
        boolean booln = false;
        for(int i=0;i<touserId.length;i++)
        {
            System.out.println("IN DELETE PAGE OF OUTBOX>>>>>>>>>>>>>>>>>>"+touserId[i]);

            String delsqlinx = "UPDATE mstOutbox SET dstatus='Y' WHERE omailid='"+touserId[i]+"' AND fromuid='"+sesUserId+"'";

            booln = obj.executeQuery(delsqlinx);
        }
        response.sendRedirect("Outbox.jsp");
}%>
View Answers

Ads









Related Tutorials/Questions & Answers:
deleting messages using checkbox in JSP
deleting messages using checkbox in JSP  Am working on a Mail Server Project. In that I have Inbox And Outbox Messages. Now Each and Every message is deleting correctly in my project. But Problem occurs when i use to delete
deleting messages using checkbox in JSP
deleting messages using checkbox in JSP  Am working on a Mail Server Project. In that I have Inbox And Outbox Messages. Now Each and Every message is deleting correctly in my project. But Problem occurs when i use to delete
Advertisements
how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp  how to insert check box value to the database using jsp my code is <link href...; <td align="center"> <input type="checkbox
how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp  How to insert check box value to the oracle database using jsp? I want to create hotel's... for="pack_meal"></label> <input type="checkbox
how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp  How to insert check box value to the oracle database using jsp? I want to create hotel's...;   Here is a simple jsp code that insert the selected checkbox values
JSP CheckBox
JSP CheckBox          JSP CheckBox is used to create a CheckBox in JSP... illustrate an elaborate example from 'JSP CheckBox'. To understand and grasp
JSP Checkbox
JSP Checkbox In this tutorial you will learn how to create a checkbox using JSP. As we know, checkbox allows multiple selection at a time, but radio... selection always go for checkbox. Using the example we will try to understand how
how to get the checkbox value in jsp
how to get the checkbox value in jsp  how to get the checkbox value in jsp?   JSP CheckBox Example - how to get the checkbox value in jsp
checkbox selection in jsp
checkbox selection in jsp  hey guys i am working on a web based project using jsp. In my project i am having 9 check boxes in 3 rows in the same form. I want to select i check box from each row and also i want to avoid many
checkbox with dropdown listbox in jsp
checkbox with dropdown listbox in jsp  i loaded the the data into the drop down listbox in jsp from access database.now i have to add a check box,if it checked means dropdownlist box carryout the data's,else it should
checkbox
checkbox  how to insert multiple values in database by using checkbox in jsp
Learn about JSP CheckBox
Learn JSP CheckBox The tutorial highlight the features by whihc you will be able to know what is JSP checkbox and also how it works in creating a checkbox... to select multiple languages using checkbox. After submitting the button, the action
delete multiple row using checkbox
delete multiple row using checkbox  how to delete multiple row in a table which is connected to database using checkbox
delete multiple row using checkbox
delete multiple row using checkbox  how to delete multiple row in a table which is connected to database using checkbox
Deleting Records using the Prepared Statement
Deleting Records using the Prepared Statement       This section helps us for deleting the records from the database table by using the PreparedStatement interface
insert data in the database using checkbox
insert data in the database using checkbox  i am fetching data from the database using servlet on the jsp page and there is checkbox corresponding...;input type="checkbox" name="check<%=i%>" value=<%= rs.getString("bookid
delete multiple row using checkbox
delete multiple row using checkbox  delete multiple row using checkbox   We are providing you the code where we have specified only three... i=0; while(rs.next()){ %> <tr><td><input type="checkbox" name
Adding checkbox in table using that delete table rows
Adding checkbox in table using that delete table rows  I need coding for how to add checkbox in table,the table data from database.Using that checkbox select more than than one rows,and using delete button i want to delete
insert checkbox in cell using POI api in java
insert checkbox in cell using POI api in java  I need to insert checkbox in excel cell using POI and java. Any one help me on this. Ashok S
Is JSF using JSP?
Is JSF using JSP?  Is JSF using JSP
JSP Delete Record From Table Using MySQL
JSP Delete Record From Table Using MySQL This tutorial explains you that how to write a JSP for deleting a record from database table. In this section you... for deleting a record of a database table in jsp. To accomplish this task we
tree using jsp code
tree using jsp code  i want to draw a tree structure of a family hierarchy using jsp code
A Java Program by using JSP
A Java Program by using JSP  how to draw lines by using JSP plz show me the solution by using program
generate charts using JSP
generate charts using JSP  any one know coding for generate bar chart or pie chart using JSP
ScatterPlot using jsp
ScatterPlot using jsp  hi, can anybody provide me code for ScatterPlot using jsp. thanks
BMI by using JSP Languange
BMI by using JSP Languange  Using JSP language, create a system that calculates Body Mass Index (BMI) of users who entered their weight and height. Then, system will display all the records. Can you provide me the coding
BMI by using JSP Languange
BMI by using JSP Languange  Using JSP language, create a system that calculates Body Mass Index (BMI) of users who entered their weight and height. Then, system will display all the records. Can you provide me the coding
video uploading using jsp
video uploading using jsp  how to upload a videos in web page using jsp   Hi, You can upload your video with the help of JSP file upload code. Once file is upload you can play using any video player. Get the code
generate pdf using jsp
generate pdf using jsp  how do i generate a pdf using jsp that should query the data from the database and write it into a pdf and download the same
Jsp using mvc - JSP-Servlet
Jsp using mvc  hi I have written using mvc2 architecture, i have written logic in java ,i want to print a message on the form stating the the values are inserted successfully.So can you tell me how i have to write the code
jsp using netbeans
jsp using netbeans  Code to access and manage multiple e-mail accounts on the same page.. user should be able to edit mail accounts' link as required

Ads