what is the wrong in my code?why the radio options do not appear?

Hi
what is the wrong in my code?why the radio options do not appear?
I checked the value and it is correct,so why the values do not appear in options

(see the radio options in the code)
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*,java.io.*,java.util.*,org.apache.*,java.io.File,java.lang.*"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 
--%>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
 
<html>
    
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
 
    <h1></h1>
     <form method="POST" action="accept.jsp"  >
      <table align="center" border="3" title="requested Software">
            <tr >
                <td></td>  <td width="200" bgcolor="#B3104D">Software name</td> <td width="300" bgcolor="#B3104D">Software description</td>
            </tr>
   
      
            <% 
            HttpSession s = request.getSession();
            try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection(
            "jdbc:odbc:NN_project","sa","nnproject");
            
            
            int i=0;
            
            String str= null;
            
            Statement stmt = conn.createStatement();
            String sql = "SELECT * FROM soft_temp  ";
            ResultSet rs = stmt.executeQuery(sql);
            //ar=rs.getArray("NN_type_name");
            
            
            while(rs.next())
            {
           
            %>
            <tr>
                    <td> <input type="radio" name="software" value="<%= rs.getString("software_name")%>" /> </td>
                    
                            <td>
                               
                           <%= rs.getString("software_name")%> 
                            
               </td>
                            
            </tr>
            <% out.println("\n");%>
            <%           
            } 
            stmt.close();
            } catch (Exception ex) {
            ex.printStackTrace();}
           
            %> 
        </table>
    
        <input type="submit" value="Accept" />
        <input type="button" value="Reject" align="center" onclick="top.location='reject.jsp'"/>
      
    </form>
   
    </body>
</html>

Open in new window

master_programmerAsked:
Who is Participating?
 
mrcoffee365Connect With a Mentor Commented:
You get the same field twice with rs.getString.  The second time, it doesn't exist.  You should have a SQLException in your logs -- if you check, it will tell you the line number of your file which has the problem.

Change your code to something like this:
  String myVar = rs.getString("software_name");

and use <%=myVar%> for the HTML values.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.