Alejandros Aguiler

Hello!!!

I have this web project based on Spring Hibernate crud operations but the problem is that after adding some new users , in the next page as list of users. appers a 404 page and the data is not saved in the mysql
I have the jboss as 7.1 final and I have to use the seam jars. I dont know if I miss some jars or I have an error in the java and xml
i need help please.

thanks

Another question, this topic is fine here because I'm using jboss or I have to change it to the Spring forum




I know that ModelandView and the public String method have the same function , right??
so maybe that is not the error right??


import java.util.HashMap; import java.util.Map; import org.lanaizen.entity.User; import org.lanaizen.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.servlet.ModelAndView; @Controller @RequestMapping("/users") public class UserController { @Autowired private UserService userService; @RequestMapping(value="/save", method=RequestMethod.POST) public ModelAndView saveUser(@ModelAttribute("user") User user, BindingResult result) { userService.addUser(user); return new ModelAndView("redirect:/users.html"); } @RequestMapping(method=RequestMethod.GET) public ModelAndView listUsers(){ Map<String, Object> model=new HashMap<String, Object>(); model.put("users", userService.listOfAllUsers()); return new ModelAndView("usersList", model); } @RequestMapping(value="/add", method=RequestMethod.GET) public ModelAndView addUser(@ModelAttribute("user") User user, BindingResult result) { return new ModelAndView("addUser"); } @RequestMapping(value="/delete/{id}") public String deleteUser(@PathVariable("id") Integer id){ userService.deleteUser(id); return "redirect:/users"; } }

import java.util.List; import org.lanaizen.entity.User; public interface UserDAO { public void addUser(User user); public List<User> listOfAllUsers(); public void deleteUser(int id); }

import java.util.List; import org.hibernate.SessionFactory; import org.lanaizen.entity.User; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; @Repository("userDAO") public class UserDAOImpl implements UserDAO { @Autowired private SessionFactory sessionFactory; public void addUser(User user) { sessionFactory.getCurrentSession().saveOrUpdate(user); } @SuppressWarnings("unchecked") public List<User> listOfAllUsers() { return (List<User>) sessionFactory.getCurrentSession().createCriteria(User.class).list(); } public void deleteUser(int id) { User user =(User) sessionFactory.getCurrentSession().load(User.class, id); if(null!=user){ sessionFactory.getCurrentSession().delete(user); } } }

import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="USER") public class User { @Id @GeneratedValue @Column(name="ID") private int id; @Column(name="NAME") private String name; @Column(name="LASTNAME") private String lastName; @Column(name="ADDRESS") private String address; @Column(name="AGE") private int age; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getLastName() { return lastName; } public void setLastName(String lastName) { this.lastName = lastName; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } }

import java.util.List; import org.lanaizen.entity.User; public interface UserService { public void addUser( User user); public List<User> listOfAllUsers(); public void deleteUser(int id); }

import java.util.List; import org.lanaizen.dao.UserDAO; import org.lanaizen.entity.User; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; @Service("userService") @Transactional(propagation=Propagation.SUPPORTS, readOnly=true) public class UserServiceImpl implements UserService { @Autowired private UserDAO userdao; @Transactional(propagation=Propagation.REQUIRED, readOnly=false) public void addUser(User user) { userdao.addUser(user); } @Transactional public List<User> listOfAllUsers() { return userdao.listOfAllUsers(); } @Transactional public void deleteUser(int id) { userdao.deleteUser(id); } }

jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.dialect=org.hibernate.dialect.MySQLDialect jdbc.databaseurl=jdbc:mysql://127.0.0.1:3306/jdbc jdbc.username=root jdbc.password=root

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%> <html> <head><title>----</title></head> <body> <h1>Add User</h1> <c:url var="viewUsersUrl" value="/users.html" /> <a href="${viewUsersUrl}">Show All the Users</a> <br /> <br /> <c:url var="viewUsersUrl" value="/users/save.html" /> <form:form modelAttribute="article" method="POST" action="${viewUsersUrl}"> <form:label path="Name">Name:</form:label> <form:input path="Name" /> <br /> <form:label path="LastName:">LastName:</form:label> <form:textarea path="LastName:" /> <br /> <form:label path="Address:">Address:</form:label> <form:textarea path="Address:" /> <br /> <form:label path="Age:">Age:</form:label> <form:textarea path="Age:" /> <input type="submit" value="Save User" /> </form:form> </body> </html>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <html> <head> <title>All Articles</title> </head> <body> <h1>List of Users</h1> <a href="users/add.html">Add Article</a> <c:if test="${!empty users}"> <table> <tr> <th>ID</th> <th>Name</th> <th>Last Name</th> <th>Address</th> <th>Age</th> </tr> <c:forEach items="${users}" var="user"> <tr> <td><c:out value="${user.id}"/></td> <td><c:out value="${user.name}"/></td> <td><c:out value="${user.lastName}"/></td> <td><c:out value="${user.address}"/></td> <td><c:out value="${user.age}"/></td> <td><a href="delete/${user.id}">delete</a></td> </tr> </c:forEach> </table> </c:if> </body> </html>

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/beans" xsi:schemalocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"> <tx:annotation-driven/> <context:annotation-config /> <context:component-scan base-package="org.lanaizen" /> <context:property-placeholder location="classpath:jdbc.properties"/> <bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/view/" /> <property name="suffix" value=".jsp" /> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${database.driver}" /> <property name="url" value="${database.url}" /> <property name="username" value="${database.user}" /> <property name="password" value="${database.password}" /> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="annotatedClasses"> <list> <value>org.lanaizen.entity.User</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">${jdbc.dialect}</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> <bean id="hibernatetransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> </beans>

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> <display-name>SpringHibernate</display-name> <servlet> <servlet-name>dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcher</servlet-name> <url-pattern>*.html</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!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=ISO-8859-1"> <title>Spring and Hibernate</title> </head> <body> <h1>Spring and Hibernate</h1> <a href="users.html">List of Users</a> <a href="users/add.html">List of Users</a> </body> </html>

The list of jars

activation-1.0.2.jar antlr-2.7.6.jar aopalliance-1.0.jar asm-1.5.3.jar asm-attrs-1.5.3.jar cglib-2.1_3.jar commons-beanutils-1.7.0.jar commons-collections.jar commons-digester-1.8.jar commons-email-1.0.jar commons-fileupload-1.1.1.jar commons-io.jar commons-lang.jar commons-logging.jar dom4j-1.6.1.jar dumbster-1.6.jar ehcache-1.2.3.jar hibernate-commons-annotations.jar hibernate-core.jar hibernate-entitymanager.jar hibernate-validator.jar mysql-connector-java-5.1.18-bin.jar org.springframework.web-3.0.0.M3.jar org.springframework.web.servlet-3.0.0.M3.jar spring-aop.jar spring-asm.jar spring-beans.jar spring-context.jar spring-core.jar spring-expression.jar spring-jdbc.jar spring-orm.jar spring-tx.jar spring-web.jar