using java code inside javascipt-- in jsp
i am nt able to post d marks obtained by a student to the corresponding database. i have used javascript to handle the onsubmit event of the form, bt im nt able to retain the javascript's variable's value in my java code.
here z d code..
<script language="javascript">
function f11()
{
alert("entererddd");
var result=0;
x= document.f1;
if(x.r1[0].checked || x.r1[1].checked || x.r1[2].checked || x.r1[3].checked)
{
if(x.r1[0].checked)
{
alert("monkey");
result=result+1;
result1=result1+1;
alert(result1);
}
if(x.r1[1].checked)
{
alert(" dog ");
}
if(x.r1[2].checked)
{
msgbox("hello");
System.out.println("chekd here");
alert("donkey ");
}
if(x.r1[3].checked)
alert("cat ");
}
if(x.r2[0].checked || x.r2[2].checked || x.r2[3].checked || x.r2[1].checked)
{
alert("2nd entrd");
if(x.r2[0].checked)
{
alert("crab");
result=result+1;
result1=result1+1;
}
if(x.r2[1].checked)
alert("snake");
if(x.r2[2].checked)
alert("dog");
if(x.r2[3].checked)
alert("cockroach");
}
alert(result);
}
</script>
</head>
<BODY bgcolor="red">
<H1> <center>ONLINE MCQ EXAM</center></H1>
<H2> QUESTION1: </H2>
<b>NATIONAL ANIMAL:</b>
<form name="f1">
monkey:<input type="radio" name="r1" ><br>
DOG:<input type="radio" name="r1" ><br>
donkey:<input type="radio" name="r1"><br>
cat: <input type="radio" name="r1"><br><br>
<h2>Question2:</h2>
<h3> which of the following seems delicious to u:</h3>
crab:<input type="radio" name="r2" ><br>
snake:<input type="radio" name="r2" ><br>
dog:<input type="radio" name="r2"><br>
cockroach: <input type="radio" name="r2">
<br><br><br><br>
<center>
<input type="button" value="submit" name="b1" onclick="f11();">
</center>
</form>
<%@page import="java.sql.*" %>
<%
HttpSession s1= request.getSession();
Object o1=s1.getAttribute("Username");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String str=o1.toString();
Connection con= DriverManager.getConnection("jdbc:odbc:mydsn","hap py","happy");
Statement stmt= con.createStatement();
PreparedStatement pst= con.prepareStatement("update student set marks=? where name=?");
pst.setInt(1, result1);
pst.setString(2, str);
PreparedStatement ps1=con.prepareStatement("commit;");
</BODY>
</HTML>
