lunzi

1、DAO interface
package test.dao;

import java.util.List;

import test.model.Book;

public interface BookDAO {
	void create(Book book);
	List<Book> queryByAuthor(String author);
}

2、DAO Impl

package test.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import test.dao.BookDAO;
import test.model.Book;

public class BookDAOImpl extends JdbcDaoSupport implements BookDAO {

	class BookRowMapper implements RowMapper {

		public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
			Book book = new Book();
			book.setId(rs.getLong("id"));
			book.setName(rs.getString("name"));
			book.setAuthor(rs.getString("author"));
			return book;
		}

	}

	public void create(Book book) {
		getJdbcTemplate().update(
				"insert into book(id,name,author)values(book_seq.nextval,?,?)",
				new Object[] { book.getName(), book.getAuthor() });
	}

	public List<Book> queryByAuthor(String author) {
		return getJdbcTemplate().query("select * from book where author=?", new Object[]{author}, new BookRowMapper());
	}
	

}
3、spring context
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>

    <!--========WebDb DataSource========================================================================-->
	 <!-- -->
	<bean id="webdbDataSource"
          class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:lunzi"/>
        <property name="username" value="webnews"/>
        <property name="password" value="123456"/>
    </bean> 
    
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="webdbDataSource"/>
	</bean>
	
	<bean id="bookDao" class="test.dao.impl.BookDAOImpl">
		<property name="dataSource" ref="webdbDataSource"/>
	</bean>

</beans>
4、测试类
package test.dao.test;

import java.util.List;

import test.dao.BookDAO;
import test.model.Book;

public class BookDAOTest extends BaseDaoTestCase {
	public BookDAO bookDao;
	
	public void setBookDao(BookDAO bookDao){
		this.bookDao = bookDao;
	}
	
	/*public void testCreateBook(){
		Book book = new Book();
		book.setAuthor("lunzi2");
		book.setName("cow2");
		this.bookDao.create(book);
	}*/
	
	public void testQueryByAuthor(){
		List<Book> list = this.bookDao.queryByAuthor("lunzi2");
		
		for(Book book:list){
			System.out.println(book.getName());
		}
		super.assertNotNull(list);
	}
}

1、action
package test.web.action;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import test.model.NewsModel;
import test.model.PageUtil;

import com.opensymphony.xwork.ActionContext;
import com.opensymphony.xwork.ActionSupport;

public class HelloAction extends ActionSupport {

	private static final long serialVersionUID = 1L;
	private String hello;
	private List<NewsModel> newsList = new ArrayList<NewsModel>();
	private PageUtil pageUtil = new PageUtil();
	
	
	public PageUtil getPageUtil() {
		return pageUtil;
	}

	public void setPageUtil(PageUtil pageUtil) {
		this.pageUtil = pageUtil;
	}

	public void setNewsList(List<NewsModel> newsList) {
		this.newsList = newsList;
	}

	public List getNewsList() {
		return newsList;
	}

	public String getHello() {
		return hello;
	}

	public void setHello(String hello) {
		this.hello = hello;
	}

	public String execute() throws Exception{
		this.setHello("hello webwork!!!");
		return SUCCESS;
	}
	
	@SuppressWarnings("unchecked")
	public String getFirst() throws Exception{
		newsList.add(new NewsModel(1,"newsTilte"));
		newsList.add(new NewsModel(2,"newsTilte"));
		pageUtil.setItems(newsList);
		pageUtil.setPageSize(101);
		
		Map request = (Map)ActionContext.getContext().get("request");
		request.put("newsList",newsList);
		request.put("pageUtil", pageUtil);
		this.setHello("hello first!!!");
		return SUCCESS;
	}

}
2、jsp视图
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ taglib prefix="ww" uri="/webwork" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>hello.html</title>
	
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="this is my page">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    
    <!--<link rel="stylesheet" type="text/css" href="./styles.css">-->

  </head>
  
  <body>
	<ww:property value="hello"/><br/>
	<ww:iterator value="#request['newsList']" id="book">
		<ww:property value="#book.id"/>
		<ww:property value="#book.title"/><br/>
	</ww:iterator>
	
	<ww:set name="page" value="#request.pageUtil"/>
	<ww:iterator value="#page.items" id="news">
		<ww:property value="#news.id"/>
		<ww:property value="#news.title"/><br/>
	</ww:iterator>
  </body>
</html>


验证的一视图jsp代码
   <%@ page contentType="text/html; charset=UTF-8" %>
<%@ taglib prefix="ww" uri="/webwork" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>hello.html</title>
	
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="this is my page">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    
    <!--<link rel="stylesheet" type="text/css" href="./styles.css">-->

  </head>
  
  <body>
	<form action="add.jhtml" method="post">
		title:<input name="newsModel.title" value="<ww:property value="newsModel.title"/>">
		<ww:if test="fieldErrors['newsModel.title']!=null">
			<ww:property value="fieldErrors['newsModel.title']"/>
		</ww:if><br>
		<input type="submit" value="提交">
	</form>
	
	
	<ww:form method="post">
    <ww:textfield label="Name" name="newsModel.title"/>
    <ww:submit value="保存" />
</ww:form>
  </body>
</html>

package test.action;

import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

import org.thj.bookstore.model.InfoModel;

import com.opensymphony.xwork.ActionContext;
import com.opensymphony.xwork.ActionSupport;

public class TestAction extends ActionSupport{

	private static final long serialVersionUID = 1L;
	
	private String hello;
	private int stepNum;
	private InfoModel infoModel = new InfoModel();
	private Map<Integer,InfoModel> stepMap = new HashMap<Integer,InfoModel>();
	
	public InfoModel getInfoModel() {
		return infoModel;
	}

	public void setInfoModel(InfoModel infoModel) {
		this.infoModel = infoModel;
	}

	public int getStepNum() {
		return stepNum;
	}

	public void setStepNum(int stepNum) {
		this.stepNum = stepNum;
	}

	public String getHello() {
		return hello;
	}

	public void setHello(String hello) {
		this.hello = hello;
	}
	
	public int getTotalStep(){
		if(ActionContext.getContext().getSession().get("stepNum")!=null){
			return (Integer)ActionContext.getContext().getSession().get("stepNum");
		}else{
			return 0;
		}
	}

	public String execute() throws Exception{
		this.setHello("hello webwork!!");
		return SUCCESS;
	}
	
   public String second() throws Exception{
	   Map session = ActionContext.getContext().getSession();
	   if(stepNum>0){
		   session.put("stepNum", stepNum);
	   } 
	   stepNum = 1;
		return SUCCESS;
	}
   
   public String next() throws Exception{
	   Map session = ActionContext.getContext().getSession();
	   //int totalStep = Integer.parseInt((String)session.get("stepNum"));
	   if(stepNum<=this.getTotalStep()){
		   if(stepNum==1){
			   stepMap.put(stepNum, infoModel);
			   session.put("part", stepMap);
		   }else{
			   stepMap = (Map)session.get("part");
			   if(!stepMap.containsKey(stepNum)){
				   System.out.println("next stepNum:"+stepNum);
				   stepMap.put(stepNum, infoModel);
				   session.put("part", stepMap);
			   }
		   }
		   
		   if(stepNum==this.getTotalStep()){
			   stepMap = (Map)session.get("part");
			   for(Iterator it = stepMap.values().iterator();it.hasNext();){
				   infoModel = (InfoModel)it.next();
				   System.out.println("step:"+infoModel.getStep()+"\t");
				   System.out.println("name:"+infoModel.getName()+"\n");
			   }
			   session.remove("stepNum");
			   session.remove("part");
			   return NONE;
		   }
		   
		   stepNum++;
	   }
	   return SUCCESS;
   }

}
配置
<action name="hello" class="test.action.TestAction">
			<result name="success">/hello.jsp</result>
		</action>
		<action name="second" class="test.action.TestAction" method="second">
			<result name="success">/next.jsp</result>
		</action>
		<action name="next" class="test.action.TestAction" method="next">
			<result name="success">/next.jsp</result>
		</action>
hello.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ taglib prefix="ww" uri="/webwork"%>
<html>
  <body>
  		<form action="second.action" method="post">
  			step:<input name="stepNum"/>
  			<input type="submit" value="提交"/>
  		</form>
    	<ww:property value="hello"/>
  </body>
</html>
next.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ taglib prefix="ww" uri="/webwork"%>
<html>
  <body>
  		<form action="next.action" method="post">
  			step:<input type="hidden" name="stepNum" value="<ww:property value="stepNum"/>"/>
  			<input name="infoModel.step" value="<ww:property value="stepNum"/>" readonly/>
  			<input name="infoModel.name" />
  			<input type="submit" value="提交"/>
  		</form>
    	
  </body>
</html>