existsql.java

来自「JSP移动商品管理平台源代码.........」· Java 代码 · 共 44 行

package imis_hous.com.impl;

import imis_hous.com.bean.AreaInfoEH;
import imis_hous.com.db.DBClose;

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

import cmis.database.DBPoolManager;

public class ExistSql {
	public boolean exist(String sql) {
		boolean flag = false;
		DBPoolManager dbpool = new DBPoolManager();
		Connection conn = null;
		Statement stmt = null;
		AreaInfoEH area = null;
		DBClose dbclose = new DBClose();
		ResultSet rs = null;
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
			dbpool.rollback();
			
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		// TODO Auto-generated method stub
		return flag;
	}
}