public void addHandler(ResourceHandlerRegistry reg)


{


    reg.addResourceHandler("/resources**/").addResourceLocations("/resources/");


}


@Bean(name = "viewResolver")


public InternalResourceViewResolver getViewResolver() {


    InternalResourceViewResolver viewResolver = new

viewResolver.setPrefix("/WEB-INF/view/");


    viewResolver.setSuffix(".jsp");


    return viewResolver;


}


@Bean(name = "dataSource")


public DataSource getDataSource() {


   // BasicDataSource dataSource = new BasicDataSource();


    BasicDataSource dataSource = new BasicDataSource();


    dataSource.setDriverClassName("com.mysql.jdbc.Driver");


    dataSource.setUrl("jdbc:mysql://localhost:3306/usersdb");


    dataSource.setUsername("root");


    dataSource.setPassword("secret");


    return dataSource;

}


private Properties getHibernateProperties() {


    Properties properties = new Properties();


    properties.put("hibernate.show_sql", "true");


    properties.put("hibernate.dialect",

return properties;



}


@Autowired


@Bean(name = "sessionFactory")


public SessionFactory getSessionFactory(DataSource dataSource) {



   // LocalSessionFactoryBuilder sessionBuilder = new

LocalSessionFactoryBuilder sessionBuilder = new

sessionBuilder.addAnnotatedClasses(User.class);


    return sessionBuilder.buildSessionFactory();

}


@Autowired


@Bean(name = "transactionManager")


public HibernateTransactionManager getTransactionManager(


        SessionFactory sessionFactory) {


    HibernateTransactionManager transactionManager = new

sessionFactory);


    return transactionManager;

}


@Autowired


@Bean(name = "userDao")


public UserDAO getUserDao(SessionFactory sessionFactory) {


    return new UserDAOImpl(sessionFactory);


}

public void onStartup(ServletContext servletContext) throws ServletException

// TODO Auto-generated method stub
    AnnotationConfigWebApplicationContext appContext = new

appContext.register(SpringConfig.class);


     ServletRegistration.Dynamic dispatcher = servletContext.addServlet(


                "SpringDispatcher", new DispatcherServlet(appContext));


        dispatcher.setLoadOnStartup(1);


        dispatcher.addMapping("/");



}

@Autowired


private UserDAO userDao;


@RequestMapping("/")


public ModelAndView handleRequest() throws Exception {


    List<User> listUsers = userDao.list();


    ModelAndView model = new ModelAndView("UserList");


    model.addObject("userList", listUsers);


    return model;


}


@RequestMapping(value = "/new", method = RequestMethod.GET)


public ModelAndView newUser() {


    ModelAndView model = new ModelAndView("UserForm");


    model.addObject("user", new User());


    return model;


}



@RequestMapping(value = "/edit", method = RequestMethod.GET)


public ModelAndView editUser(HttpServletRequest request) {


    int userId = Integer.parseInt(request.getParameter("id"));


    User user = userDao.get(userId);


    ModelAndView model = new ModelAndView("UserForm");


    model.addObject("user", user);


    return model;


}

@RequestMapping(value = "/delete", method = RequestMethod.GET)


public ModelAndView deleteUser(HttpServletRequest request) {


    int userId = Integer.parseInt(request.getParameter("id"));


    userDao.delete(userId);


    return new ModelAndView("redirect:/");


}

@RequestMapping(value = "/save", method = RequestMethod.POST)




public ModelAndView saveUser(@ModelAttribute User user) {


    userDao.saveOrUpdate(user);


    return new ModelAndView("redirect:/");


}

public List<User> list();


    public User get(int id);


    public void saveOrUpdate(User user);


    public void delete(int id);

@Autowired


private SessionFactory sessionFactory;


public UserDAOImpl() {



}

public UserDAOImpl(SessionFactory sessionFactory) {


    this.sessionFactory = sessionFactory;


}

@Transactional


public List<User> list() {


    // TODO Auto-generated method stub


     @SuppressWarnings("unchecked")


    List<User> listUser = (List<User>) sessionFactory.getCurrentSession()


                .createCriteria(User.class)


                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();


        return listUser;


}


public User get(int id) {


    // TODO Auto-generated method stub


      String hql = "from User where id=" + id;


        Query query = sessionFactory.getCurrentSession().createQuery(hql);



        @SuppressWarnings("unchecked")


        List<User> listUser = (List<User>) query.list();



        if (listUser != null && !listUser.isEmpty()) {


            return listUser.get(0);


        }



        return null;


    }


@Transactional


public void saveOrUpdate(User user) {


    // TODO Auto-generated method stub


    sessionFactory.getCurrentSession().saveOrUpdate(user);


}


public void delete(int id) {


    // TODO Auto-generated method stub


    User userToDelete = new User();


    userToDelete.setId(id);


    sessionFactory.getCurrentSession().delete(userToDelete);


}