s2pshixian

action zhong


public class NewTypeAction extends ActionSupport implements RequestAware, SessionAware {

/**
* <p>
* Title:xx * </p>
* <p>
* Description: * </p>
* <p>
* Copyright: Copyright (c) 2009
* </p>
* <p>
* Company
* </p>
*
* @author
*
* @version $Revision: 1.0 $ $Date: 2010-x-x日
*
*/
private static final long serialVersionUID = 1L;
private Log log = LogFactory.getLog("BACKGROUND_ACTION_EXCEPTION");
private Map<String, Object> request;
private Map<String, Object> session;
private NewTypeManager newTypeManager;


/********************
* 查找所有的新闻
*/
public String findAll() {
HttpServletRequest request = ServletActionContext.getRequest();
List<NewType> list = null;
list = newManager.findAll();
request.setAttribute("data", list);
return "s_list_news";
}

/*********************
/**
* 增加新闻类型
*
* @date 2010-07-21
*/
public String addNew() {
HttpServletRequest request = ServletActionContext.getRequest();

String newName = request.getParameter("newName");// typeName
try {
String adminName = (String) session.get("userName"); // 从session中得到adminName

System.out.println("typeName=" + typeName);
newManager.addNew(newName, adminName);
return "s_success_news";
}


public Map<String, Object> getRequest() {
return request;
}

public Map<String, Object> getSession() {
return session;
}

}

managerzhong:;


private NewDAO newDAO;//新闻DAO


private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
/**
* 添加一条行业类型的信息
*/
public void add(String newName, String adminName)
throws DataAccessException, TipException {
new vo =newDAO.findByName(typeName);
newDAO.insert(new new(newName));
}


dao中


private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}


public void insert(NewType model) throws DataAccessException {
try {
String sql = "insert into new(Id,Name) values(?,?)";
Object[] params = new Object[] { model.getTypeId(),
model.getTypeName() };
jdbcTemplate.update(sql, params);

}


SELECT Id,Name,fatherId FROM new WHERE Id=?"

update new set Id =?,Name=? where tId=?"
delete from new where Id=" + Id