SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Feb 2006
    Posts
    299
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help me on this servlets for inserting data in the mysql database

    Hello Everyone,
    May someone help me with servlet for inserting records in mysql table. It is giving me some error saying that some column data has been tracanted.
    second how can I change String variable into int variable. The code is below

    Code:
    import javax.servlet.*;
    import javax.servlet.http.*;
    import java.io.*; 
    import java.sql.*;
     
     public class Addendangeredspecie extends HttpServlet {   
     
        // process "get" requests from clients
        protected void doPost( HttpServletRequest request, 
           HttpServletResponse response )
              throws ServletException, IOException 
         {
            response.setContentType( "text/html" );
            PrintWriter out = response.getWriter();  
             String tname=request.getParameter("Name");
             String tlocation=request.getParameter("Location");
             String tlocationdescrip=request.getParameter("Location_Description");
             String ttype=request.getParameter("Specie_Type");
             String tnumber=request.getParameter("Number_of_species");
             String tapproved=request.getParameter("approved");
             String tdateofsub=request.getParameter("Date_of_Submitting");  
             String tdateofsighting=request.getParameter("Date_of_sighting");       
             String tweight=request.getParameter("Weight");
             int nuke;
             nuke=2;
             //variables to do with  endangered animals
             String tnumberlegs=request.getParameter("Name_of_legs");
             String ttypeanimals=request.getParameter("Type_of_Animal");
             
              //variables to do with endangered plants
              
             String tplanttype=request.getParameter("Type_of_plant");
             String tseasontype=request.getParameter("Season");
             
             
             // send XHTML page to client
             try{
            
          DAO con=new DAO();
          //Getting a connection
          Connection myconn=con.getConnection();
          //create a statement
          Statement stmt =myconn.createStatement();
          String insertQuery="Insert into endangeredspecies (Name,Location,LocationDescription,Type,Number,Approved,DateofSubmitting,Dateofsighting) values ('"+tname+"','"+tlocation+"','"+tlocationdescrip+"','"+ttype+"','"+nuke+"','"+tapproved+"','"+tdateofsub+"','"+tdateofsighting+"')";
          String selectQuery="Select * from endangeredspecies";
          //String insertQuery2="Insert into animal (Idspices ,NumberLegs,TypeAnimals) values ('"+nuke+"','"+tnumberlegs+"','"+ttypeanimals+"')";
          //String insertQuery3="Insert into plant (Idspices ,PlantType,TypeSeasonal) values ('"+nuke+"','"+tplanttype+"','"+tseasontype+"')";
          
          int insertStatus=stmt.executeUpdate(insertQuery);
          ResultSet myresults=stmt.executeQuery(selectQuery);
          
             // start XHTML document
            out.println( "<?xml version = \"1.0\"?>" );
       
             out.println( "<!DOCTYPE html PUBLIC \"-//W3C//DTD " +
                "XHTML 1.0 Strict//EN\" \"http://www.w3.org" +
              "/TR/xhtml1/DTD/xhtml1-strict.dtd\">" ); 
     
            out.println( 
               "<html xmlns = \"http://www.w3.org/1999/xhtml\">" );
            
            // head section of document
            out.println( "<head>" );
             out.println( "<title> Endangered Species Database </title>" );
            out.println( "</head>" );
    // body section of document
             out.println( "<body align=\"center\">" );
             out.println( "<h2> You have successfully  added the record</h2>" );
             out.println( "<p></p>" );
             out.println( "Details submitted for "+tname+" "+ttype);
    		 if(insertStatus>0)
    		 out.println("<h3>Information has been add</h3>");
    		 else
    		 out.println("Your info has been update");
    		 out.println("<table>");
    		 while(myresults.next()){
    		 	out.println("<tr><td>"+myresults.getString(1)+"</td></tr>");
    		 }
    		 out.println("</table>");
    
             out.println( "</body>" );
             
             // end XHTML document
             out.println( "</html>" );
             out.close();
             
             myconn.close();
             }
            catch(Exception ex) {
            	System.out.println("Error"+ex.getMessage());// close stream to complete the page
          }  
          } 
       }

  2. #2
    SitePoint Evangelist borna's Avatar
    Join Date
    Jun 2006
    Location
    Iran, Tehran
    Posts
    475
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    First truncated data means you should set the required length at your database for each field. Do check them with your input page.

    For
    how can I change String variable into int variable
    it is easy, just
    Code:
    int xx= Integer.parseInt(STRING_X);
    -1/2=999?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •