Forum:

Comparing value of radio button against answer from the database

Greenhorn

Posts: 10

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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!!!

Bear Bibeault

Sheriff

Posts: 67753

173

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Anudeep Pat

Greenhorn

Posts: 10

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Anudeep Pat

Greenhorn

Posts: 10

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Can some one please help!

praneel shah

Greenhorn

Posts: 17

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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>

Albareto McKenzie

Ranch Hand

Posts: 312

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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)

Anudeep Pat

Greenhorn

Posts: 10

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Paul Clapham

Sheriff

Posts: 28371

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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".

Java 8 (verified skill)
Skill verified by Paul Clapham

adil qureshi

Ranch Hand

Posts: 48

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

SCJP 1.5,SCWCD 1.5

Anudeep Pat

Greenhorn

Posts: 10

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks a lot for the help!!

Hope it'll work!

I'm not sure if I approve of this interruption. But this tiny ad checks out:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser