articlesqlmapdao.java.svn-base

来自「一个实用的CMS管理」· SVN-BASE 代码 · 共 61 行

package com.suncms.persistence.sqlmapdao; 

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

import com.suncms.domain.Article;
import com.suncms.domain.Article_Class;
import com.suncms.persistence.iface.ArticleDao;

 
public class ArticleSqlMapDao extends BaseSqlMapDao implements ArticleDao { 
  public ArticleSqlMapDao() { 
   
  }

public void insertArticle(Article article) {
	try{
	smcTemplate.update("insertArticle", article); 
	}catch(Exception e){
		e.printStackTrace();
	}
}

public void updateArticle(Article article) {
	smcTemplate.update("updateArticle", article); 
	
}

public Article getArtById(String Row_Id) {
	return (Article)smcTemplate.queryForObject("getArtById",Row_Id);
}

public List<Article> getArticleByClass(String ClassId) {
	
	return (List<Article>) smcTemplate.queryForList("getArtByClass",ClassId);
}

public int getTotalCount(Map con) {
	
	return (Integer) smcTemplate.queryForObject("getTotalCount",con);
}

public List<Article> limitQuery(Map con) {
	return (List<Article>) smcTemplate.queryForList("limitQuery",con);
}

public int getTotalCountByClass(String class_id) {
	return (Integer) smcTemplate.queryForObject("getTotalCountByClass",class_id);
}

public void artupdateById(Article article) {
	try{
		smcTemplate.update("artupdateById", article); 
		}catch(Exception e){
			e.printStackTrace();
		}
	
} 
  
  
}