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
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