JDBC工具类

mysql.jdbc工具类

public class JDBCUtil {
	private static String className = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://localhost:3306/mydb";
	private static String user = "root";
	private static String password = "root";
//	注册驱动
	static {
		try {
			Class.forName(className);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

//	获得连接
	public static Connection getConnection() throws SQLException {
		Connection connection = DriverManager.getConnection(url, user, password);
		return connection;
	}

//	关闭连接
	public static void getCloseConnection(Connection connection) throws SQLException {
		connection.close();
	}

//	执行增删改的方法
	public static int executeUpdate(String sql, Object[] params) throws SQLException {
		Connection connection = getConnection();
		PreparedStatement statement = connection.prepareStatement(sql);
		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				statement.setObject(i + 1, params[i]);
			}
		}
		int n = statement.executeUpdate();
		statement.close();
		connection.close();
		return n;
	}

//	执行查询的方法
	public static ResultSet executeQuery(Connection connection, String sql, Object[] params) throws SQLException {
		PreparedStatement statement = connection.prepareStatement(sql);
		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				statement.setObject(i + 1, params[i]);
			}
		}
		ResultSet rs = statement.executeQuery();

		return rs;
	}

}