Obtain information in JSP from a JavaScript function that was generated in another JSP file

Question

Obtain information in JSP from a JavaScript function that was generated in another JSP file

I have created a code that allows the admin to toggle a user's status between active and inactive using radio buttons. The technologies I have used for this project are JSP, MySQL, and JS.

admin.jsp:

    <tr>
                <td>
                  Name:  <% out.println(firstname); %> <% out.println(lastname); %>  

                </td>
                <td>
                    <% if (flag.equals("A")){ %>

                    Active: <input type="radio" value="A" name="<% out.println(email); %>" id="<% out.println(email); %>" onchange="pageupdatecta('<% out.println(email); %>', this.value);" checked>
                    Inactive: <input type="radio" value="I" name="<% out.println(email); %>" id="<% out.println(email); %>" onchange="pageupdatecti('<% out.println(email); %>', this.value);">
                   <%
                        }else if(flag.equals("I")){%>

                    Active: <input type="radio" value="A"  name="<% out.println(email); %>" id="<% out.println(email); %>" onchange="pageupdatecta('<% out.println(email); %>', this.value);">
                    Inactive: <input type="radio" value="I" name="<% out.println(email); %>" id="<% out.println(email); %>" onchange="pageupdatecti('<% out.println(email); %>', this.value);" checked>
<%   
} %>
<script type="text/javascript">
  function pageupdatecta(emailid, optedval) {
       location.href='changeToActive.jsp?email='+emailid+'&optedval='+o‌ptedval; 
   } 
    function pageupdatecti(emailid, optedval) {
       location.href='changeToInactive.jsp?email='+emailid+'&optedval='+o‌ptedval; 
   }     
</script>

changeToActive.jsp:

    try{

Class.forName("com.mysql.jdbc.Driver");
System.err.println("Driver loaded!");

Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost/work", "root", "MyNewPass");
System.err.println("Database Connected..");

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                       ResultSet.CONCUR_READ_ONLY);

stmt.executeUpdate("update assignment set flag='A' where email='"+email+"'");
                                   System.err.println("A"+email);

}

I'm looking for guidance on how to retrieve values from the function and troubleshoot my code. Can you assist with this?

javascript java mysql jsp

Answer 1

Answer №1

Retrieve a record from the assignment table in the work database for id=1.
The radio button's checked status is determined by the existing status in the DB.

Any changes made from active to inactive or vice versa will be updated in the database.

index.jsp Page:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" %>
<%@ page import="java.sql.*,stack.filter.JDBCConnector" %>  
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Radio Select</title>
</head>
<body>
<%
Connection con = null;
String firstname = null;
String lastname = null;
String email = null;
String flag = null;
try {
    con = JDBCConnector.connect_database();
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery("select * from assignment where id=1");

    while(rs.next()){
        firstname=rs.getString(2);
        lastname=rs.getString(3);
        email=rs.getString(4);
        flag=rs.getString(5);
    }
    System.out.println(""+firstname+" "+lastname+" "+email+" "+flag);
} catch (Exception e) {
    e.printStackTrace();
} finally {
    con.close();
}
%>
<table>
    <tr>
        <td>
              Name:  <% out.println(firstname); %> <% out.println(lastname);          %>
        </td>
        <td> 
         <%
            if(flag.equals("A")){
                %> Active: <input type="radio" name="<%=email%>" id="r1" value="A" onclick="updateStatus()" checked="checked"/> 
                 In active: <input type="radio" name="<%=email%>" id="r2" value="I" onclick="updateStatus()"/>
                 <%
            }else if(flag.equals("I")){
                %> Active: <input type="radio" name="<%=email%>" id="r1" value="A" onclick="updateStatus()"/> 
                 In active: <input type="radio" name="<%=email%>" id="r2" value="I" onclick="updateStatus()" checked="checked"/>
                 <%
            }
         %>
        </td>
    </tr>
</table>
<script type="text/javascript">
        function updateStatus(){
            if (document.getElementById('r1').checked) {
                location.href='changeToActive.jsp?email='+'${email}'+'&status=A';
            }else if (document.getElementById('r2').checked) {
                location.href='changeToActive.jsp?email='+'${email}'+'&status=I';
            }       
        }
</script>
</body>
</html>

changeToActive.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*,stack.filter.JDBCConnector" %>  
<%
Connection con = null;
try {
    con = JDBCConnector.connect_database();
    System.err.println("Database Connected..");

    Statement stmt = con.createStatement();
    String status = request.getParameter("status");
    String email = request.getParameter("email");
    int i= stmt.executeUpdate("UPDATE assignment SET status='"+status+"' where email='"+email+"'");
    if(i==1){
        out.println("Successfully updated the status");
    }

} catch (Exception e) {
    e.printStackTrace();
}finally{
    con.close();
}
%>

JDBCConnector.java class: used for creating a connection object in your app.

package stack.filter;

import java.sql.Connection;
import java.sql.DriverManager;
public class JDBCConnector {        
public static Connection connect_database(){
    Connection con = null;
    try{
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/work", "root", "root");
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if(con!=null)
        {
            System.out.println("Connected...");
        }
    }
    return con;
}
}

Assignment Table:

CREATE TABLE `assignment` (
`id` INT(11) NOT NULL,
`firstname` VARCHAR(30) DEFAULT NULL,
`lastname` VARCHAR(30) DEFAULT NULL,
`email` VARCHAR(30) DEFAULT NULL,
`status` CHAR(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) 

/*Data for the table `assignment` */

INSERT  INTO `assignment`(`id`,`firstname`,`lastname`,`email`,`status`) VALUES (1,'rohit','gaikwad','<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="ea988582839e8d8b83819d8b8eaa929390c4898587">[email protected]</a>','I');

Note: The id=1 primary key is hardcoded. If there is a logic in place to display assignment records, it will be reflected in the table.

Answer 2

Retrieve a record from the assignment table in the work database for id=1.
The radio button's checked status is determined by the existing status in the DB.

Any changes made from active to inactive or vice versa will be updated in the database.

index.jsp Page:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" %>
<%@ page import="java.sql.*,stack.filter.JDBCConnector" %>  
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Radio Select</title>
</head>
<body>
<%
Connection con = null;
String firstname = null;
String lastname = null;
String email = null;
String flag = null;
try {
    con = JDBCConnector.connect_database();
    Statement stmt = con.createStatement();
    ResultSet rs=stmt.executeQuery("select * from assignment where id=1");

    while(rs.next()){
        firstname=rs.getString(2);
        lastname=rs.getString(3);
        email=rs.getString(4);
        flag=rs.getString(5);
    }
    System.out.println(""+firstname+" "+lastname+" "+email+" "+flag);
} catch (Exception e) {
    e.printStackTrace();
} finally {
    con.close();
}
%>
<table>
    <tr>
        <td>
              Name:  <% out.println(firstname); %> <% out.println(lastname);          %>
        </td>
        <td> 
         <%
            if(flag.equals("A")){
                %> Active: <input type="radio" name="<%=email%>" id="r1" value="A" onclick="updateStatus()" checked="checked"/> 
                 In active: <input type="radio" name="<%=email%>" id="r2" value="I" onclick="updateStatus()"/>
                 <%
            }else if(flag.equals("I")){
                %> Active: <input type="radio" name="<%=email%>" id="r1" value="A" onclick="updateStatus()"/> 
                 In active: <input type="radio" name="<%=email%>" id="r2" value="I" onclick="updateStatus()" checked="checked"/>
                 <%
            }
         %>
        </td>
    </tr>
</table>
<script type="text/javascript">
        function updateStatus(){
            if (document.getElementById('r1').checked) {
                location.href='changeToActive.jsp?email='+'${email}'+'&status=A';
            }else if (document.getElementById('r2').checked) {
                location.href='changeToActive.jsp?email='+'${email}'+'&status=I';
            }       
        }
</script>
</body>
</html>

changeToActive.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*,stack.filter.JDBCConnector" %>  
<%
Connection con = null;
try {
    con = JDBCConnector.connect_database();
    System.err.println("Database Connected..");

    Statement stmt = con.createStatement();
    String status = request.getParameter("status");
    String email = request.getParameter("email");
    int i= stmt.executeUpdate("UPDATE assignment SET status='"+status+"' where email='"+email+"'");
    if(i==1){
        out.println("Successfully updated the status");
    }

} catch (Exception e) {
    e.printStackTrace();
}finally{
    con.close();
}
%>

JDBCConnector.java class: used for creating a connection object in your app.

package stack.filter;

import java.sql.Connection;
import java.sql.DriverManager;
public class JDBCConnector {        
public static Connection connect_database(){
    Connection con = null;
    try{
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/work", "root", "root");
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if(con!=null)
        {
            System.out.println("Connected...");
        }
    }
    return con;
}
}

Assignment Table:

CREATE TABLE `assignment` (
`id` INT(11) NOT NULL,
`firstname` VARCHAR(30) DEFAULT NULL,
`lastname` VARCHAR(30) DEFAULT NULL,
`email` VARCHAR(30) DEFAULT NULL,
`status` CHAR(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) 

/*Data for the table `assignment` */

INSERT  INTO `assignment`(`id`,`firstname`,`lastname`,`email`,`status`) VALUES (1,'rohit','gaikwad','<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="ea988582839e8d8b83819d8b8eaa929390c4898587">[email protected]</a>','I');

Note: The id=1 primary key is hardcoded. If there is a logic in place to display assignment records, it will be reflected in the table.

Answer 3

Answer №2

To retrieve the query parameters' values, simply do the following:

String email = request.getParameter("email");
String optedval = request.getParameter("optedval");

After obtaining the values, you can integrate them into your SQL query.

Answer 4

To retrieve the query parameters' values, simply do the following:

String email = request.getParameter("email");
String optedval = request.getParameter("optedval");

After obtaining the values, you can integrate them into your SQL query.

Answer 5

Answer №3

Make sure to differentiate the IDs of the radio buttons to avoid conflicts.

Active: <input type="radio" value="A" name="<% out.println(email); %>" id="id1" onchange="pageupdatecta('<% out.println(email); %>');" checked>
Inactive: <input type="radio" value="I" name="<% out.println(email); %>" id="id2" onchange="pageupdatecti('<% out.println(email); %>');">


<script> 
function pageupdatecta(emailid) { 
alert('Hi');
location.href='changeToActive.jsp?email='+emailid; 
} 
function pageupdatecti(emailid) { 
alert('Hi'); 
location.href='changeToActive.jsp?email='+emailid;
} 
</script>

Ensure in your servlet that you use

String email = request.getParameter("email");

to retrieve the email value.

Answer 6

Make sure to differentiate the IDs of the radio buttons to avoid conflicts.

Active: <input type="radio" value="A" name="<% out.println(email); %>" id="id1" onchange="pageupdatecta('<% out.println(email); %>');" checked>
Inactive: <input type="radio" value="I" name="<% out.println(email); %>" id="id2" onchange="pageupdatecti('<% out.println(email); %>');">


<script> 
function pageupdatecta(emailid) { 
alert('Hi');
location.href='changeToActive.jsp?email='+emailid; 
} 
function pageupdatecti(emailid) { 
alert('Hi'); 
location.href='changeToActive.jsp?email='+emailid;
} 
</script>

Ensure in your servlet that you use

String email = request.getParameter("email");

to retrieve the email value.

Obtain information in JSP from a JavaScript function that was generated in another JSP file

Answer №1

Answer №2

Answer №3

Similar questions

Proceed with downloading the file only when a checkbox has been ticked off and the form has been

Print out 5000 entries using PHP and then delete them

Implement a dropdown menu in Vue.js using data fetched from an ajax request

Encountered a ClassCastException while processing a Firewalled Request in the session management filter of the Spring filter chain

Changing the image source when clicking on it and removing it can be done by using JavaScript

What is the best way to modify the size of a canvas element while maintaining effectiveness?

Tips on avoiding the accumulation of event handlers when dealing with click events triggered by the document selector in jQuery

Exploring the concept of $http/$q/promise in Angular

What is the process for triggering a PHP function when a form element is clicked in a webpage?

Increase the value of count (an AJAX variable) by 4 upon clicking the button, then send it over to the PHP script

Vue verifies the readiness of two computed properties

Enhance Your MUI React Component with Custom Styles and ThemeProvider Integration

What is the best way to retrieve a style property from a <style> tag using JavaScript?

Converting an Array of Users to an Array of Email Addresses Using Google Apps Script

Dynamic Binding of Checkboxes in Vuex

Guidelines for sending data as an array of objects in React

What is the reason behind Selenium's inability to locate XUL buttons?

Display information from an array in checkboxes. If the same data appears in another array, the corresponding checkbox in React will be automatically checked

Discovering a way to capture the space bar event in a number input field with JavaScript

Switch the placement of two DIV elements by their corresponding IDs