Ad:

JSP Discussion Thread
Unsolved
Views: 2409

Jun 7th, 2009

I can't insert data into database

Expand Post »

Hi I have a difficulty in insertion data. I don't get any error message but it doesn't insert data to database. My code is below. Where am I wrong?

JSP Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <HR noshade size="5" width="50%" align="center">                
    <title>ZONE</title>
    </head>
    <body bgcolor="Silver">
 
    <%@ page language="java" import = "java.sql.*,java.util.*,java.text.*,java.io.*" %>
   <CENTER>
    <h4><font size="4" face="Verdana">ZONE MASTER</font> </h4>
    <BR></BR>
    <h4><font size="2" face="Verdana">ZONE CODE <input type="text" name="ZONE_CODE" value="" width="06" /> </h4></font>
    <h4><font size="2" face="Verdana">ZONE NAME <input type="text" name="ZONE_NAME" value="" width="06" /> </h4></font>
    </CENTER>
 
 
    <%
 
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
    Connection con = DriverManager.getConnection("jdbc:odbc:oraclexe","hr","hr");
 
    String zone_code=request.getParameter("ZONE_CODE");
    String zone_name=request.getParameter("ZONE_NAME");
 
    if(request.getParameter("INSERT") != null) {
             try{
     String ins=  "insert into ni_zone_master (zone_code,zone_name  ) values ('"+zone_code+"', '"+zone_name+"')";
 
            PreparedStatement st1 = con.prepareStatement(ins);
	  st1.executeUpdate();
 
           con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
    }
    if(request.getParameter("UPDATE") != null) {
               try{
     String ins=  "UPDATE ni_zone_master SET zone_code = '"+zone_code+"', zone_name = '"+zone_name+"' WHERE zone_code = '"+zone_code+"' AND zone_name = '"+zone_name+"' ";
 
           PreparedStatement st1 = con.prepareStatement(ins);
	  st1.executeUpdate();
 
 
		con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
    }
    if(request.getParameter("DELETE") != null)
               try{
     String ins =  "DELETE FROM ni_zone_master WHERE zone_code = '"+zone_code+"' AND zone_name = '"+zone_name+"'";
 
           PreparedStatement st1 = con.prepareStatement(ins);
             st1.executeUpdate();
              con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
 
    %>
 
     <CENTER>
    <form name="INSERT" method="POST">
    <input type="submit" value="ADD" name="ADD" onclick="InsertZoneInfo()"/></form>
    <form name="CHANGE" method="POST">   
    <input type="submit" value="UPDATE" name="UPDATE" onclick="UpdateZoneInfo()"/></form>
    <form name="DELETE" method="POST">   
    <input type="submit" value="DELETE" name="DELETE" onclick="DeleteZoneInfo()"/></form>
    </CENTER>
    </body>
    <HR noshade size="5" width="50%" align="center">   
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <HR noshade size="5" width="50%" align="center">                
    <title>ZONE</title>
    </head>
    <body bgcolor="Silver">
    
    <%@ page language="java" import = "java.sql.*,java.util.*,java.text.*,java.io.*" %>
   <CENTER>
    <h4><font size="4" face="Verdana">ZONE MASTER</font> </h4>
    <BR></BR>
    <h4><font size="2" face="Verdana">ZONE CODE <input type="text" name="ZONE_CODE" value="" width="06" /> </h4></font>
    <h4><font size="2" face="Verdana">ZONE NAME <input type="text" name="ZONE_NAME" value="" width="06" /> </h4></font>
    </CENTER>
    
    
    <%
                  
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
    Connection con = DriverManager.getConnection("jdbc:odbc:oraclexe","hr","hr");
      
    String zone_code=request.getParameter("ZONE_CODE");
    String zone_name=request.getParameter("ZONE_NAME");
    
    if(request.getParameter("INSERT") != null) {
             try{
     String ins=  "insert into ni_zone_master (zone_code,zone_name  ) values ('"+zone_code+"', '"+zone_name+"')";
  
            PreparedStatement st1 = con.prepareStatement(ins);
	  st1.executeUpdate();
            
           con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
    }
    if(request.getParameter("UPDATE") != null) {
               try{
     String ins=  "UPDATE ni_zone_master SET zone_code = '"+zone_code+"', zone_name = '"+zone_name+"' WHERE zone_code = '"+zone_code+"' AND zone_name = '"+zone_name+"' ";
  
           PreparedStatement st1 = con.prepareStatement(ins);
	  st1.executeUpdate();
      
          	
		con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
    }
    if(request.getParameter("DELETE") != null)
               try{
     String ins =  "DELETE FROM ni_zone_master WHERE zone_code = '"+zone_code+"' AND zone_name = '"+zone_name+"'";
  
           PreparedStatement st1 = con.prepareStatement(ins);
             st1.executeUpdate();
              con.close();
         }
         catch(SQLException sqle)
        {
		out.println("ERROR IN PAGE"+sqle);
        }   
   
    %>
   
     <CENTER>
    <form name="INSERT" method="POST">
    <input type="submit" value="ADD" name="ADD" onclick="InsertZoneInfo()"/></form>
    <form name="CHANGE" method="POST">   
    <input type="submit" value="UPDATE" name="UPDATE" onclick="UpdateZoneInfo()"/></form>
    <form name="DELETE" method="POST">   
    <input type="submit" value="DELETE" name="DELETE" onclick="DeleteZoneInfo()"/></form>
    </CENTER>
    </body>
    <HR noshade size="5" width="50%" align="center">   
</html>

Last edited by Tekmaven; Jun 7th, 2009 at 10:03 pm. Reason: Code Tags

Similar Threads

insert and update data in two different database in JSP
How to insert data into database? in JSP
source code to insert data into database using javabean in Java
inser data into database in JSP
how to insert data into the database in vb.net using textfields. in VB.NET

vandana88

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 7th, 2009

-1

Re: I can't insert data into database

You posted in wrong section, check out our Web Development for JSP section (I already made request for post to be moved)
Also in mean time you can have look at this post JSP database connectivity according to Model View Controller (MVC) Model 2

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 871

Code tags enforcer

Online

6,654 posts
since Dec 2004

Permalink

Jun 9th, 2009

Re: I can't insert data into database

i'm so sorry as i was very new to this community and now what should i do shall i remove this thread and paste it somewhere else?
and plz do solve my problem. Is my code correct or i should do any modifications?It's very urgent......thanks in advance

vandana88

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 10th, 2009

Re: I can't insert data into database

Well syntactically your JSP page is correct, although the approach of firing queries directly from inside the JSP page (that too using SQL Statements constructed on the fly) is not only bad but dangerous.

Also you need some brushing up on your concepts of HTML and Javascript. The <input> tags need to be nested inside a corresponding <form> tag, if you want the data from the <input> tag to be posted to the JSP page mentioned in the "action" attribute of <form> tag.
Also I do not see any Javascript functions by the name of InsertZoneInfo(),UpdateZoneInfo() or DeleteZoneInfo()

If you are using Firefox you could go to Tools ->Error Console to see the various Javascript errors or alternatively you could install the Firebug extension for more comprehensive debugging info.
Anyways the situation as I see demands that you learn not only about JSP and MVC[1,2,3] but also about HTML and JavaScript right now.

Last edited by stephen84s; Jun 10th, 2009 at 3:30 am.

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

Permalink

Jun 29th, 2009

Re: I can't insert data into database

double check on database schema and tables and columns

are they exactly what you have in the code?

CoSIS1

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

22 posts
since Jun 2009

Permalink

Jul 2nd, 2009

Re: I can't insert data into database

You can make two changes:
1: from oracle database homepage login as administrator then unlock the hr (may be it work)
2: try this url: to Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");
hope this will works.........

bye

Last edited by peter_budo; Jul 2nd, 2009 at 9:17 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

irfannagaria

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: Error: Requested resource not available for Servlet

Next Thread in JSP Forum Timeline: oracle session in jsp pages

DaniWeb Message

Cancel Changes

User Name
Password