com.ewcms.content.particular.dao.FontArticleMainDAO.java Source code

Introduction

Here is the source code for com.ewcms.content.particular.dao.FontArticleMainDAO.java

Source

/**
 * Copyright (c)2010-2011 Enterprise Website Content Management System(EWCMS), All rights reserved.
 * EWCMS PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 * http://www.ewcms.com
 */
package com.ewcms.content.particular.dao;

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

import javax.persistence.TypedQuery;
import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import com.ewcms.common.dao.JpaDAO;
import com.ewcms.content.particular.model.ArticleMain;
import com.ewcms.frontweb.ArticleMainVO;
import com.ewcms.frontweb.ChannelVO;

@Repository
public class FontArticleMainDAO extends JpaDAO<Long, ArticleMain> {
    private JdbcTemplate jdbcTemplate;

    @Autowired
    public void setDataSource(DataSource dataSource) {
        jdbcTemplate = new JdbcTemplate(dataSource);
    }

    public List<ArticleMainVO> findArticleMainByChannelId(int channelId) {
        String sql = "Select t2.title,t2.url " + "From content_article_main t1,content_article t2 "
                + "where t1.article_id=t2.id and t1.channel_id=? " + "order by t2.id";
        Object[] params = new Object[] { channelId };
        List<ArticleMainVO> list = jdbcTemplate.query(sql, params, new RowMapper<ArticleMainVO>() {
            @Override
            public ArticleMainVO mapRow(ResultSet rs, int rowNum) throws SQLException {
                return articleRowMapper(rs);
            }
        });
        return list;
    }

    private ArticleMainVO articleRowMapper(ResultSet rs) throws SQLException {
        ArticleMainVO vo = new ArticleMainVO();
        vo.setTitle(rs.getString("title"));
        vo.setLink(rs.getString("url"));
        return vo;
    }

    public List<ChannelVO> findChannelChildrensByChannelId(int channelId) {
        String sql = "Select t1.id " + "From site_channel t1 " + "where t1.parent_id=? " + "order by t1.id";
        Object[] params = new Object[] { channelId };
        List<ChannelVO> list = jdbcTemplate.query(sql, params, new RowMapper<ChannelVO>() {
            @Override
            public ChannelVO mapRow(ResultSet rs, int rowNum) throws SQLException {
                return channelRowMapper(rs);
            }
        });
        return list;
    }

    private ChannelVO channelRowMapper(ResultSet rs) throws SQLException {
        ChannelVO vo = new ChannelVO();
        vo.setId(rs.getInt("id"));
        return vo;
    }

    public List<ArticleMain> findArticleMainListByChannel(Integer channelId) {
        String hql = "From ArticleMain As p where p.channelId=:channelId  Order By p.article.published desc ";
        TypedQuery<ArticleMain> query = this.getEntityManager().createQuery(hql, ArticleMain.class);
        query.setParameter("channelId", channelId);
        return query.getResultList();
    }
}