how to get form parameters data to a servlet?

thejaka samarakoon

Ranch Hand

Posts: 56

posted 6 years ago

<tbody>
                    <tr>
                        <td>Name:</td>
                        <td colspan="5"><input type="text" name="name" value="" /></td>
                       
                    </tr>
                    <tr>
                        <td>Sex:</td>
                        <td colspan="2"><input type="radio" name="sex" value="M" checked="checked" />Male</td>
                        <td colspan="3"><input type="radio" name="sex" value="F" />Female</td>
                        
                    </tr>
                    <tr>
                        <td>Year:</td>
                        <td><select name="year">
                                <% for(int i=1960;i<2010;i++){ %>
                                <option>
                                    <%= i
                                         %>
                                </option>
                                <% } %>

</select></td>
                        <td>Month:</td>
                        <td><select name="month">
                                <% for(int i=1;i<13;i++){ %>
                                <option>
                                    <%= i
                                         %>
                                </option>
                                <% } %>

</select></td>
                        <td>Day:</td>
                        <td><select name="Day">
                                <% for(int i=1;i<32;i++){ %>
                                <option>
                                    <%= i
                                         %>
                                </option>
                                <% } %>

</select></td>
                    </tr>
                    <tr>
                        <td>Address:</td>
                        <td colspan="5"><input type="text" name="address" value="" size="100"
                    maxlength="100"                /></td>
                      
                    </tr>
                    <tr>
                        <td>Telephone:</td>
                        <td><input type="text" name="tel1" value="" size="4" maxlength="4" /></td>
                        <td colspan="4"><input type="text" name="tel2" value="" size="6" maxlength="6"/></td>
                       
                    </tr>
                    <tr>
                        <td colspan="3"><input type="submit" value="ok" name="" /></td>
                        <td colspan="3"><input type="submit" name="" value="Clear" /></td>
                       
                    </tr>

</tbody>
            </table>

</form>

</body>
</html>

1)how above form parameters like radio button data,drop down menu data can be transfered to the servlet(I mean can I get it using request.getparameter(); or any other way to get this data from the form to a servlet & then to display it ajsp page?

Devaka Cooray

Marshal

Posts: 5325

575

I like...

posted 6 years ago

thejaka samarakoon wrote:I mean can I get it using request.getparameter(); or any other way to get this data from the form to a servlet & then to display it ajsp page?

If an input has just one value (eg: radio button), you can simply get it using getParameter(). For getting multiple values (eg: check boxes), have a look at HttpServletRequest.getParameterValues(String).

Author of ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- OCPJP Online Training -- Home -- Twitter -- How to Ask a Question

thejaka samarakoon

Ranch Hand

Posts: 56

posted 6 years ago

Thanks Devaka Cooray ,i'll upload my AddServlet(below). Which is the one having the(Servlet) code for run the application with a created mysql database.but this code compiles successfully, but doesn't add values to the database(I created database correctly,can you help to solve this problem?

package src;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import util.JDBC;

/**
 *
 * @author Thejaka
 */
public class AddServlet extends HttpServlet {

@Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        String name=request.getParameter("name");
        String sex=request.getParameter("sex");
        String year=request.getParameter("year");
        String month=request.getParameter("month");
        String day=request.getParameter("day");
        String address=request.getParameter("address");
        String tel1=request.getParameter("tel1");
        String tel2=request.getParameter("tel2");

Connection con=JDBC.getConnection();
        String sql="INSERT INTO contacts VALUES('" + name +"','" +sex + "','" +
                year + "','" + month +"','" +day +"','"+address + "','" + tel1 +"','" +tel2 +"')";

try{
        Statement stmt=con.createStatement();
        stmt.execute(sql);
    } catch(SQLException ex){
    ex.printStackTrace();

}
response.sendRedirect("success.jsp") ;
    }

}

Devaka Cooray

Marshal

Posts: 5325

575

I like...

posted 6 years ago

Have you checked the server log for the problem cause? What has happened should have logged down there.

Beside your database problem, pay attention on....

- Invoking JDBC codes directly from your servlet class is not a good practice. You should have separate classes for database access.
- Storing the inputs without having proper validations is inherently insecure and prone to SQL injection attacks.

Author of ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- OCPJP Online Training -- Home -- Twitter -- How to Ask a Question