updatesql.java

JSP移动商品管理平台源代码.........

package imis_hous.com.impl;

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

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

import cmis.database.DBPoolManager;

public class UpdateSql {
	public boolean update(String sql) {
		boolean flag = false;
		DBPoolManager dbpool = new DBPoolManager();
		Connection conn = null;
		Statement stmt = null;
		AreaInfoEH area = null;
		DBClose dbclose = new DBClose();
		
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			
			int i = stmt.executeUpdate(sql);

			flag = i > 0 ? true : false;
			dbpool.commit();
		} catch (SQLException e) {

		} finally {
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		// TODO Auto-generated method stub
		return flag;
	}
}