DBUtil工具类

IRowMapper接口：

package com.jd.util;

import java.sql.ResultSet;

public interface IRowMapper {

	void rowMapper(ResultSet resultSet);
}

DBUtil工具类： 

package com.jd.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * 数据库工具类
 *
 * @author 
 */
public class DBUtil {

	static {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 获取数据库连接
	 *
	 * @author
	 */
	private static Connection getConnection() {
		try {
			String id=PropertiesUtil.getValue("jdbc.url");
			String userName=PropertiesUtil.getValue("jdbc.userName");
			String password=PropertiesUtil.getValue("jdbc.password");
			return DriverManager.getConnection(id,userName,password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	/**
	 * 批量处理
	 *
	 * @author 
	 */
	public static boolean batch(String [] sqls) {
		Connection connection=null;
    	        Statement statement=null;
    	        try {
			connection=getConnection();
			connection.setAutoCommit(false);
			statement=connection.createStatement();
			for(String sql:sqls) {
				statement.addBatch(sql);
			}
			statement.executeBatch();
			connection.commit();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			if (connection!=null) {
				try {
					connection.rollback();
				} catch (Exception e1) {
					e1.printStackTrace();
				} 
			}
		} finally {
			close(statement, connection);
		}
    	return false;
	}

	/**
	 * 批量处理
	 *
	 * @author 
	 */
	public static boolean batch(String sql,Object[]...params) {
		Connection connection=null;
    	        PreparedStatement preparedStatement=null;
    	        try {
			connection=getConnection();
			connection.setAutoCommit(false);
			preparedStatement=connection.prepareStatement(sql);
			for(int i=0;i<params.length;i++) {
				for(int j=1;j<=params[i].length;j++) {
					preparedStatement.setObject(j,params[i][j-1]);
				}
				preparedStatement.addBatch();
			}
			preparedStatement.executeBatch();
			connection.commit();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			if (connection!=null) {
				try {
					connection.rollback();
				} catch (Exception e1) {
					e1.printStackTrace();
				} 
			}
		} finally {
			close(preparedStatement, connection);
		}
    	return false;
	}
	
	/**
	 * 修改数据
	 *
	 * @author 
	 */
	public static boolean update(String sql) {
		Connection connection = null;
		Statement statement = null;
		try {
			connection = getConnection();
			statement = connection.createStatement();
			int result = statement.executeUpdate(sql);
			return result > 0;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close(statement, connection);
		}
		return false;
	}

	/**
	 * 修改数据
	 *
	 * @author
	 */
	public static boolean update(String sql, Object... param) {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = getConnection();
			preparedStatement = connection.prepareStatement(sql);
			for (int i = 1; i <= param.length; i++) {
				preparedStatement.setObject(i, param[i - 1]);
			}
			int result = preparedStatement.executeUpdate();
			return result > 0;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close(preparedStatement, connection);
		}
		return false;
	}

	/**
	 * 判断数据是否存在
	 *
	 * @author 
	 */
	public static boolean exist(String sql) {
		class RowMapper implements IRowMapper {

			boolean flag;

			@Override
			public void rowMapper(ResultSet resultSet) {
				try {
					flag = resultSet.next();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}

		}
		RowMapper rowMapper = new RowMapper();
		select(sql, rowMapper);
		return rowMapper.flag;
	}
	
	/**
	 * 判断数据是否存在
	 *
	 * @author 
	 */
	public static boolean exist(String sql, Object... params) {
		class RowMapper implements IRowMapper {

			boolean flag;

			@Override
			public void rowMapper(ResultSet resultSet) {
				try {
					flag = resultSet.next();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}

		}
		RowMapper rowMapper = new RowMapper();
		select(sql, rowMapper, params);
		return rowMapper.flag;
	}
	
	/**
	 * 查询数据
	 *
	 * @author
	 */
	public static void select(String sql, IRowMapper rowmapper) {
		Connection connection = null;
		Statement statement = null;
		ResultSet rs = null;
		try {
			connection = getConnection();
			statement = connection.createStatement();
			rs = statement.executeQuery(sql);
			rowmapper.rowMapper(rs);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close(rs, statement, connection);
		}
	}

	/**
	 * 查询数据
	 *
	 * @author 
	 */
	public static void select(String sql, IRowMapper rowmapper, Object... params) {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		ResultSet rs = null;
		try {
			connection = getConnection();
			preparedStatement = connection.prepareStatement(sql);
			for (int i = 1; i <= params.length; i++) {
				preparedStatement.setObject(i,params[i-1]);
			}
			rs = preparedStatement.executeQuery();
			rowmapper.rowMapper(rs);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close(rs, preparedStatement, connection);
		}
	}

	/**
	 * 释放资源
	 *
	 * @author 
	 */
	private static void close(Statement statement, Connection connection) {
		if (statement != null) {
			try {
				statement.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if (connection != null) {
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	/**
	 * 释放资源
	 *
	 * @author 
	 */
	private static void close(ResultSet resultSet, Statement statement, Connection connection) {
		if (resultSet != null) {
			try {
				resultSet.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		close(statement, connection);
	}
}