Solved

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

Posted on 2007-11-24
1
246 Views
Last Modified: 2010-04-01
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

0
Comment
Question by:master_programmer
1 Comment
 
LVL 26

Accepted Solution

by:
mrcoffee365 earned 500 total points
ID: 20344099
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

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now