use how2java;
 
CREATE TABLE product_ (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(30) ,
  price float ,
  PRIMARY KEY (id)
) DEFAULT CHARSET=UTF8;

use how2java;
delete from product_;
INSERT INTO product_ VALUES (null,'产品a',88.88);
INSERT INTO product_ VALUES (null,'产品b',88.88);
INSERT INTO product_ VALUES (null,'产品c',88.88);
INSERT INTO product_ VALUES (null,'产品x',88.88);
INSERT INTO product_ VALUES (null,'产品y',88.88);
INSERT INTO product_ VALUES (null,'产品z',88.88);

package com.how2java.pojo;

public class Product {

	private int id;
	private String name;
	private float price;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public float getPrice() {
		return price;
	}
	public void setPrice(float price) {
		this.price = price;
	}
	
}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.how2java.pojo">
	<class name="Product" table="product_">
		<id name="id" column="id">
			<generator class="native">
			</generator>
		</id>
		<property name="name" />
		<property name="price" />
	</class>
	
</hibernate-mapping>

package com.how2java.dao;

import java.util.List;
import com.how2java.pojo.Product;
public interface ProductDAO {
	
	public List<Product> list();
	public void add(Product p);
}

package com.how2java.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.HibernateTemplate;

import com.how2java.dao.ProductDAO;
import com.how2java.pojo.Product;

public class ProductDAOImpl extends HibernateTemplate implements ProductDAO{
	
	public List<Product> list() {
		return find("from Product");
	}

	@Override
	public void add(Product p) {
		save(p);
	}
	
}

package com.how2java.service;

import java.util.List;

import com.how2java.pojo.Product;

public interface ProductService {
	
	public List<Product> list();
}

package com.how2java.service.impl;

import java.util.List;
import org.springframework.orm.hibernate3.HibernateTemplate;
import com.how2java.dao.ProductDAO;
import com.how2java.pojo.Product;
import com.how2java.service.ProductService;

public class ProductServiceImpl implements ProductService {
	ProductDAO productDAO;
	public List<Product> list() {
		List<Product> products= productDAO.list();
		if(products.isEmpty()){
			for (int i = 0; i < 5; i++) {
				Product p = new Product();
				p.setName("product " + i);
				productDAO.add(p);
				products.add(p);
			}
		}
		return products;
	}

	public ProductDAO getProductDAO() {
		return productDAO;
	}

	public void setProductDAO(ProductDAO productDAO) {
		this.productDAO = productDAO;
	}
}

package com.how2java.action;

import java.util.List;

import com.how2java.pojo.Product;
import com.how2java.service.ProductService;

public class ProductAction {

	ProductService productService;
	List<Product> products;

	public String list() {
		products = productService.list();
		return "listJsp";
	}

	public ProductService getProductService() {
		return productService;
	}

	public void setProductService(ProductService productService) {
		this.productService = productService;
	}

	public List<Product> getProducts() {
		return products;
	}

	public void setProducts(List<Product> products) {
		this.products = products;
	}

}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
  <constant name="struts.i18n.encoding" value="UTF-8"></constant>
  
  <constant name="struts.objectFactory" value="spring"/>
  
  <package name="basicstruts" extends="struts-default">
  
  <action name="listProduct" class="productActionBean" method="list">
    <result name="listJsp">list.jsp</result>
  </action>
  
</package>
</struts>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
   http://www.springframework.org/schema/beans 
   http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
   http://www.springframework.org/schema/aop 
   http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
   http://www.springframework.org/schema/tx 
   http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
   http://www.springframework.org/schema/context      
   http://www.springframework.org/schema/context/spring-context-3.0.xsd">
 
    <bean name="productActionBean" class="com.how2java.action.ProductAction">
    	<property name="productService" ref="productServiceImpl" />
    </bean>
    
	<bean name="productServiceImpl" class="com.how2java.service.impl.ProductServiceImpl">
        <property name="productDAO" ref="productDAOImpl" />
    </bean>
	<bean name="productDAOImpl" class="com.how2java.dao.impl.ProductDAOImpl">
        <property name="sessionFactory" ref="sf" />
    </bean>

	<bean name="sf"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="ds" />
		<property name="mappingResources">
			<list>
				<value>com/how2java/pojo/Product.hbm.xml</value>
			</list>
		</property>
 
	    <property name="schemaUpdate">  
	        <value>true</value>  
	    </property>  
	    		
		<property name="hibernateProperties">
			<value>
				hibernate.dialect=org.hibernate.dialect.MySQLDialect
				hibernate.show_sql=true
				hbm2ddl.auto=update
   			</value>
		</property>
	</bean>    
        
    <bean name="ds"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/how2java?characterEncoding=UTF-8" />
		<property name="username" value="root" />
		<property name="password" value="admin" />
	</bean>	    
</beans>

<web-app>
	<filter>
		<filter-name>struts2</filter-name>
		<filter-class>
			org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
		</filter-class>
	</filter>

	<filter-mapping>
		<filter-name>struts2</filter-name>
		<dispatcher>FORWARD</dispatcher>
		<dispatcher>REQUEST</dispatcher>		
		<url-pattern>/*</url-pattern>
	</filter-mapping>

	<listener>
  		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 	</listener>
 	
</web-app>

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8" isELIgnored="false"%>

<%@ taglib prefix="s" uri="/struts-tags" %>

<%@page isELIgnored="false"%>

<table>
	<tr>
		<td>id</td>
		<td>name</td>
	</tr>
	    	    
<s:iterator value="products" var="p">
	<tr>
		<td>${p.id}</td>
		<td>${p.name}</td>
	</tr>
</s:iterator>

</table>