<context:component-scan base-package="my.package" />
    <tx:annotation-driven transaction-manager="txManager" />

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="url" value="${jdbc.url}" />
        <property name="initialSize" value="5" />
        <property name="minIdle" value="10" />
        <property name="maxActive" value="100" />
        <property name="testOnBorrow" value="true" />
        <property name="maxWait" value="3000" />
        <property name="validationQuery" value="/* ping */ SELECT 1" />
    </bean>

    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
	<property name="defaultTimeout" value="30" />
	<property name="dataSource" ref="dataSource" />
    </bean>

        @Resource
	private SellerRepository sellerRepository;

	@RequestMapping(value = "/save", method = RequestMethod.POST)
	public String save(@ModelAttribute("seller") Seller seller) {
		sellerRepository.save(seller);
		return "redirect:/profile/edit";
	}

@Repository("sellerRepository")
public class JdbcSellerRepository extends JdbcDaoSupport implements SellerRepository {

	@Autowired
	public JdbcSellerRepository(DataSource dataSource) {
		super.setDataSource(dataSource);
	}

	@Override
	@Transactional
	public void save(final Seller seller) {
		saveSeller(seller);
		for (final MenuItem menuItem : seller.getMenu()) {
			saveMenuItem(menuItem, seller.getId());
			for (final Dish dish : menuItem.getDishes()) {
				saveDish(dish, menuItem.getId());
			}
		}
	}

	private void saveSeller(final Seller seller) {
		getJdbcTemplate().update("update Seller set name = ?, description = ?, contacts = ?, imageUrl = ?, " +
				"workTime = ?, email = ? where id = ?",
				new PreparedStatementSetter() {
					@Override
					public void setValues(PreparedStatement ps) throws SQLException {
						ps.setString(1, seller.getName());
						ps.setString(2, seller.getDescription());
						ps.setString(3, seller.getContacts());
						ps.setString(4, seller.getImageUrl());
						ps.setString(5, seller.getWorkTime());
						ps.setString(6, seller.getEmail());
						ps.setLong(7, seller.getId());
					}
				});
	}

	private void saveMenuItem(final MenuItem menuItem, final Long sellerId) {
		if (menuItem.getId() != null) {
			getJdbcTemplate().update("update MenuItem set name = ?, imageUrl = ? where id = ?",
					new PreparedStatementSetter() {
						@Override
						public void setValues(PreparedStatement ps) throws SQLException {
							ps.setString(1, menuItem.getName());
							ps.setString(2, menuItem.getImageUrl());
							ps.setLong(3, menuItem.getId());
						}
					});
		} else {
			GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
			getJdbcTemplate().update(
					new PreparedStatementCreator() {
						@Override
						public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
							PreparedStatement ps = con.prepareStatement("insert into MenuItem (name, imageUrl, sellerId) values (?, ?, ?)", Statement.RETURN_GENERATED_KEYS);
							ps.setString(1, menuItem.getName());
							ps.setString(2, menuItem.getImageUrl());
							ps.setLong(3, sellerId);
							return ps;
						}
					} , keyHolder);
			menuItem.setId((Long) keyHolder.getKey());
		}
	}
}

        <context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
			/WEB-INF/context/*.xml
		</param-value>
	</context-param>

	<servlet>
		<servlet-name>webmvc</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>
				/WEB-INF/context/applicationContext.xml
			</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>