I have 3 forms and this is my last form contents. I do display all values correctly. Iam getting an error while this form getting displayed and the error is ";" expected. I have seen there is no error anywhere and it is storing below values in database before even i click "add user" button. i am not able to understand why this is happening.
When i traced the error .Iam getting unique constraint violated. But my values are getting stored. I guess it is trying to do twice. Let me know your ideas..
Thanks.
<form name="Form1" method="post" action="">
<%
String fname = (String) session.getAttribute("MySe
ssionfname
");
String lname = (String) session.getAttribute("MySe
ssioninlna
me");
String mname = (String) session.getAttribute("MySe
ssionmname
");
String ssn = (String) session.getAttribute("MySe
ssionssn")
;
String loginname=request.getParam
eter("logi
nname");
String password12=request.getPara
meter("pas
sword");
String email=request.getParameter
("email");
String previldge1= request.getParameter("prev
ildge");
String[] previldges= previldge1.split(";");
out.println("<center>");
out.println("<br>"+"<br>"+
"<br>");
out.println("YOU ARE ABOUT TO ADD A USER WITH FOLLOWING DETAILS.."+"<br>"+"<br>");
out.println("Firstname="+f
name+"<br>
");
out.println("Lastname="+ln
ame+"<br>"
);
out.println("MiddleName="+
mname+"<br
>");
out.println("SSN="+ssn+"<b
r>");
out.println("Loginname="+l
oginname+"
<br>");
out.println("Password="+pa
ssword12+"
<br>");
out.println("Email="+email
+"<br>");
out.println("<br>"+"<br>"+
"<br>");
out.println("NEED TO CHANGE?????"+"<br>");
out.println("CLICK BACK BUTTON....");
out.println("</center>");
%>
<p> </p>
<p align="center">
<input type="submit" name="Submit" value="Add User.." onClick="javascript:onadd(
);">
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</form>
<script language=javascript>
<!--
function onadd()
{
<%
String username = "scott";
String password = "tiger";
String url = "jdbc:odbc:grad_project";
try {
Class.forName("sun.jdbc.od
bc.JdbcOdb
cDriver");
//Loads driver
Connection con=DriverManager.getConne
ction(url,
username, password);
Statement stat1=con.createStatement(
);
String query1= "INSERT INTO users(userid,firstname,las
tname,midd
leinitial,
email,logi
n,password
)VALUES "+
"('"+ssn+"','"+fname+"','"
+lname+"',
'"+mname+"
','"+email
+"','"+log
inname+"',
'"+passwor
d12+"')";
stat1.executeUpdate(query1
);
String query2="";
Statement stat2=con.createStatement(
);
if(previldges.length>0)
{
for (int intCnt = 0;intCnt < previldges.length; intCnt ++)
{
query2= "INSERT INTO userspecify(userid,previld
ge)VALUES ('"+ssn+"','"+previldges[i
ntCnt ]+"')";
stat2.executeUpdate(query2
);
}
}
out.println("Successfully Inserted");
con.commit();
con.close();
}
catch(Exception e)
{
out.print(e);
}
%>
// -->
</script>
</body>
</html>