• 大小: 3.46MB
    文件类型: .zip
    金币: 1
    下载: 0 次
    发布日期: 2023-09-21
  • 语言: 其他
  • 标签: bbs  java  jsp  论坛  

资源简介

bbs论坛模板,有部署说明,现成的源代码,拷了就能用

资源截图

代码片段和文件信息

package com.hongshee.ejforum.data;

/**
 * 

title: EntityDAO.java


 * 

Description: base class of all data access object


 * 

Copyright: Hongshee Software (c) 2007


 * @author jackie du
 * @version 1.0
 */

import java.util.ArrayList;
import java.util.HashMap;
//import java.util.Map;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetmetaData;
import java.sql.SQLException;

import com.hongshee.common.util.DBManager;
import com.hongshee.ejforum.common.AppContext;
//import com.hongshee.ejforum.util.PageUtils;

public abstract class EntityDAO 
{
    protected DBManager dbManager = DBManager.getInstance();
    SqlAdapter adapter = AppContext.getInstance().getSqlAdapter();
    String adapterName = adapter.getClass().getName();
    
    /**
     * Execute an update statement
     * @param 
     *      sql - sql statement to execute
     *      paramList - Parameter value list
     * @return none
     * @throws SQLException
     * @since 1.0
     */
    public void execUpdateSql(String sql ArrayListject> paramList) 
                                                throws SQLException
    {
        Connection conn = null;
        try
        {
            conn = dbManager.getConnection();
            execUpdateSql(sql paramList conn);
        }
        finally
        {
            dbManager.closeConnection(conn);
        }
    }
    
    /**
     * Execute an update statement
     * @param 
     *      sql - sql statement to execute
     *      paramList - Parameter value list
     *      conn - DB connection
     * @return none
     * @throws SQLException
     * @since 1.0
     */
    protected void execUpdateSql(String sql ArrayListject> paramList 
                                 Connection conn) throws SQLException
    {
        PreparedStatement pstmtUpdate = null;
        try
        {
            pstmtUpdate = conn.prepareStatement(sql);
            if (paramList != null)
            {
                for (int i=0; i                {
                    pstmtUpdate.setobject(i+1 paramList.get(i));
                }
            }
            pstmtUpdate.executeUpdate();
        }
        finally
        {
            dbManager.closePStatement(pstmtUpdate);
        }
    }

    /**
     * Execute an select statement
     * @param 
     *      sql - sql statement to execute
     *      paramList - Parameter value list
     * @return Result list - ArrayList
     * @throws SQLException
     * @since 1.0
     */
    public ArrayList execSelectSql(String sql ArrayListject> paramList)
                                                                throws SQLException
    {
        Connection conn = null;
        try
        {
            conn = dbManager.getConnection();
            return execSelectSql(sql paramList co

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2009-03-24 23:52  ejforum-2.3\ejforum\
     目录           0  2009-01-16 16:42  ejforum-2.3\ejforum\admin\
     目录           0  2009-01-16 17:18  ejforum-2.3\ejforum\admin\basic\
     文件        7153  2009-01-21 11:42  ejforum-2.3\ejforum\admin\basic\access.jsp
     文件        8423  2009-03-20 13:14  ejforum-2.3\ejforum\admin\basic\baseinfo.jsp
     文件        4032  2009-01-08 21:36  ejforum-2.3\ejforum\admin\basic\censor.jsp
     文件        5756  2009-05-18 21:49  ejforum-2.3\ejforum\admin\basic\config.jsp
     文件        5582  2009-02-08 09:24  ejforum-2.3\ejforum\admin\basic\credit_rule.jsp
     文件       13334  2009-01-16 17:18  ejforum-2.3\ejforum\admin\basic\display.jsp
     文件       13130  2009-01-08 21:38  ejforum-2.3\ejforum\admin\basic\functions.jsp
     文件        3367  2008-04-26 17:51  ejforum-2.3\ejforum\admin\basic\seo.jsp
     文件        3275  2009-01-13 00:53  ejforum-2.3\ejforum\admin\basic\showcolor.htm
     文件        6451  2009-01-16 21:17  ejforum-2.3\ejforum\admin\basic\style_info.jsp
     文件        4400  2009-01-16 16:41  ejforum-2.3\ejforum\admin\basic\ui_styles.jsp
     文件        1859  2008-04-26 17:49  ejforum-2.3\ejforum\admin\error.jsp
     目录           0  2009-01-08 21:38  ejforum-2.3\ejforum\admin\forums\
     文件        3967  2008-04-26 17:52  ejforum-2.3\ejforum\admin\forums\attach_list.jsp
     文件        5752  2008-04-26 17:52  ejforum-2.3\ejforum\admin\forums\attach_query.jsp
     文件        4410  2008-04-26 17:52  ejforum-2.3\ejforum\admin\forums\forum_add.jsp
     文件        4693  2008-04-26 17:52  ejforum-2.3\ejforum\admin\forums\forum_copy.jsp
     文件        6786  2008-04-26 17:52  ejforum-2.3\ejforum\admin\forums\forum_edit.jsp
     文件       16134  2009-01-08 21:38  ejforum-2.3\ejforum\admin\forums\forum_info.jsp
     文件        5191  2008-04-26 17:53  ejforum-2.3\ejforum\admin\forums\forum_merge.jsp
     文件        3436  2008-04-26 17:53  ejforum-2.3\ejforum\admin\forums\forum_moderator.jsp
     文件        5536  2008-07-04 11:34  ejforum-2.3\ejforum\admin\forums\log_censor.jsp
     文件        5600  2008-07-21 15:23  ejforum-2.3\ejforum\admin\forums\log_report.jsp
     文件        4823  2008-08-07 23:15  ejforum-2.3\ejforum\admin\forums\post_delete.jsp
     文件        6390  2008-08-07 23:14  ejforum-2.3\ejforum\admin\forums\post_list.jsp
     文件        3386  2008-04-26 17:53  ejforum-2.3\ejforum\admin\forums\section_edit.jsp
     文件        6814  2008-08-07 18:15  ejforum-2.3\ejforum\admin\forums\topic_admin.jsp
     文件        8912  2008-08-07 22:33  ejforum-2.3\ejforum\admin\forums\topic_list.jsp
............此处省略374个文件信息

评论

共有 条评论