Comparing value of radio button against answer from the database

Hi,

I am a novice and am trying to create a login page. The flow is:

1.User enters username and password.

2. He is then asked a question from database which has radio buttons

3. The selected value should be checked against a radio button selected to allow the user to login.

The login part is ok, have a problem getting the answer for the question, also the answer which I took as the hidden value is displayed

Code for Question.jsp

<%@ page language="java" contentType="text/html; charset=iso-8859-1"
    pageEncoding="iso-8859-1"%>
<!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd">
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.awt.*" %>

<%
	
	String connectionurl = "jdbc:mysql://localhost:3306/test";
	Connection connection=null;
	ResultSet rs;

try {
		 // load the database driver
		Class.forName("com.mysql.jdbc.driver");
		// get a connection to the database
		connection = Drivermanager.getconnection(connectionurl, "root", "root"); 
		//add the data into the database
		Random rand = new Random(); 
		int num = rand.nextint(4);
			Statement s = connection.createStatement();

rs=s.Executequery("select question,ans,option1,option2,option3,option4 from questions where qid="+num);
	
		while(rs.next()){%>
		
		
		
		
<html>
    <head>
        <title>question</title>
    </head>
 
    <body>
        <h2>answer the question to log-on</h2>
        <form action="welcome.jsp" method="post">
        
        <h4><%=rs.getString(1)%></h4>
            
        <br></br>
             <input type="radio" name="radios" value<%=rs.getString(3)%>>
             <%=rs.getString(3)%>
            <br>
            <input type="radio" name="radios" value<%=rs.getString(4)%>>
             <%=rs.getString(4)%>
            <br>
            <input type="radio" name="radios" value<%=rs.getString(5)%>>
             <%=rs.getString(5)%>
            <br>
            <input type="radio" name="radios" value<%=rs.getString(6)%>>
            <%=rs.getString(6)%>
                 <br>
            <input type="hidden" name="answer" value<%=rs.getString(2)%>>
            <br>
            <br>     
            <input type="submit" value="submit">
        </form>

</body>
</html>

<%}}

catch(Exception e){
		System.out.println(e.getMessage());
	}
%>

And the code for Welcome.jsp

I am exhausted searching for the errors, can someone please help me!!!

As a novice, it's important to not learn bad habits from the start: begin with removing all Java code from JSP pages. Java should be performed in servlet controllers and beans and has no place in a modern JSP.

Also, the use of all uppercase for HTML is a really old-fashioned convention that makes your code very hard to read. Use lowercase and it'll look a lot better.

OK, thanks for the advice,

Removed the capitalization, but cannot move the javacode out of the JSP right now, so please give it a look!

Have a deadline to meet.

Can some one please help!

first find the value of radio button with the code below and then compare it wid database....

<script language="JavaScript">

function getRadioValue() {
for (index=0; index < document.frmRadio.choice.length; index++) {
if (document.frmRadio.choice[index].checked) {
var radioValue = document.frmRadio.choice[index].value;
break;
}
}
}

</script>

Anudeep Pat wrote:OK, thanks for the advice,

Removed the capitalization, but cannot move the javacode out of the JSP right now, so please give it a look!

Have a deadline to meet.

Why not? It should be done the first thing to avoid further problems.

By the way you didn't tell us what your problem is.

Is Question.jsp compiling? This line seems not to be correct (well, this and all the inputs)

Everything is compiling but I guess there's a problem comparing the value of the radiobutton selected to the hidden value am sending in the answer field

Anudeep Pat wrote:I guess there's a problem comparing the value of the radiobutton selected to the hidden value am sending in the answer field

But guessing is not a very practical problem-solving method.

First of all here's what you should do to compare the value returned from the radio button against the answer from the database:

Get the value from the radio button into a variable

Get the value from the database into another variable

Compare the two values

If that doesn't work the way you think it should, then perhaps you're getting an unexpected value from the radio button. Or from the database. Don't guess, or assume, what is happening then. Display both values and see what you are dealing with. It's called "debugging".

See when you are actually submitting the form all the values are sent so will give you only the first value because its actaualy an array , try to take a print of this value ,what i suggest that instead of using submit use a normal button and onclick of that call your own function that will submit the form, here write java script code that only sends the selected value .And i dont think theres any problem with the answer field you will be getting that surely.

thanks a lot for the help!!

Hope it'll work!