Need help in sevlet and jsp project

Question

0.00/5 (No votes)

See more:

In this a voter will first login and then a jsp page will be displayed in front of him which will display the names of all candidates after retrieving it from database.When the voter will select one candidate name and click the submit button it shoul be redirected to a servlet whose work is to increade the no_of_votes of that particular candidate and save it into the database and make the boolean value true into the database which will indicate that the voter has voted and cant vote again.so I have written the jsp and servlet codes n attaching here..but its not working..please help me and tell me what is the error here.

jsp code

ASP.NET

<%@ page import="p1.*" session="true"%>

<html>
<head>
<title>My Page</title>
</head>
<body BGCOLOR="GREEN">

<H1><center>CAST      YOUR      VOTE</CENTER></H1>
<div align="center">
<form action="#">
<%
String cname="";
String cid="";
try{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con = DriverManager.getConnection("jdbc:odbc:zeal");
      PreparedStatement ps = con.prepareStatement("select c_name,id from candidate");
      ResultSet rs=ps.executeQuery();
%>
<table>
<th>
<td>CANDIDATES NAME</td>
<td>VOTE</td>
</th>
<%
while(rs.next())
{
cname=rs.getString(1);
cid=rs.getString(2);
 out.print("<tr><td>"+cname+"</td></tr>"+"<tr><td>"+"<input type="radio" name="group1" value="cid">"+"</tr></td>");
}
}
catch(Exception e)
{
}
%>
<input type="submit" name="submit">
</div>

</form>
</body>
</html>

Servlet Code

Java

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class CastVote extends HttpServlet{
  public void doGet(HttpServletRequest request,HttpServleResponse response)throws ServletException,IOException
{
                      cid=request.getParameter("id");
                      vid=request.getParameter("uid");
}	
               try
{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	 Connection con = DriverManager.getConnection("jdbc:odbc:zeal");
             PreparedStatement ps=con.prepareStatement("update candidate set no_of_votes=no_of_votes+1 where id="cid");
          ResultSet rs=ps.executeUpdate();
con.close();
}
catch(Exception e)
{ 
}
}

Posted 2-Apr-12 20:25pm

Monika Rai 16

Updated 2-Apr-12 20:30pm

Prasad_Kulkarni

v2

Add a Solution

Comments

Darkness_07 18-May-12 6:35am

I don't know if you forgot to put a SERVLETNAME in your form action

leejoyprakash 21-Sep-12 10:35am

Did you configure and test your ODBC DataSource ? Can you print and check whether any exception is raised in both servlet and JSP ?
catch(Exception e){ e.printStackTrace();} .

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)