servlet and database

[supriya lal]

The "res" is not becoming more than zero and hence the else block in servlet is executing.The database is not getting updated.Please help

[u]SERVLET[/u]

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class addproductservlet extends HttpServlet {

    
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        List msg=new LinkedList();
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        HttpSession session= request.getSession();
        String userid=(String)session.getAttribute("user");
        String prodname=request.getParameter("product");
        int price=Integer.parseInt(request.getParameter("price"));
        int quantity=Integer.parseInt(request.getParameter("quantity"));
        
        
        addproductmodel ob=new addproductmodel();
        int res=0;
        try {
           res= ob.addproduct(userid,prodname,price);
           out.println("after res");
        } catch (SQLException ex) {
            out.println("error");
        }
        if(res>0)
        {
        
           msg.add("product is added successfully");
            request.setAttribute("msg", msg);
                    RequestDispatcher view= request.getRequestDispatcher("product.jsp");
        view.forward(request,response); 
        }
        else
        {
            msg.add("error in adding product");
            request.setAttribute("msg", msg);
            RequestDispatcher view= request.getRequestDispatcher("product.jsp");
        view.forward(request,response);
        }
        
        
    }

}


[u]model[/u]


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class addproductmodel {
    
    int addproduct(String userid, String prodname, int price) throws SQLException
    {
       int r=0;
     
          
           String url = "jdbc:db2://localhost:50000/MYEMANDI:" +
  "user=db2admin;password=p@ssw0rd;";
       try{
    Class.forName("com.ibm.db2.jcc.DB2Driver");
       }
       catch(Exception e)
   { e.printStackTrace();}
      
   try{ Connection cn = DriverManager.getConnection(url);
    
      
      
          PreparedStatement stmt=cn.prepareStatement("insert into product values(?,?,?)");
          stmt.setString(1,userid );
          stmt.setString(2, prodname);
          stmt.setInt(3, price);
          r=stmt.executeUpdate();
   }
   catch(Exception e)
   {System.out.println("error in catch");}
      
       
       return r;
       
     }}
    
    
    
    

[Swastik Dey]

Are you getting any exception?

[Prabhakar Reddy Bokka]

Looks like there is an issue with the JDBC code. Test your JDBC code with a simple java class and then try this...