Forum:

JDBC and Relational Databases

A servlet code written to add details in database but not happening?

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

/*
 * prepared_statement_query.java
 *
 * Created on June 15, 2011, 7:04 PM
 */

import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Administrator
 * @version
 */
public class prepared_statement_query extends HttpServlet {
    
    /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        
        
        try
  { 
        
         String U_name = request.getParameter("name").trim();
   String password = request.getParameter("password").trim();
   String Full_Name = request.getParameter("Full_Name").trim();
   String Login_Type=request.getParameter("Login_Type").trim();
   String EmailID=request.getParameter("Email-ID").trim();
   
    out.println("<html>");
        out.println("<head>");
        out.println("<title>Servlet prepared_statement_query</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("U_name:" +U_name);
        out.println("</body>");
        out.println("</html>");
  
      
     Connection  con=DriverManager.getConnection("jdbc:odbc:VirtualClassRoom","","");
      PreparedStatement stat;
     String str="insert into customer values(?,?,?,?,?,?)";
      stat=con.prepareStatement(str);
     stat.setString(1,U_name);
      stat.setString(2,password);
      stat.setString(3,Full_Name);
      stat.setString(4,Login_Type);
      
      if(Login_Type=="Analyst")
      stat.setInt(5,0);
      if(Login_Type=="Student")
          stat.setInt(5,1);
          stat.setString(6,EmailID);
          int numRowsChanged=stat.executeUpdate();
         
          con.close();
}
        catch(SQLException e){System.out.println(e.getMessage());}
  catch(Exception e){System.out.println(e.getMessage());}
    }
    
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Returns a short description of the servlet.
     */
    public String getServletInfo() {
        return "Short description";
    }
    // </editor-fold>
}

is there something wrong in this code??? I am not able to see it out

http://www.lifesbizzare.blogspot.com || OCJP:81%

Bear Bibeault

Sheriff

Posts: 67754

173

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

TellTheDetails

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Bear,

I have a Jsp page having add hyperlink.Once clicked it redirects to a JSP page where i input name email address and all and once clicked on submit button the form action attribute is set to go to prepared_statement_query servlet to add the values in the database...

I was hoping that select statement in SQL query will display new values i inputted in the jsp page.but no luck the table remains the same and is not added with any new information

http://www.lifesbizzare.blogspot.com || OCJP:81%

Anshuman Chakraborty

Greenhorn

Posts: 20

posted 13 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Did you check Container's log file.

Suggestion :
Try printing the values you receive from JSP.

Anshuman Chakraborty

reddy ajay

Greenhorn

Posts: 8

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Vishal Hegde wrote:Hi Bear,

I have a Jsp page having add hyperlink.Once clicked it redirects to a JSP page where i input name email address and all and once clicked on submit button the form action attribute is set to go to prepared_statement_query servlet to add the values in the database...

I was hoping that select statement in SQL query will display new values i inputted in the jsp page.but no luck the table remains the same and is not added with any new information

did you create the database in mysql and the table,
if you did not the you need to do that first.
Also debug it using debugger and see what is happening
is it running fine or is it raising some exception.
let me know

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

reddy ajay wrote:

Vishal Hegde wrote:Hi Bear,

I have a Jsp page having add hyperlink.Once clicked it redirects to a JSP page where i input name email address and all and once clicked on submit button the form action attribute is set to go to prepared_statement_query servlet to add the values in the database...

I was hoping that select statement in SQL query will display new values i inputted in the jsp page.but no luck the table remains the same and is not added with any new information

did you create the database in mysql and the table,
if you did not the you need to do that first.
Also debug it using debugger and see what is happening
is it running fine or is it raising some exception.
let me know

Hi Ajay,

Offcourse i Created the table did you read the code for connecting my database to the table?

http://www.lifesbizzare.blogspot.com || OCJP:81%

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Anshuman Chakraborty wrote:Hi,

Did you check Container's log file.

Suggestion :
Try printing the values you receive from JSP.

Where do i check the Log files??? Yes i did tried printing those those are successfully done

http://www.lifesbizzare.blogspot.com || OCJP:81%

Dieter Quickfend

Bartender

Posts: 543

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Try loading the JDBC driver.

Oracle Certified Professional: Java SE 6 Programmer && Oracle Certified Expert: (JEE 6 Web Component Developer && JEE 6 EJB Developer)

James Sabre

Ranch Hand

Posts: 781

I like...

posted 13 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Vishal Hegde wrote:
Offcourse i Created the table did you read the code for connecting my database to the table?

There is no 'of course' about it. Nothing in the code you posted creates the database or the table 'customer' or sets up the data source 'VirtualClassRoom' linking JDBC with ODBC.

There are some other weaknesses -

1) you are relying on a particular table column order which is not a good idea; you should specify the column names when using an insert.
2) your exception handling is very very poor.
3) there is no explicit commit() and there is no indication as to whether or not you are using auto-commit (I have not use the JDBC-ODBC bridge for a long time and I can't remember whether or not auto-commit matters).

As has been said - find the log files and see what they say.

Retired horse trader.
Note: double-underline links may be advertisements automatically added by this site and are probably not endorsed by me.

Deepakkumar Devarajan

Ranch Hand

Posts: 54

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Vishal,
Load the JDBC driver first before coonnecting to database. You should have got "No suitable driver" as error message since you have not loaded the driver.

Regards,
Deepakkumar Devarajan

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

James Sabre wrote:

Vishal Hegde wrote:
Offcourse i Created the table did you read the code for connecting my database to the table?

There is no 'of course' about it. Nothing in the code you posted creates the database or the table 'customer' or sets up the data source 'VirtualClassRoom' linking JDBC with ODBC.

There are some other weaknesses -

1) you are relying on a particular table column order which is not a good idea; you should specify the column names when using an insert.
2) your exception handling is very very poor.
3) there is no explicit commit() and there is no indication as to whether or not you are using auto-commit (I have not use the JDBC-ODBC bridge for a long time and I can't remember whether or not auto-commit matters).

As has been said - find the log files and see what they say.

Hi James,

I have created a Customer table using select statment in MS -SQL did database connectivity going to control panel->Administratitve tools-->DataSourcesODBC) And added a user DSN named "VirtualClassRoom"

Also created a VirtualClassRoom database in MSSQL and added a table customer on it added one column to test for login authentication and its working fine... and now for insertin the value i am facing this problem

http://www.lifesbizzare.blogspot.com || OCJP:81%

James Sabre

Ranch Hand

Posts: 781

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Vishal Hegde wrote:
I have created a Customer table using select statment in MS -SQL did database connectivity going to control panel->Administratitve tools-->DataSourcesODBC) And added a user DSN named "VirtualClassRoom"

Also created a VirtualClassRoom database in MSSQL and added a table customer on it added one column to test for login authentication and its working fine... and now for insertin the value i am facing this problem

Since it's not obvious to me from the above that you did, did you add columns for user name, password, full name and login type etc? Also, did you check the servlet logs to see what they say? The logs should tell you exactly what the problem is.

Retired horse trader.
Note: double-underline links may be advertisements automatically added by this site and are probably not endorsed by me.

Vishal Hegde

Ranch Hand

Posts: 1087

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

James Sabre wrote:

Vishal Hegde wrote:
I have created a Customer table using select statment in MS -SQL did database connectivity going to control panel->Administratitve tools-->DataSourcesODBC) And added a user DSN named "VirtualClassRoom"

Also created a VirtualClassRoom database in MSSQL and added a table customer on it added one column to test for login authentication and its working fine... and now for insertin the value i am facing this problem

Since it's not obvious to me from the above that you did, did you add columns for user name, password, full name and login type etc? Also, did you check the servlet logs to see what they say? The logs should tell you exactly what the problem is.

Yes i did those ,where should i check the logs? I am using netbeans?

http://www.lifesbizzare.blogspot.com || OCJP:81%

James Sabre

Ranch Hand

Posts: 781

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Google is wonderful - http://blogs.oracle.com/NetBeansSupport/entry/tomcat_log_files

Retired horse trader.
Note: double-underline links may be advertisements automatically added by this site and are probably not endorsed by me.

Consider Paul's rocket mass heater.