public class EmployeeAction extends ActionSupport implements ModelDriven<Employee>{	private IEmployeeService employeeService = new EmployeeService();		/*****封装数据**************/	private Employee emp = new Employee();	public void setEmp(Employee emp) {		this.emp = emp;	}	public Employee getEmp() {		return emp;	}	public Employee getModel() {		return emp;	}			public String save(){//不能加参数 save(Employee emp)		try {			//1.调用service			employeeService.save(emp);			//2.跳转页面			return list();		} catch (Exception e) {			e.printStackTrace();			return ERROR;		}	}	public String list(){		try {			//1.去db中拿所有的员工数据			List<Employee> lists = employeeService.getAll();			//2.存入域对象中传到前台去 request域			ActionContext.getContext().getContextMap().put("lists", lists);						return "list";		} catch (Exception e) {			e.printStackTrace();			return ERROR;		}	}//记住千万不能这样写, public String update(Employee emp){...},否则会报找不到这个方法的错误!参数是前台传过的来的,直接封装到了成员变量中了,	public String update(){		try {			employeeService.update(emp);			return list();		} catch (Exception e) {			e.printStackTrace();			return ERROR;		}	}		public String edit(){		try{			//1.获取当前修改的记录的主键值			int id =emp.getId();			//2.调用service查询			Employee emp = employeeService.findById(id);			//3. 数据回显 通过值栈			ValueStack vs = ActionContext.getContext().getValueStack();			vs.pop();			vs.push(emp);			return "update";		}catch (Exception e) {			e.printStackTrace();			return ERROR;		}	}	}

public class EmployeeService implements IEmployeeService {	IEmployeeDao employeeDao = new EmployeeDao();	public List<Employee> getAll() {				return employeeDao.getAll();	}	public Employee findById(int id) {				return employeeDao.findById(id);	}	public void save(Employee emp) {		employeeDao.save(emp);	}	public void update(Employee emp) {		employeeDao.update(emp);	}	public IEmployeeDao getEmployeeDao() {		return employeeDao;	}	public void setEmployeeDao(IEmployeeDao employeeDao) {		this.employeeDao = employeeDao;	}	}

public class EmployeeDao implements IEmployeeDao {	public List<Employee> getAll() {		String sql = "select * from employees";		try {			return JDBCUtils.getQueryRunner().query(sql, new BeanListHandler<Employee>(Employee.class));		} catch (Exception e) {			throw new RuntimeException(e);		}	}	public Employee findById(int id) {		String sql = "select * from employees where id = ?";		try {			return JDBCUtils.getQueryRunner().query(sql, new BeanHandler<Employee>(Employee.class),id);		} catch (Exception e) {			throw new RuntimeException(e);		}	}	public void save(Employee emp) {		String sql = "insert into employees (empName,workDate) values (?,?)";		try {			JDBCUtils.getQueryRunner().update(sql, emp.getEmpName(),emp.getWorkDate());		} catch (SQLException e) {			throw new RuntimeException(e);		}			}	public void update(Employee emp) {		String sql = "update employees set empName=?,workDate=? where id=? ";		try {			JDBCUtils.getQueryRunner().update(sql, emp.getEmpName(),emp.getWorkDate(),emp.getId());		} catch (SQLException e) {			throw new RuntimeException(e);		}	}}

public class JDBCUtils {		//1.初始化连接池	private static DataSource dataSource;	static{		dataSource = new ComboPooledDataSource();	}	public static DataSource getDataSource() {		return dataSource;	}	//2.创建一个DBUtils常用工具类对象	public static QueryRunner getQueryRunner(){		return  new QueryRunner(dataSource);	} }

public class Employee {	private int id;	private String empName;	private Date workDate;}

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5" 	xmlns="http://java.sun.com/xml/ns/javaee" 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> 	<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> 		<url-pattern>/*</url-pattern> 	</filter-mapping></web-app>

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE struts PUBLIC	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"	"http://struts.apache.org/dtds/struts-2.3.dtd"><struts>	<constant name="struts.ui.theme" value="http://www.mamicode.com/simple"></constant>	<package name="emp" extends="struts-default">		<global-results>			<result name="error">/error/error.jsp</result>		</global-results>				<action name="emp_*" class="cn.itcast.action.EmployeeAction" method="{1}">			<interceptor-ref name="defaultStack"></interceptor-ref>			<interceptor-ref name="token">				<param name="includeMethods">save</param>			</interceptor-ref>			<result name="invalid.token" type="redirectAction">emp_list</result>			<result name="list">/WEB-INF/list.jsp</result>			<result name="update">/WEB-INF/update.jsp</result>		</action>	</package></struts>

<c3p0-config>  <default-config>     <property name="driverClass">com.mysql.jdbc.Driver</property>      <property name="jdbcUrl">jdbc:mysql:///hib_demo</property>      <property name="user">root</property>      <property name="password">root</property>      <property name="initialPoolSize">5</property>      <property name="maxPoolSize">10</property>   </default-config>  <named-config name="oracleConfig">    <property name="driverClass">com.mysql.jdbc.Driver</property>      <property name="jdbcUrl">jdbc:mysql:///day17</property>      <property name="user">root</property>      <property name="password">root</property>      <property name="initialPoolSize">5</property>      <property name="maxPoolSize">10</property>    </named-config></c3p0-config>

    <s:form action="/emp_save" method="post">    	<s:token></s:token>    	<table>    		<tr>    			<td>员工 </td>    			<td><s:textfield name="empName"/></td>    		</tr>    		<tr>    			<td>入职时间 </td>    			<td><s:textfield name="workDate"/></td>    		</tr>    		<tr>   			    			<td colspan="2"><s:submit value="http://www.mamicode.com/保存员工"></s:submit></td>    		</tr>    	</table>    </s:form>

<body>    <table border="1" align="center">    	<tr>    		<th>序号</th>    		<th>编号</th>    		<th>员工名</th>    		<th>入职时间</th>    		<th>操作</th>    	</tr>    	<!-- 先判断后迭代 -->    	<s:if test="#request.lists !=null">    		<s:iterator var="emp" value="http://www.mamicode.com/#request.lists" status="st">    			<tr>    				<td><s:property value="http://www.mamicode.com/#st.count"/></td>    				<td><s:property value="http://www.mamicode.com/#emp.id"/></td>    				<td><s:property value="http://www.mamicode.com/#emp.empName"/></td>    				<td><s:property value="http://www.mamicode.com/#emp.workDate"/></td>    				<td>    					<s:a href="http://www.mamicode.com/emp_edit?id=%{#emp.id}">修改</s:a>    				</td>    			</tr>    		</s:iterator>    	</s:if>    	<s:else>    		<tr><td colspan="5">sorry,没有你要的数据</td></tr>    	</s:else>    </table>  </body>

    <s:form action="/emp_update" method="post">    	<s:hidden name="id"></s:hidden>    	<table>    		<tr>    			<td>员工 </td>    			<td><s:textfield name="empName"/></td>    		</tr>    		<tr>    			<td>入职时间 </td>    			<td><s:textfield name="workDate"/></td>    		</tr>    		<tr>   			    			<td colspan="2"><s:submit value="http://www.mamicode.com/修改员工"/></td>    		</tr>    	</table>    </s:form>