Only Partial Data Returned from Database Using JSP Form

Question

I'm new to mysql and teaching myself the ropes. I've come across a problem and hoping for some advice.

I created a form in a jsp page to insert data to a mysql database. All data is properly inserted, and when I do select* all data is properly displayed in a table I created. My problem is with my update page.

When I call data from the database back into a form on my editdata.jsp page, only everything before a space is returned. For example, I put the name 'Tom Jones' into a database, but when I go to retrieve it from the name field, only 'Tom' is returned; 'Jones' is not, but is still there in the database.

Here's my editdata.jsp code:

<%@page import="java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>



    
    JSP Page


    
    


            <%ResultSet res = (ResultSet) request.getAttribute("EditData");%>
            <%if(res.next()){
                %>
                

            <%}%>            
    
                   ID
                   >   

                
                
                   Container Number 
                    >
                
                
                   Size 
                   > 
 
                
                
                   Vessel 
                   > 
 
                
                
                   Full Out Date 
                   > 
                
                   Empty In Date 
                   
 >
                
                
                   Empty Out Date 
                   > 
                
                
                   Full In Date 
                   > 

                
                
                   Comments 
                   >

And my EditRecord servlet:

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class EditRecord extends HttpServlet {

    Connection conn;
    ResultSet res;
    Statement stmt;
    String id, query;
    DatabaseConnection dbconn;


    protected void processRequest(HttpServletRequest request, HttpServletResponse  
    response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

            id = request.getParameter("id");
            dbconn = new DatabaseConnection();
            conn = dbconn.setConnection();
            stmt = conn.createStatement();
            query = "select * from inventory where id = "+id;
            res = dbconn.getResult(query, conn);


        }catch(Exception e){



        }
        finally {
            request.setAttribute("EditData", res);
            RequestDispatcher rd = request.getRequestDispatcher("editdata.jsp");
            rd.forward(request, response);
            out.close();
        }
    }


    /**
     * Handles the HTTP GET method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP POST method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// 

}

Again, the long and short of my problem is that full strings of data are not returned after spaces. So 'TOM JONES' only returns 'TOM' to the form above for editing. How do I get the full string of data to be returned. I don't know if it matters, but I used VARCHAR for all my record info.

Thanks for any and all help.

developerwjk · Accepted Answer

Attributes inside HTML tags are separated by spaces. That's why you're supposed to use quotes around the attribute values.

BAD:

GOOD:

" />

Only Partial Data Returned from Database Using JSP Form

Answers (1)

Related Questions