package org.news.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.news.datascore.dateScoreconnext;

public class BaseDao {
	public Connection conn=null;
	/**
	 * 蠅槫唖謾ｹ蜈ｬ蜈ｱ譁ｹ豕?
	 * 
	 * @param sql
	 * @param params
	 * @return
	 */
	protected int executeUpdate(String sql, Object... params) {
		int result = 0;
		conn = dateScoreconnext.getConnection();
		PreparedStatement pstmt = null;
		try {
			pstmt = conn.prepareStatement(sql);
			for (int i = 0; i < params.length; i++) {
				pstmt.setObject(i + 1, params[i]);
			}
			result = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			dateScoreconnext.closeAll(null, pstmt, null);
		}
		return result;
	}

	/**
	 * 譟･隸｢
	 * @param sql
	 * @param params
	 * @return
	 */
	protected ResultSet executeQuery(String sql, Object... params) {
		conn =dateScoreconnext.getConnection();
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			pstmt = conn.prepareStatement(sql);
			for (int i = 0; i < params.length; i++) {
				pstmt.setObject(i + 1, params[i]);
			}
			rs = pstmt.executeQuery();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}
}