Struts JDBC inserting data

Greenhorn

Posts: 6

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Im Inserting data to the database, their is no error but when im inserting the data in database theirs no data inserted

my struts config

my index.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html:html xhtml="true">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Add new user</title>
</head>
<body>

<html:form action="/User" method="POST">
        
        
        
        User ID :  
        <input type="text" name="userid" readonly="readonly" maxlength="16" />

First Name :  
        <html:text property="firstName" size="16" maxlength="16"/>
		<html:errors property="firstname"/>

Last Name : <input
            <html:text property="lastName" size="16" maxlength="16"/>

DOB : <input
          <html:text property="dob" size="16" maxlength="16"/>

Email : 
        <html:text property="email" size="16" maxlength="16"/>
        
        
<input
            type="submit" value="Submit" />
    </html:form>
</body>
</html:html>

success.jsp

Model

package com.daniel.model;

public class User {

private int userid;
    private String firstName;
    private String lastName;
    private String dob;
    private String email;
    public int getUserid() {
        return userid;
    }
    public void setUserid(int userid) {
        this.userid = userid;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public String getDob() {
        return dob;
    }
    public void setDob(String dob) {
        this.dob = dob;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    @Override
    public String toString() {
        return "User [userid=" + userid + ", firstName=" + firstName
                + ", lastName=" + lastName + ", dob=" + dob + ", email="
                + email + "]";
    }    
}

UserDao

package com.strutsexample.dao;

import com.strutsexamplel.connection.ConnectionFactory;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.daniel.model.User;
import com.myapp.struts.UserForm;

public class UserDao {

private Connection connection;
    public UserDao() throws ClassNotFoundException, SQLException {
        connection = ConnectionFactory.getConnection();
    }

public void addUser(User user) {
        try {
            PreparedStatement preparedStatement = connection
                    .prepareStatement("insert into users(firstname,lastname,dob,email) values (?, ?, ?, ? )");
            // Parameters start with 1
            preparedStatement.setString(1, user.getFirstName());
            preparedStatement.setString(2, user.getLastName());
            preparedStatement.setString(3, user.getDob());
            preparedStatement.setString(4, user.getEmail());
            preparedStatement.executeUpdate();

} catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

ConnectionFactory

UserForm

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.myapp.struts;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

/**
 *
 * @author ron
 */
public class UserForm extends org.apache.struts.action.ActionForm {
    
      private int userid;
    private String firstName;
    private String lastName;
    private String dob;
    private String email;
    public int getUserid() {
        return userid;
    }
    public void setUserid(int userid) {
        this.userid = userid;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public String getDob() {
        return dob;
    }
    public void setDob(String dob) {
        this.dob = dob;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    @Override
    public String toString() {
        return "User [userid=" + userid + ", firstName=" + firstName
                + ", lastName=" + lastName + ", dob=" + dob + ", email="
                + email + "]";
    }

/**
     *
     */
    public UserForm() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
     * This is the action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param request The HTTP Request we are processing.
     * @return
     */
    public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {
        ActionErrors errors = new ActionErrors();
        
         if (firstName == null || firstName.trim().equals("")) 
        {
            errors.add("firstName", new ActionMessage("error.cust.firstname.empty"));
        }
        
        return errors;
    }
}

UserAction

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.myapp.struts;

import com.daniel.model.User;
import com.strutsexample.dao.UserDao;
import java.io.PrintWriter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

/**
 *
 * @author ron
 */
public class UserAction extends org.apache.struts.action.Action {

/* forward name="success" path="" */
    private static final String SUCCESS = "success";

/**
     * This is the action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     * @throws java.lang.Exception
     * @return
     */
    @Override
    public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
            UserForm myUserForm = (UserForm) form; 
            UserDao dao = new UserDao();
        
        
            User user = new User();
            
            if (myUserForm != null) {
            user.setFirstName(myUserForm.getFirstName());
            user.setLastName(myUserForm.getLastName());
            user.setDob(myUserForm.getDob());
            user.setEmail(myUserForm.getEmail());
            dao.addUser(user);
            
            return mapping.findForward(SUCCESS);
            }
            
            return null;
            
    }
}

needs help thanks in advance