public static boolean delRow(String id) throws SQLException, IOException {
		boolean isDel = false;
		PreparedStatement prStDelRow = null;
		String query = "DELETE FROM `mobilephone` WHERE id=?";
		Connection conn = DBConnection.getConnection();

		try {
			conn.setAutoCommit(false);
			prStDelRow = conn.prepareStatement(query);
			prStDelRow.setString(1, id);
			if (prStDelRow.executeUpdate() == 1)
				isDel = true;
			conn.commit();

		} catch (SQLException e) {
			if (conn != null) {
				try {
					System.err.print("Transaction is being rolled back");
					conn.rollback();
				} catch (SQLException excep) {
					excep.printStackTrace();
				}
			}
		} finally {
			if (prStDelRow != null)
				prStDelRow.close();
			conn.setAutoCommit(true);
			if (conn != null)
				conn.close();
		}
		return isDel;
	}