commondao.java

分为经理和出纳2个权限

package com.yiboit.cfss.db;

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

public class CommonDAO {
	
	/**
	 * 根据指的SQL语句，返会结果集是否为空
	 * 
	 * @param sql
	 * @return true - 存在
	 * @throws SQLException
	 */
	public static boolean isExist(String sql) throws SQLException {
		boolean result = false;
		
		Connection conn = null;

		try {
			conn = ManageConnection.getConnection();
			PreparedStatement pstmt = conn.prepareStatement(sql);

			ResultSet rs = pstmt.executeQuery();
			
			result = rs.next();
			
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
				}
			}
		}
		
		return result;
	}
}