database connectivity

i m trying to connect this servlet with database but i m not able to Code is ot giving any error and there is no update in database plsss somebody can help code is here

package newpackage;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


@WebServlet(name = "exam", urlPatterns = {"/exam"})
public class exam extends HttpServlet {


    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
         response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
         Connection con = null;  
  PreparedStatement ps = null;
  ResultSet rs = null;
        String id = request.getParameter("id"); 

          out.print("id"+ id);
        String name=request.getParameter("name");

        try{
         out.print("statrted");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        out.print("loaded");
        con= DriverManager.getConnection("jdbc:odbc//localhost:3306/example","root","root");
         out.print("connected");
        ps= con.prepareStatement("insert into new values(?,?)");
      rs=ps.executeQuery();
       rs.first();
       { ps.setString(1,id);
        ps.setString(2,name);
        ps.executeUpdate();
       }
          out.print("executed");
        con.close();



        }

        catch (Exception e)

        {

        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }


    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);

            }


    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}

March 20, 2012 at 4:18 PM

Please visit the following links:

http://www.roseindia.net/jdbc/jdbcconnectivity.shtml

http://www.roseindia.net/servlets/

March 20, 2012 at 4:18 PM

Connect Servlet with database and insert data

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

public class InsertServlet extends HttpServlet { 
    public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
        res.setContentType("text/html");
        PrintWriter out = res.getWriter();
        String name=req.getParameter("name");
        String pass=req.getParameter("pass");
        String address=req.getParameter("address");
int no=Integer.parseInt(req.getParameter("no"));
String gender=req.getParameter("gender");
String country=req.getParameter("country");
try{
Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into mail(name,password,address,telno,gender,country) values('"+name+"','"+pass+"','"+address+"',"+no+",'"+gender+"','"+country+"')");
         out.println("Data is inserted successfully");
         con.close();
        }
catch(Exception e){
    System.out.println(e);
}
            }
        }